Subject: CVS commit: pkgsrc/textproc/py-openpyxl
From: Adam Ciarcinski
Date: 2023-02-22 13:50:46
Message id: 20230222125046.98EB2FA90@cvs.NetBSD.org

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.

Files:
RevisionActionfile
1.30modifypkgsrc/textproc/py-openpyxl/Makefile
1.15modifypkgsrc/textproc/py-openpyxl/PLIST
1.27modifypkgsrc/textproc/py-openpyxl/distinfo