The NetBSD Project

CVS log for pkgsrc/textproc/py-openpyxl/distinfo

[BACK] Up to [] / pkgsrc / textproc / py-openpyxl

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.28 / (download) - annotate - [select for diffs], Fri Mar 17 08:22:07 2023 UTC (6 months, 1 week ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, HEAD
Changes since 1.27: +4 -4 lines
Diff to previous 1.27 (colored)

py-openpyxl: updated to 3.1.2

Cannot read worksheets in read-only mode with locally scoped definitions
Empty custom properties cause invalid files

Revision 1.27 / (download) - annotate - [select for diffs], Wed Feb 22 12:50:46 2023 UTC (7 months ago) by adam
Branch: MAIN
Changes since 1.26: +4 -4 lines
Diff to previous 1.26 (colored)

py-openpyxl: updated to 3.1.1

3.1.1 (2023-02-13)


* 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


* Table filters are always overriden
* Can 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 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 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


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.


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.

Revision 1.26 / (download) - annotate - [select for diffs], Tue Nov 29 10:20:57 2022 UTC (9 months, 4 weeks ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2022Q4-base, pkgsrc-2022Q4
Changes since 1.25: +5 -5 lines
Diff to previous 1.25 (colored)

py-openpyxl: updated to 3.0.10

3.0.10 (2021-05-13)


* 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)


* 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)


* 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)


* 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)


* 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)


* 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)


* 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)


* Cannot read empty charts.

Pull Requests

* Fix for 1250
* TableStyleElement is a sequence

3.0.0 (2019-09-25)

Python 3.6+ only release

Revision 1.25 / (download) - annotate - [select for diffs], Fri Jun 24 02:29:01 2022 UTC (15 months ago) by gutteridge
Branch: MAIN
CVS Tags: pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2
Changes since 1.24: +4 -4 lines
Diff to previous 1.24 (colored)

py-openpyxl: update to 2.6.4

This is a release with a single bug fix that corrects a file corruption

Cannot save workbooks with comments more than once.

(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.)

Revision 1.24 / (download) - annotate - [select for diffs], Tue Oct 26 11:23:09 2021 UTC (23 months ago) by nia
Branch: MAIN
CVS Tags: pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4
Changes since 1.23: +2 -2 lines
Diff to previous 1.23 (colored)

textproc: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

Unfetchable distfiles (fetched conditionally?):

Revision 1.23 / (download) - annotate - [select for diffs], Thu Oct 7 15:02:16 2021 UTC (23 months, 2 weeks ago) by nia
Branch: MAIN
Changes since 1.22: +1 -2 lines
Diff to previous 1.22 (colored)

textproc: Remove SHA1 hashes for distfiles

