CVS commit: pkgsrc/textproc/py-openpyxl

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Nov 29 10:20:57 UTC 2022

Modified Files:
        pkgsrc/textproc/py-openpyxl: Makefile PLIST distinfo
        pkgsrc/textproc/py-openpyxl/patches: patch-setup.py

Log Message:
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


To generate a diff of this commit:
cvs rdiff -u -r1.27 -r1.28 pkgsrc/textproc/py-openpyxl/Makefile
cvs rdiff -u -r1.13 -r1.14 pkgsrc/textproc/py-openpyxl/PLIST
cvs rdiff -u -r1.25 -r1.26 pkgsrc/textproc/py-openpyxl/distinfo
cvs rdiff -u -r1.2 -r1.3 pkgsrc/textproc/py-openpyxl/patches/patch-setup.py

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/textproc/py-openpyxl/Makefile
diff -u pkgsrc/textproc/py-openpyxl/Makefile:1.27 pkgsrc/textproc/py-openpyxl/Makefile:1.28
--- pkgsrc/textproc/py-openpyxl/Makefile:1.27   Fri Jun 24 02:29:01 2022
+++ pkgsrc/textproc/py-openpyxl/Makefile        Tue Nov 29 10:20:57 2022
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.27 2022/06/24 02:29:01 gutteridge Exp $
+# $NetBSD: Makefile,v 1.28 2022/11/29 10:20:57 adam Exp $
 
-DISTNAME=      openpyxl-2.6.4
+DISTNAME=      openpyxl-3.0.10
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    textproc python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=o/openpyxl/}
@@ -10,10 +10,12 @@ HOMEPAGE=   https://openpyxl.readthedocs.i
 COMMENT=       Python library to read/write Excel xlsx/xlsm files
 LICENSE=       mit
 
-DEPENDS+=      ${PYPKGPREFIX}-jdcal-[0-9]*:../../time/py-jdcal
-DEPENDS+=      ${PYPKGPREFIX}-lxml-[0-9]*:../../textproc/py-lxml
+#DEPENDS+=     ${PYPKGPREFIX}-jdcal-[0-9]*:../../time/py-jdcal
+DEPENDS+=      ${PYPKGPREFIX}-et_xmlfile-[0-9]*:../../textproc/py-et_xmlfile
 
 USE_LANGUAGES= # none
 
+PYTHON_VERSIONS_INCOMPATIBLE=  27
+
 .include "../../lang/python/egg.mk"
 .include "../../mk/bsd.pkg.mk"

Index: pkgsrc/textproc/py-openpyxl/PLIST
diff -u pkgsrc/textproc/py-openpyxl/PLIST:1.13 pkgsrc/textproc/py-openpyxl/PLIST:1.14
--- pkgsrc/textproc/py-openpyxl/PLIST:1.13      Mon Apr  1 09:12:03 2019
+++ pkgsrc/textproc/py-openpyxl/PLIST   Tue Nov 29 10:20:57 2022
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.13 2019/04/01 09:12:03 adam Exp $
+@comment $NetBSD: PLIST,v 1.14 2022/11/29 10:20:57 adam Exp $
 ${PYSITELIB}/${EGG_INFODIR}/PKG-INFO
 ${PYSITELIB}/${EGG_INFODIR}/SOURCES.txt
 ${PYSITELIB}/${EGG_INFODIR}/dependency_links.txt
@@ -172,21 +172,18 @@ ${PYSITELIB}/openpyxl/compat/__init__.py
 ${PYSITELIB}/openpyxl/compat/abc.py
 ${PYSITELIB}/openpyxl/compat/abc.pyc
 ${PYSITELIB}/openpyxl/compat/abc.pyo
-${PYSITELIB}/openpyxl/compat/accumulate.py
-${PYSITELIB}/openpyxl/compat/accumulate.pyc
-${PYSITELIB}/openpyxl/compat/accumulate.pyo
 ${PYSITELIB}/openpyxl/compat/numbers.py
 ${PYSITELIB}/openpyxl/compat/numbers.pyc
 ${PYSITELIB}/openpyxl/compat/numbers.pyo
