Log message:
py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays

Log message:
py-openpyxl: updated to 3.1.5

3.1.5
Bug fixes

Log message:
py-openpyxl: updated to 3.1.4

3.1.4 (2024-06-12)

Assigning named styles doesn't work
Problems caused when saving workbooks created by LibreOffice

Changes

Python 3.6 and 3.7 are no longer supported.

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

Log message:
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.

Log message:
py-openpyxl: put correct DEPENDS

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

Log message:
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.)