Revision 1.22 / (download) - annotate - [select for diffs], Tue Aug 20 07:10:58 2019 UTC (4 years, 1 month ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3
Changes since 1.21: +5 -5 lines
Diff to previous 1.21 (colored)

py-openpyxl: updated to 2.6.3

* Fix 3D charts.
* Minimum for holeSize in Doughnut charts too high
* Warning for MergedCells with comments
* Pagebreaks duplicated
* Workbook has no default CellStyle

Revision 1.21 / (download) - annotate - [select for diffs], Mon Apr 1 09:12:03 2019 UTC (4 years, 5 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2
Changes since 1.20: +5 -5 lines
Diff to previous 1.20 (colored)

py-openpyxl: updated to 2.6.2

* 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

Revision 1.20 / (download) - annotate - [select for diffs], Mon Mar 4 18:50:37 2019 UTC (4 years, 6 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2019Q1-base, pkgsrc-2019Q1
Changes since 1.19: +5 -5 lines
Diff to previous 1.19 (colored)

py-openpyxl: updated to 2.6.1

* 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

Revision 1.19 / (download) - annotate - [select for diffs], Fri Feb 8 10:48:38 2019 UTC (4 years, 7 months ago) by adam
Branch: MAIN
Changes since 1.18: +6 -6 lines
Diff to previous 1.18 (colored)

py-openpyxl: updated to 2.6.0

* Exception on tables with names containing spaces.
* Cannot save files with existing images.

* 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

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

Type inference and coercion for cell values

Revision 1.18 / (download) - annotate - [select for diffs], Thu Jan 24 09:13:52 2019 UTC (4 years, 8 months ago) by adam
Branch: MAIN
Changes since 1.17: +5 -5 lines
Diff to previous 1.17 (colored)

py-openpyxl: updated to 2.5.14


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

Revision 1.17 / (download) - annotate - [select for diffs], Thu Nov 29 18:38:16 2018 UTC (4 years, 9 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q4-base, pkgsrc-2018Q4
Changes since 1.16: +5 -5 lines
Diff to previous 1.16 (colored)

py-openpyxl: updated to 2.5.12


* 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

Revision 1.16 / (download) - annotate - [select for diffs], Fri Nov 23 11:42:17 2018 UTC (4 years, 10 months ago) by adam
Branch: MAIN
Changes since 1.15: +6 -5 lines
Diff to previous 1.15 (colored)

py-openpyxl: updated to 2.5.11

* Improved handling of missing rows
* Add support for defined names to tokeniser

Revision 1.15 / (download) - annotate - [select for diffs], Wed Nov 14 09:09:47 2018 UTC (4 years, 10 months ago) by adam
Branch: MAIN
Changes since 1.14: +5 -5 lines
Diff to previous 1.14 (colored)

py-openpyxl: updated to 2.5.10


* 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.

Revision 1.14 / (download) - annotate - [select for diffs], Tue Oct 23 06:46:45 2018 UTC (4 years, 11 months ago) by adam
Branch: MAIN
Changes since 1.13: +5 -5 lines
Diff to previous 1.13 (colored)

py-openpyxl: updated to 2.5.9


* 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

Revision 1.13 / (download) - annotate - [select for diffs], Mon Oct 1 17:51:32 2018 UTC (4 years, 11 months ago) by adam
Branch: MAIN
Changes since 1.12: +5 -5 lines
Diff to previous 1.12 (colored)

py-openpyxl: updated to 2.5.8

Cannot control how missing values are displayed in charts.
Cell references can be used for chart titles
Params in iter_cols and iter_rows methods are slightly wrong.

Revision 1.12 / (download) - annotate - [select for diffs], Mon Sep 17 10:17:37 2018 UTC (5 years ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q3-base, pkgsrc-2018Q3
Changes since 1.11: +5 -5 lines
Diff to previous 1.11 (colored)

py-openpyxl: updated to 2.5.7

Sheet title containing % need quoting in references
Cannot set quote prefix
Pandas timestamps raise KeyError

Revision 1.11 / (download) - annotate - [select for diffs], Fri Aug 31 07:29:11 2018 UTC (5 years ago) by adam
Branch: MAIN
Changes since 1.10: +5 -5 lines
Diff to previous 1.10 (colored)

py-openpyxl: updated to 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

Revision 1.10 / (download) - annotate - [select for diffs], Mon Aug 6 20:15:45 2018 UTC (5 years, 1 month ago) by adam
Branch: MAIN
Changes since 1.9: +5 -5 lines
Diff to previous 1.9 (colored)

py-openpyxl: updated to 2.5.5


Files with Mac epoch are read incorrectly
Cannot copy merged cells
Cannot access ws.active_cell

Pull Requests
Introduce read-support for images

Revision 1.9 / (download) - annotate - [select for diffs], Fri Jun 15 07:36:36 2018 UTC (5 years, 3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q2-base, pkgsrc-2018Q2
Changes since 1.8: +5 -5 lines
Diff to previous 1.8 (colored)

py-openpyxl: updated to 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

Revision 1.8 / (download) - annotate - [select for diffs], Mon Apr 23 12:01:48 2018 UTC (5 years, 5 months ago) by adam
Branch: MAIN
Changes since 1.7: +5 -5 lines
Diff to previous 1.7 (colored)

py-openpyxl: updated to 2.5.3

* Warning level too aggressive.
* Alignment and protection values not saved for named styles.
* Deleting elements from a legend doesn work.
* Index names repeated for every row in dataframe.
* Worksheet protection not being stored.
* Exception raised when reading a tooltip.

Revision 1.7 / (download) - annotate - [select for diffs], Sat Apr 7 20:13:02 2018 UTC (5 years, 5 months ago) by adam
Branch: MAIN
Changes since 1.6: +5 -5 lines
Diff to previous 1.6 (colored)

py-openpyxl: updated to 2.5.2

* 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.

Revision 1.6 / (download) - annotate - [select for diffs], Mon Mar 12 16:29:14 2018 UTC (5 years, 6 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1
Changes since 1.5: +5 -5 lines
Diff to previous 1.5 (colored)

py-openpyxl: updated to 2.5.1

Bug fixes.

Revision 1.5 / (download) - annotate - [select for diffs], Tue Feb 13 11:49:38 2018 UTC (5 years, 7 months ago) by adam
Branch: MAIN
Changes since 1.4: +5 -5 lines
Diff to previous 1.4 (colored)

py-openpyxl: updated to 2.5.0

Minor changes
Correct definition for Connection Shapes.

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.

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

Revision 1.4 / (download) - annotate - [select for diffs], Mon Oct 30 10:10:20 2017 UTC (5 years, 10 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2017Q4-base, pkgsrc-2017Q4
Changes since 1.3: +5 -5 lines
Diff to previous 1.3 (colored)

py-openpyxl: updated to 2.4.9

2.4.9 (2017-10-19)
* 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 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

Revision 1.3 / (download) - annotate - [select for diffs], Thu Jun 1 16:58:27 2017 UTC (6 years, 3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2
Changes since 1.2: +5 -5 lines
Diff to previous 1.2 (colored)

2.4.8 (2017-05-30)

* 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

Revision 1.2 / (download) - annotate - [select for diffs], Wed Nov 4 02:00:04 2015 UTC (7 years, 10 months ago) by agc
Branch: MAIN
CVS Tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1, pkgsrc-2015Q4-base, pkgsrc-2015Q4
Changes since 1.1: +2 -1 lines
Diff to previous 1.1 (colored)

Add SHA512 digests for distfiles for textproc category

Problems found locating distfiles:
	Package cabocha: missing distfile cabocha-0.68.tar.bz2
	Package convertlit: missing distfile
	Package php-enchant: missing distfile php-enchant/enchant-1.1.0.tgz

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.

Revision / (download) - annotate - [select for diffs] (vendor branch), Sat Oct 25 22:19:45 2014 UTC (8 years, 11 months ago) by cheusov
Branch: TNF
CVS Tags: pkgsrc-base, pkgsrc-2015Q3-base, pkgsrc-2015Q3, pkgsrc-2015Q2-base, pkgsrc-2015Q2, pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

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

Revision 1.1 / (download) - annotate - [select for diffs], Sat Oct 25 22:19:45 2014 UTC (8 years, 11 months ago) by cheusov
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

CVSweb <>