+${PYSITELIB}/openpyxl/compat/product.py
+${PYSITELIB}/openpyxl/compat/product.pyc
+${PYSITELIB}/openpyxl/compat/product.pyo
 ${PYSITELIB}/openpyxl/compat/singleton.py
 ${PYSITELIB}/openpyxl/compat/singleton.pyc
 ${PYSITELIB}/openpyxl/compat/singleton.pyo
 ${PYSITELIB}/openpyxl/compat/strings.py
 ${PYSITELIB}/openpyxl/compat/strings.pyc
 ${PYSITELIB}/openpyxl/compat/strings.pyo
-${PYSITELIB}/openpyxl/conftest.py
-${PYSITELIB}/openpyxl/conftest.pyc
-${PYSITELIB}/openpyxl/conftest.pyo
 ${PYSITELIB}/openpyxl/descriptors/__init__.py
 ${PYSITELIB}/openpyxl/descriptors/__init__.pyc
 ${PYSITELIB}/openpyxl/descriptors/__init__.pyo

Index: pkgsrc/textproc/py-openpyxl/distinfo
diff -u pkgsrc/textproc/py-openpyxl/distinfo:1.25 pkgsrc/textproc/py-openpyxl/distinfo:1.26
--- pkgsrc/textproc/py-openpyxl/distinfo:1.25   Fri Jun 24 02:29:01 2022
+++ pkgsrc/textproc/py-openpyxl/distinfo        Tue Nov 29 10:20:57 2022
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.25 2022/06/24 02:29:01 gutteridge Exp $
+$NetBSD: distinfo,v 1.26 2022/11/29 10:20:57 adam Exp $
 
-BLAKE2s (openpyxl-2.6.4.tar.gz) = 201e406f67029e2dd6519da8840ac97a20c3441d1212ead614febd9f99f2448d
-SHA512 (openpyxl-2.6.4.tar.gz) = e2785d583d7c9bcc77ffe571dad115089dc7b9ff1e8b03dd6ed4ed8ff1405d31115b52792ed7af98a1bab4bc00f3f770c77b681798c4c9eba2b618cf6bc4fb2f
-Size (openpyxl-2.6.4.tar.gz) = 173728 bytes
-SHA1 (patch-setup.py) = ef477ee5b3293769be122ab7bb4299e10f79f965
+BLAKE2s (openpyxl-3.0.10.tar.gz) = 2988c35f1f871aaf400d710d204da55628020dfd9d69c9a05a425233979e40f0
+SHA512 (openpyxl-3.0.10.tar.gz) = f77b8d6fbbf171f59bd0cfe63e1ed1ee063d29d3d5a6b2ca1c58b129cf49cbb12641fdc8da8da089268efdd7d70a9199f40770c0bf8e17282fb47f805d28ebe9
+Size (openpyxl-3.0.10.tar.gz) = 179688 bytes
+SHA1 (patch-setup.py) = 9b2fd5f1e4d77060487c6c9a862be207df8de70f

Index: pkgsrc/textproc/py-openpyxl/patches/patch-setup.py
diff -u pkgsrc/textproc/py-openpyxl/patches/patch-setup.py:1.2 pkgsrc/textproc/py-openpyxl/patches/patch-setup.py:1.3
--- pkgsrc/textproc/py-openpyxl/patches/patch-setup.py:1.2      Fri Feb  8 10:48:38 2019
+++ pkgsrc/textproc/py-openpyxl/patches/patch-setup.py  Tue Nov 29 10:20:57 2022
@@ -1,15 +1,15 @@
-$NetBSD: patch-setup.py,v 1.2 2019/02/08 10:48:38 adam Exp $
+$NetBSD: patch-setup.py,v 1.3 2022/11/29 10:20:57 adam Exp $
 
-Prefer lxml to et_xmlfile.
+Prefer lxml to et_xmlfile; the latter is a subset of the former.
 
---- setup.py.orig      2019-02-06 14:12:51.000000000 +0000
+--- setup.py.orig      2022-03-08 15:06:53.000000000 +0000
 +++ setup.py
-@@ -59,7 +59,7 @@ setup(
+@@ -76,7 +76,7 @@ setup(
      license=__license__,
-     python_requires=">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*",
+     python_requires=f">={__python__}",
      install_requires=[
--        'jdcal', 'et_xmlfile',
-+        'jdcal', 'lxml',
+-        'et_xmlfile',
++        'lxml',
          ],
      project_urls={
          'Documentation': 'https://openpyxl.readthedocs.io/en/stable/',