head 1.31; access; symbols pkgsrc-2023Q4:1.31.0.8 pkgsrc-2023Q4-base:1.31 pkgsrc-2023Q3:1.31.0.6 pkgsrc-2023Q3-base:1.31 pkgsrc-2023Q2:1.31.0.4 pkgsrc-2023Q2-base:1.31 pkgsrc-2023Q1:1.31.0.2 pkgsrc-2023Q1-base:1.31 pkgsrc-2022Q4:1.29.0.2 pkgsrc-2022Q4-base:1.29 pkgsrc-2022Q3:1.27.0.4 pkgsrc-2022Q3-base:1.27 pkgsrc-2022Q2:1.27.0.2 pkgsrc-2022Q2-base:1.27 pkgsrc-2022Q1:1.26.0.2 pkgsrc-2022Q1-base:1.26 pkgsrc-2021Q4:1.25.0.20 pkgsrc-2021Q4-base:1.25 pkgsrc-2021Q3:1.25.0.18 pkgsrc-2021Q3-base:1.25 pkgsrc-2021Q2:1.25.0.16 pkgsrc-2021Q2-base:1.25 pkgsrc-2021Q1:1.25.0.14 pkgsrc-2021Q1-base:1.25 pkgsrc-2020Q4:1.25.0.12 pkgsrc-2020Q4-base:1.25 pkgsrc-2020Q3:1.25.0.10 pkgsrc-2020Q3-base:1.25 pkgsrc-2020Q2:1.25.0.8 pkgsrc-2020Q2-base:1.25 pkgsrc-2020Q1:1.25.0.4 pkgsrc-2020Q1-base:1.25 pkgsrc-2019Q4:1.25.0.6 pkgsrc-2019Q4-base:1.25 pkgsrc-2019Q3:1.25.0.2 pkgsrc-2019Q3-base:1.25 pkgsrc-2019Q2:1.23.0.2 pkgsrc-2019Q2-base:1.23 pkgsrc-2019Q1:1.22.0.2 pkgsrc-2019Q1-base:1.22 pkgsrc-2018Q4:1.19.0.2 pkgsrc-2018Q4-base:1.19 pkgsrc-2018Q3:1.14.0.2 pkgsrc-2018Q3-base:1.14 pkgsrc-2018Q2:1.11.0.2 pkgsrc-2018Q2-base:1.11 pkgsrc-2018Q1:1.7.0.2 pkgsrc-2018Q1-base:1.7 pkgsrc-2017Q4:1.4.0.2 pkgsrc-2017Q4-base:1.4 pkgsrc-2017Q3:1.3.0.6 pkgsrc-2017Q3-base:1.3 pkgsrc-2017Q2:1.3.0.2 pkgsrc-2017Q2-base:1.3 pkgsrc-2017Q1:1.2.0.8 pkgsrc-2017Q1-base:1.2 pkgsrc-2016Q4:1.2.0.6 pkgsrc-2016Q4-base:1.2 pkgsrc-2016Q3:1.2.0.4 pkgsrc-2016Q3-base:1.2 pkgsrc-2016Q2:1.2.0.2 pkgsrc-2016Q2-base:1.2 pkgsrc-2016Q1:1.1.1.1.0.12 pkgsrc-2016Q1-base:1.1.1.1 pkgsrc-2015Q4:1.1.1.1.0.10 pkgsrc-2015Q4-base:1.1.1.1 pkgsrc-2015Q3:1.1.1.1.0.8 pkgsrc-2015Q3-base:1.1.1.1 pkgsrc-2015Q2:1.1.1.1.0.6 pkgsrc-2015Q2-base:1.1.1.1 pkgsrc-2015Q1:1.1.1.1.0.4 pkgsrc-2015Q1-base:1.1.1.1 pkgsrc-2014Q4:1.1.1.1.0.2 pkgsrc-2014Q4-base:1.1.1.1 pkgsrc-base:1.1.1.1 TNF:1.1.1; locks; strict; comment @# @; 1.31 date 2023.03.17.08.22.07; author adam; state Exp; branches; next 1.30; commitid FeZ523doorG88shE; 1.30 date 2023.02.22.12.50.46; author adam; state Exp; branches; next 1.29; commitid PtyO9aEPwXpZlweE; 1.29 date 2022.11.29.16.31.53; author adam; state Exp; branches; next 1.28; commitid 6jFAfvPext1ujC3E; 1.28 date 2022.11.29.10.20.57; author adam; state Exp; branches; next 1.27; commitid oEfy4u5XUYxKfA3E; 1.27 date 2022.06.24.02.29.01; author gutteridge; state Exp; branches; next 1.26; commitid Cqx6Mell7y83IeJD; 1.26 date 2022.01.04.20.55.01; author wiz; state Exp; branches; next 1.25; commitid CYyhdK9qtoffkmnD; 1.25 date 2019.08.20.07.10.58; author adam; state Exp; branches; next 1.24; commitid V1ZnkVNhgV3rGJzB; 1.24 date 2019.07.09.11.35.14; author nia; state Exp; branches; next 1.23; commitid Vdt6OsIXLcYRumuB; 1.23 date 2019.04.01.09.12.03; author adam; state Exp; branches; next 1.22; commitid FGZBSteFyCcYSChB; 1.22 date 2019.03.04.18.50.37; author adam; state Exp; branches; next 1.21; commitid 5MgkENUK3RnbZ4eB; 1.21 date 2019.02.08.10.48.38; author adam; state Exp; branches; next 1.20; commitid Xl6TLJnTYkTy5XaB; 1.20 date 2019.01.24.09.13.52; author adam; state Exp; branches; next 1.19; commitid 2A3v4PcCFYr6319B; 1.19 date 2018.11.29.18.38.16; author adam; state Exp; branches; next 1.18; commitid pJUK6c2g327iYR1B; 1.18 date 2018.11.23.11.42.17; author adam; state Exp; branches; next 1.17; commitid 4SxemCTF4C7CR31B; 1.17 date 2018.11.14.09.09.47; author adam; state Exp; branches; next 1.16; commitid rB2CUeWAjoa9jTZA; 1.16 date 2018.10.23.06.46.45; author adam; state Exp; branches; next 1.15; commitid MeyNc4X9l3mSd3XA; 1.15 date 2018.10.01.17.51.32; author adam; state Exp; branches; next 1.14; commitid xl5BtFMwCugVBhUA; 1.14 date 2018.09.17.10.17.37; author adam; state Exp; branches; next 1.13; commitid hpvAHKlgaAv4yrSA; 1.13 date 2018.08.31.07.29.11; author adam; state Exp; branches; next 1.12; commitid YnpKMPjC6p9cafQA; 1.12 date 2018.08.06.20.15.45; author adam; state Exp; branches; next 1.11; commitid H8Zvbsp9vnjXc6NA; 1.11 date 2018.06.15.07.36.36; author adam; state Exp; branches; next 1.10; commitid 92vIrgQfRCK9GlGA; 1.10 date 2018.05.02.10.53.26; author markd; state Exp; branches; next 1.9; commitid Ih7pTWBgGlDfaIAA; 1.9 date 2018.04.23.12.01.48; author adam; state Exp; branches; next 1.8; commitid YpjkZz7oBdJJQyzA; 1.8 date 2018.04.07.20.13.02; author adam; state Exp; branches; next 1.7; commitid g31ASsfgxp875yxA; 1.7 date 2018.03.12.16.29.14; author adam; state Exp; branches; next 1.6; commitid 5mfXxMt7mhyhGbuA; 1.6 date 2018.02.13.11.49.38; author adam; state Exp; branches; next 1.5; commitid WAoXdiZDtAcUZGqA; 1.5 date 2018.01.27.08.35.58; author wiz; state Exp; branches; next 1.4; commitid O0TZGDMhVSSwtuoA; 1.4 date 2017.10.30.10.10.20; author adam; state Exp; branches; next 1.3; commitid dhgOPSWYe2YeR3dA; 1.3 date 2017.06.01.16.58.27; author adam; state Exp; branches; next 1.2; commitid 4I7PzPd3lzFbYGTz; 1.2 date 2016.06.08.17.43.42; author wiz; state Exp; branches; next 1.1; commitid z4yEulWexjFaJG9z; 1.1 date 2014.10.25.22.19.45; author cheusov; state Exp; branches 1.1.1.1; next ; commitid PwyMKtaoiOnvhDVx; 1.1.1.1 date 2014.10.25.22.19.45; author cheusov; state Exp; branches; next ; commitid PwyMKtaoiOnvhDVx; desc @@ 1.31 log @py-openpyxl: updated to 3.1.2 3.1.2 Cannot read worksheets in read-only mode with locally scoped definitions Empty custom properties cause invalid files @ text @# $NetBSD: Makefile,v 1.30 2023/02/22 12:50:46 adam Exp $ DISTNAME= openpyxl-3.1.2 PKGNAME= ${PYPKGPREFIX}-${DISTNAME} CATEGORIES= textproc python MASTER_SITES= ${MASTER_SITE_PYPI:=o/openpyxl/} MAINTAINER= kamelderouiche@@yahoo.com HOMEPAGE= https://openpyxl.readthedocs.io/ COMMENT= Python library to read/write Excel xlsx/xlsm files LICENSE= mit DEPENDS+= ${PYPKGPREFIX}-lxml-[0-9]*:../../textproc/py-lxml USE_LANGUAGES= # none PYTHON_VERSIONS_INCOMPATIBLE= 27 .include "../../lang/python/egg.mk" .include "../../mk/bsd.pkg.mk" @ 1.30 log @py-openpyxl: updated to 3.1.1 3.1.1 (2023-02-13) Bugfixes * DocumentProperties times set by module import only * Worksheet-specific definitions are missing 3.1.0 (2023-01-31) New Features Added support for data table formulae Mapped chartspace graphical properties to charts for advanced formatting Bugfixes * Table filters are always overriden * Can’t read some ScatterCharts if n * Problem with multilevel indices in dataframes * Problem with category indices in dataframes * NamedStyles share attributes - mutables gotcha * Allow print area to be set to None * Worksheet for print title and print areas can’t be found * Custom document properties that are strings can be empty * ConditionalFormatting lost when pivot table updated * Better handling of defined names * dataframe_to_rows() misalignment on multiindex * Ditto * Excel doesn’t like xmlns:space on nodes with only whitespace, which it treats as empty. * Exception when print areas use table references. Pull Requests Support for Rich Text in cells Provide more information when workbook cannot be loaded Support for Custom Document Properties Deprecations The following properties have been removed from worksheets: formula_attributes, page_breaks, show_summary_below, show_summary_right, page_size orientation. Client code should use the relevant objects. Removals The following deprecated methods have been removed from workbooks: get_named_range, add_named_range, remove_named_range. And the get_emu_dimesions from images. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.29 2022/11/29 16:31:53 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-3.1.1 @ 1.29 log @py-openpyxl: put correct DEPENDS @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.28 2022/11/29 10:20:57 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-3.0.10 @ 1.28 log @py-openpyxl: updated to 3.0.10 3.0.10 (2021-05-13) Bugfixes * Image files not closed when workbooks are saved * Problem with missing scope attribute in Pivot Table formats * Excel unhappy when multiple sorts are defined 3.0.9 (2021-09-22) Bugfixes * Ignore blank ignored in existing Data Validations * Add support for cell protection for merged cell ranges * Timezone-aware datetimes raise an Exception * Improved normalisation of chart series * Catch OverflowError for out of range datetimes * Alignment.relativeIndent can be negative * Incorrect default value groupBy attribute 3.0.8 (brown bag) Deleted because it contained breaking changes from 3.1 3.0.7 (2021-03-09) Bugfixes * Problems with zero time values * Not possible to correctly convert excel dates to timedelta * Exception raised when merging cells which do not have borders all the way round. * Python 2 print statement in the tutorial Pull Requests * Add documentation on datetime handling * Drop dependency on jdcal * Datetime rounding * Unify handling of 1900 epoch * Add explicit support for reading datetime deltas * Millisecond precision for datetimes 3.0.6 (2021-01-14) Bugfixes * Borders in differential styles are incorrect * Error when opening some pivot tables * Resave breaks the border format in conditional formatting rules * Read-only workbook not closed properly if generator interrupted * Pandas.Multiindex.labels deprecated * Pandas.Multiinex not expanded correctly * Cannot read rows with exponents * numpy.float is deprecated * Cells without coordinate attributes not always correctly handled Pull Requests * Improved handling of borders for differential styles * Support subclasses of datetime objects * Improved handling of cells without coordinates 3.0.5 (2020-08-21) Bugfixes * Incorrectly consider currency format as datetime * Cannot copy worksheets with merged cells * Empty worksheets do not return generators when looping. * Hyperlinks duplicated on multiple saves * Incorrectly literal format as datetime * Links set to range of cells not preserved * Exception when opening workbook with chartsheets and tables 3.0.4 (2020-06-24) Bugfixes * Find tables by name * Worksheet protection missing in existing files * Exception when reading files with external images * Reading lots of merged cells is very slow. * Read support for Bubble Charts. * Preserve any indexed colours * Reading many thousand of merged cells is really slow. * Adding tables in write-only mode raises an exception. Pull Requests * Add support for finding tables by name or range. 3.0.3 (2020-01-20) Bugfixes * Exception when handling merged cells with hyperlinks * Problems when both lxml and defusedxml are installed * CFVO with incorrect values cannot be processed 3.0.2 (2019-11-25) Bug fixes * DeprecationError if both defusedxml and lxml are installed * ws._current_row is higher than ws.max_row * Border bottom style is not optional when it should be * Empty cells in read-only, values-only mode are sometimes returned as ReadOnlyCells * Cannot add page breaks to existing worksheets if none exist already Pull Requests * Improvements to the documentation 3.0.1 (2019-11-14) Bugfixes * Cannot read empty charts. Pull Requests * Fix for 1250 * TableStyleElement is a sequence 3.0.0 (2019-09-25) Python 3.6+ only release @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.27 2022/06/24 02:29:01 gutteridge Exp $ d13 1 a13 2 #DEPENDS+= ${PYPKGPREFIX}-jdcal-[0-9]*:../../time/py-jdcal DEPENDS+= ${PYPKGPREFIX}-et_xmlfile-[0-9]*:../../textproc/py-et_xmlfile @ 1.27 log @py-openpyxl: update to 2.6.4 This is a release with a single bug fix that corrects a file corruption issue. Cannot save workbooks with comments more than once. https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1330 (There is a newer 3.x branch with many more changes since, but it drops Python 2.7 support and is more involved, so can't be committed during the pkgsrc freeze.) @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.26 2022/01/04 20:55:01 wiz Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.6.4 d13 2 a14 2 DEPENDS+= ${PYPKGPREFIX}-jdcal-[0-9]*:../../time/py-jdcal DEPENDS+= ${PYPKGPREFIX}-lxml-[0-9]*:../../textproc/py-lxml d18 2 @ 1.26 log @*: bump PKGREVISION for egg.mk users They now have a tool dependency on py-setuptools instead of a DEPENDS @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.25 2019/08/20 07:10:58 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.6.3 a4 1 PKGREVISION= 1 d10 1 a10 1 COMMENT= Python library to read/write Excel 2007 xlsx/xlsm files @ 1.25 log @py-openpyxl: updated to 2.6.3 2.6.3: Bugfixes * Fix 3D charts. * Minimum for holeSize in Doughnut charts too high * Warning for MergedCells with comments * Pagebreaks duplicated * Workbook has no default CellStyle @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.24 2019/07/09 11:35:14 nia Exp $ d5 1 @ 1.24 log @Use https for readthedocs.io. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.23 2019/04/01 09:12:03 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.6.2 @ 1.23 log @py-openpyxl: updated to 2.6.2 2.6.2: Bugfixes * Workbook has no _date_formats attribute * Cannot create charts for worksheets with quotes in the title * MergedCells not removed when range is unmerged * Link to pivot table lost from charts * Chart colours change after saving * Cannot use ws.cell in read-only mode with Python 2.7 @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.22 2019/03/04 18:50:37 adam Exp $ d9 1 a9 1 HOMEPAGE= http://openpyxl.readthedocs.io/ @ 1.22 log @py-openpyxl: updated to 2.6.1 2.6.1: Bugfixes * ReadOnlyCell.is_date does not work properly * Cannot read Google Docs spreadsheet with a Pivot Table * Charts created with openpyxl cannot be styled * Cannot handle some numpy number types * Exception when reading unknowable number formats * Only last formatting rule for a range loaded * Give MergedCell a value attribute * Cannot process worksheets with comments * Cannot process worksheets with both row and page breaks * Cannot reset dimensions in ReadOnlyWorksheets * Incorrect descriptor in ParagraphProperties * Missing hier attribute in PageField raises an exception @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.21 2019/02/08 10:48:38 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.6.1 @ 1.21 log @py-openpyxl: updated to 2.6.0 2.6.0: Bugfixes * Exception on tables with names containing spaces. * Cannot save files with existing images. 2.6.-b1: Bugfixes * Cannot use read-only mode with stream * Hyperlinks always set on A1 * Internal row counter not initialised when reading files * Exception raised on out of bounds date 2.6-a1: Major changes Implement robust for merged cells so that these can be formatted the way Excel does without confusion. Thanks to Magnus Schieder. Minor changes Add support for worksheet scenarios Add read support for chartsheets Add method for moving ranges of cells on a worksheet Last version to support Python 2.7 Deprecations Type inference and coercion for cell values @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.20 2019/01/24 09:13:52 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.6.0 @ 1.20 log @py-openpyxl: updated to 2.5.14 2.5.14: Bugfixes Correct typo in LineProperties Exception raised for unsupported image files Exception raised when cannot find source for non-local cache object Pull Requests Add support for nested brackets to the tokeniser Improvements on handling nested brackets in the tokeniser @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.19 2018/11/29 18:38:16 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.14 @ 1.19 log @py-openpyxl: updated to 2.5.12 2.5.12: Bugfixes * Overwriting default font in Normal style affects library default * Images not added to anchors. * Cannot read pivot table formats without dxId * Repeated registration of simple filter could lead to memory leaks @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.18 2018/11/23 11:42:17 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.12 @ 1.18 log @py-openpyxl: updated to 2.5.11 2.5.11: * Improved handling of missing rows * Add support for defined names to tokeniser @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.17 2018/11/14 09:09:47 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.11 @ 1.17 log @py-openpyxl: updated to 2.5.10 2.5.10: Bugfixes * Empty column dimensions should not be saved. Pull Requests * Tokenizer failure for quoted sheet name in second half of range * Improved error detection in ranges. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.16 2018/10/23 06:46:45 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.10 a17 5 SUBST_CLASSES+= requires SUBST_STAGE.requires= post-install SUBST_FILES.requires= ${DESTDIR}${PREFIX}/${PYSITELIB}/${EGG_INFODIR}/requires.txt SUBST_SED.requires= -e '/et_xmlfile/d' @ 1.16 log @py-openpyxl: updated to 2.5.9 2.5.9: Bugfixes * Clean AutoFilter name definitions * Attribute missing from Shape object * Failure to read all DrawingML means workbook can't be read Pull Requests * Allow newlines in formulae * Fix whitespace in front of infix operator in formulae @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.15 2018/10/01 17:51:32 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.9 a22 3 post-extract: ${RM} ${WRKSRC}/openpyxl.egg-info/.DS_Store @ 1.15 log @py-openpyxl: updated to 2.5.8 2.5.8: Cannot control how missing values are displayed in charts. Cell references can’t be used for chart titles Params in iter_cols and iter_rows methods are slightly wrong. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.14 2018/09/17 10:17:37 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.8 @ 1.14 log @py-openpyxl: updated to 2.5.7 2.5.7: Sheet title containing % need quoting in references Cannot set quote prefix Pandas timestamps raise KeyError @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.13 2018/08/31 07:29:11 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.7 @ 1.13 log @py-openpyxl: updated to 2.5.6 2.5.6: Read-only mode can leave find-handles open when reading dimensions Set a worksheet directly as active Internal row counter not adjusted when rows are deleted or inserted @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.12 2018/08/06 20:15:45 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.6 @ 1.12 log @py-openpyxl: updated to 2.5.5 2.5.5: Bugfixes Files with Mac epoch are read incorrectly Cannot copy merged cells Cannot access ws.active_cell Pull Requests Introduce read-support for images @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.11 2018/06/15 07:36:36 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.5 @ 1.11 log @py-openpyxl: updated to 2.5.4 2.5.4: Fix: Cannot read files with 3D charts. Fix: Merged cells take a long time to parse Minor changes Improve read support for pivot tables and don't always create a Filters child for filterColumn objects. Support folding rows @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.10 2018/05/02 10:53:26 markd Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.4 @ 1.10 log @py-openpyxl: remove et_xmlfile from requires.txt et_xmlfile is only used if lxml isn't and we have dependency on py-lxml so remove from requires.txt to keep pip happy. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.8 2018/04/07 20:13:02 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.3 a4 1 PKGREVISION= 1 a12 1 DEPENDS+= ${PYPKGPREFIX}-cElementTree-[0-9]*:../../textproc/py-cElementTree @ 1.9 log @py-openpyxl: updated to 2.5.3 2.5.3: Bugfixes: * Warning level too aggressive. * Alignment and protection values not saved for named styles. * Deleting elements from a legend doesn’t work. * Index names repeated for every row in dataframe. * Worksheet protection not being stored. * Exception raised when reading a tooltip. @ text @d5 1 d20 5 @ 1.8 log @py-openpyxl: updated to 2.5.2 2.5.2: Bugfixes * High memory use when reading text-heavy files. * Copying merged cells copies references. * Cannot set comment size. * Exception when trying to save workbooks with no views. * Cannot delete last row or column. * Cannot read Drawings containing embedded images. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.7 2018/03/12 16:29:14 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.2 d14 1 a15 1 DEPENDS+= ${PYPKGPREFIX}-jdcal-[0-9]*:../../time/py-jdcal @ 1.7 log @py-openpyxl: updated to 2.5.1 2.5.1: Bug fixes. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.6 2018/02/13 11:49:38 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.1 @ 1.6 log @py-openpyxl: updated to 2.5.0 2.5.0: Minor changes Correct definition for Connection Shapes. 2.5.0-b2: Bugfixes TableStyleInfo has no required attributes Cannot read files with 3D drawings Incorrect version check in installer Cell merging uses transposed parameters ExtLst missing keyword for PivotFields Inf causes problems for Excel Cannot load table styles with custom names Major Changes You can now insert and delete rows and columns in worksheets Minor Changes pip now handles which Python versions can be used. 2.5.0-b1: Bugfixes Explicitly support for multiple cell ranges in conditonal formatting Non-contiguous cell ranges in validators get merged Empty data validators create invalid Excel files Large validation ranges use lots of memory Unicode in chart axes not handled correctly in Python 2 ScatterCharts have defective axes Charts with empty numVal elements cannot be read Scaling options from existing files ignored Charts with PivotSource cannot be read Cannot read gradient fills Quotes in number formats could be treated as datetimes @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.5 2018/01/27 08:35:58 wiz Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.5.0 d17 1 a17 1 USE_LANGUAGES= # none @ 1.5 log @py-openpyxl: add required py-cElementTree dependency From Fekete, Zoltán in PR 52953. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.4 2017/10/30 10:10:20 adam Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.4.9 a4 1 PKGREVISION= 1 @ 1.4 log @py-openpyxl: updated to 2.4.9 2.4.9 (2017-10-19) Bugfixes * 809 Incomplete documentation of copy_worksheet method * 811 Scoped definedNames not removed when worksheet is deleted * 824 Raise an exception if a chart is used in multiple sheets * 842 Non-ASCII table column headings cause an exception in Python 2 * 846 Conditional formats not supported in write-only mode * 849 Conditional formats with no sqref cause an exception * 859 Headers that start with a number conflict with font size * 902 TableStyleElements don’t always have a condtional format * 908 Read-only mode sometimes returns too many cells Pull requests * 179 Cells kept in a set * 180 Support for Workbook protection * 182 Read support for page breaks * 183 Improve documentation of copy_worksheet method * 198 Fix @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.3 2017/06/01 16:58:27 adam Exp $ d5 1 d14 1 @ 1.3 log @2.4.8 (2017-05-30) Bugfixes * AutoFilter.sortState being assignd to the ws.sortState * Cannot open files created by Microsoft Dynamics` * Negative percents not case correctly` * Runtime imports can cause deadlock` Minor changes * Preserve any table styles @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.2 2016/06/08 17:43:42 wiz Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.4.8 d5 1 a5 1 CATEGORIES= textproc d18 3 @ 1.2 log @Switch to MASTER_SITES_PYPI. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.1.1.1 2014/10/25 22:19:45 cheusov Exp $ d3 1 a3 1 DISTNAME= openpyxl-2.1.2 d9 1 a9 1 HOMEPAGE= http://openpyxl.readthedocs.org/ d13 4 a16 1 USE_LANGUAGES= # none @ 1.1 log @Initial revision @ text @d1 1 a1 1 # $NetBSD$ d6 1 a6 1 MASTER_SITES= https://pypi.python.org/packages/source/o/openpyxl/ @ 1.1.1.1 log @Imported from wip/py-openpyxl openpyxl is a pure python reader and writer of Excel OpenXML files. It was born from lack of existing library to read/write natively from Python the new Office Open XML format. All kudos to the PHPExcel team as openpyxl is a Python port of PHPExcel http://www.phpexcel.net/ @ text @@