Changelog for
python-openpyxl-2.4.7-25.ss1320.1.noarch.rpm :
Tue Apr 25 14:00:00 2017 toddrme2178AATTgmail.com
- Fix URL.
Tue Apr 25 14:00:00 2017 toddrme2178AATTgmail.com
- Update to version 2.4.7
* Sample files being included by mistake in sdist`
- Update to version 2.4.6
+ Bugfixes
* Cannot apply formatting to plot area`
* Exception when element attributes are Python keywords`
* Exception raised when saving files with styled columns`
* Number formats for data labels are incorrect`
* Worksheet titles not quoted in defined names`
* Font underlines not read correctly`
- Update to version 2.4.5
+ Bugfixes
* Adding images keeps file handles open
* Exception for column-only ranges
* Cannot copy worksheets with non-ascii titles on Python 2
+ Pull requests
* Support for non-standard names for Workbook part.
* Documentation correction
- Update to version 2.4.4
+ Bugfixes
* Add close method to workbooks
* openpyxl can create files with invalid style indices
* Allow images in write-only mode
* Rounded corners for charts
* Use repr when handling non-convertible objects
* Hashing function is incorrect
* Named styles share underlying array
+ Minor Changes
* Add roundtrip support for worksheet tables.
+ Pull requests
* Don\'t init mimetypes more than once.
- Update to version 2.4.2
+ Bug fixes
* DeprecationWarning is incorrect
* Exception raised if userName is missing
* Always provide a date1904 attribute
* Hashes should be stored as Base64
* Print titles broken on sheetnames with spaces
* Workbook breaks when active sheet is removed
* Incorrect descriptor for Filter values
* Potential XXE vulerability
* Cannot create files with page breaks and charts
* Problems with worksheets with commas in their titles
+ Minor Changes
* Add unicode support for sheet name incrementation.
- Update to version 2.4.1
+ Bug fixes
* Make checking for duplicate sheet titles case insensitive
* Trouble handling LibreOffice files with named styles
* Directly assigned new named styles always refer to \"Normal\"
* Cannot parse print titles with multiple sheet names
* Cannot work with macro files created by LibreOffice
* Prevent duplicate differential styles
* Allow sheet titles longer than 31 characters
* Cannot unset hyperlinks
* Exception raised when format objects use cell references
* Copy height and width when copying comments
* Incorrect content type for VBA macros
* IndexError raised in read-only mode when accessing individual cells
* Files with external links become corrupted
* Cannot read files containing macro sheets
* Details from named styles not preserved when reading files
* Remove broken Print Title and Print Area definitions
+ Minor changes
* Add support for Python 3.6
* Correct documentation for headers and footers
+ Deprecations
* Worksheet methods `get_named_range()` and `get_sqaured_range()`
+ Bug fixes
- Update to version 2.4.0
+ Bug fixes
* Exception raised when epoch is 1904
* Cannot handle unicode in headers and footers in Python 2
* Cannot handle unicode sheetnames in Python 2
* Chart styles, and axis units should not be 0
* Strings in external workbooks not unicode
+ Major changes
* Add support for builtin styles and include one for Pandas
+ Minor changes
* Add a `keep_links` option to `load_workbook`. External links contain cached
copies of the external workbooks. If these are big it can be advantageous to
be able to disable them.
* Provide an example for using cell ranges in DataValidation.
* PR 138 - add copy support to comments.
- Update to 2.4.0-b1
+ Minor changes
* Add an the alias `hide_drop_down` to DataValidation for `showDropDown` because that is how Excel works.
+ Bug fixes
* Exception raises when inspecting EmptyCells in read-only mode
* Functions for handling OOXML \"escaped\" ST_XStrings
* Row Dimensions not supported in write-only mode
* Problems when removing worksheets with charts
* Cannot use SheetProtection in write-only mode
+ Features
* Add write support for worksheet tables
- Update to 2.4.0-a1
+ Minor changes
* Remove deprecated methods from DataValidation
* Remove deprecated methods from PrintPageSetup
* Convert AutoFilter to Serialisable and extend support for filters
* Add support for SortState
* Removed `use_iterators` keyword when loading workbooks. Use `read_only` instead.
* Removed `optimized_write` keyword for new workbooks. Use `write_only` instead.
* Improve print title support
* Add print area support
* New implementation of defined names
* New implementation of page headers and footers
* Add support for Python\'s NaN
* Added iter_cols method for worksheets
* ws.rows and ws.columns now always return generators and start at the top of the worksheet
* Add a `values` property for worksheets
* Default column width changed to 8 as per the specification
+ Deprecations
* Cell anchor method
* Worksheet point_pos method
* Worksheet add_print_title method
* Worksheet HeaderFooter attribute, replaced by individual ones
* Flatten function for cells
* Workbook get_named_range, add_named_range, remove_named_range, get_sheet_names, get_sheet_by_name
* Comment text attribute
* Use of range strings deprecated for ws.iter_rows()
* Use of coordinates deprecated for ws.cell()
* Deprecate .copy() method for StyleProxy objects
+ Bug fixes
* Hyperlinks lost when reading files
* Add function for copying worksheets
* Cells with inline strings considered empty
* Add support for ranges of rows and columns
* Workbook with definedNames corrupted by openpyxl
* \"safe\" reserved ranges are not read from workbooks
* Discarding named ranges can lead to corrupt files
* Exception raised when using the class method to parse Relationships
* Crashes when reading defined names with no content
* Cannot read worksheets without coordinates
* Customised named styles not correctly preserved
- Update to version 2.3.5
+ Bug fixes
* Comments not written in write-only mode
- Update to version 2.3.4
+ Bug fixes
* Content types might be missing when keeping VBA
* Cells with only one cell look empty
* Serialise NaN as \'\'
+ Minor changes
* Preserve the order of external references because formualae use numerical indices.
* Typo corrected in cell unit tests (PR 118)
- Fix source url
- Implement single-spec version
Mon Feb 1 13:00:00 2016 toddrme2178AATTgmail.com
- update to version 2.3.3:
* Bug fixes
+ #540 Cannot read merged cells in read-only mode
+ #565 Empty styled text blocks cannot be parsed
+ #569 Issue warning rather than raise Exception raised for
unparsable definedNames
+ #575 Cannot open workbooks with embdedded OLE files
+ #584 Exception when saving borders with attribues
* Minor changes
+ PR 103 Documentation about chart scaling and axis limits
+ Raise an exception when trying to copy cells from other
workbooks.
- changes from version 2.3.2:
* Bug fixes
+ #554 Cannot add comments to a worksheet when preserving VBA
+ #561 Exception when reading phonetic text
+ #562 DARKBLUE is the same as RED
+ #563 Minimum for row and column indexes not enforced
* Minor changes
+ PR 97 One VML file per worksheet.
+ PR 96 Correct descriptor for CharacterProperties.rtl
+ #498 Metadata is not essential to use the package.
- update to version 2.3.1:
* #534 Exception when using columns property in read-only mode.
* #536 Incorrectly handle comments from Google Docs files.
* #539 Flexible value types for conditional formatting.
* #542 Missing content types for images.
* #543 Make sure images fit containers on all OSes.
* #544 Gracefully handle missing cell styles.
* #546 ExternalLink duplicated when editing a file with macros.
* #548 Exception with non-ASCII worksheet titles
* #551 Combine multiple LineCharts
* PR 88 Fix page margins in parser.
- update to version 2.3.0:
* Support the creation of chartsheets
* #532 Problems when cells have no style in read-only mode.
* PR 79 Make PlotArea editable in charts
* Use graphicalProperties as the alias for spPr
* #488 Support hashValue attribute for sheetProtection
* #493 Warn that unsupported extensions will be dropped
* #494 Cells with exponentials causes a ValueError
* #497 Scatter charts are broken
* #499 Inconsistent conversion of localised datetimes
* #500 Adding images leads to unreadable files
* #509 Improve handling of sheet names
* #515 Non-ascii titles have bad repr
* #516 Ignore unassigned worksheets
* Worksheets are now iterable by row.
* Assign individual cell styles only if they are explicitly set.
* Shift to using (row, column) indexing for cells. Cells will at some point lose coordinates.
* New implementation of conditional formatting. Databars now partially preserved.
* et_xmlfile is now a standalone library.
* Complete rewrite of chart package
* Include a tokenizer for fomulae to be able to adjust cell references in them. PR 63
* Read-only and write-only worksheets renamed.
* Write-only workbooks support charts and images.
* PR76 Prevent comment images from conflicting with VBA
* #81 Support stacked bar charts
* #88 Charts break hyperlinks
* #97 Pie and combination charts
* #99 Quote worksheet names in chart references
* #150 Support additional chart options
* #172 Support surface charts
* #381 Preserve named styles
* #470 Adding more than 10 worksheets with the same name leads to
duplicates sheet names and an invalid file
- changes from version 2.2.6
* #502 Unexpected keyword \"mergeCell\"
* #503 tostring missing in dump_worksheet
* #506 Non-ASCII formulae cannot be parsed
* #508 Cannot save files with coloured tabs
* Regex for ignoring named ranges is wrong (character class instead
of prefix)
- changes from version 2.2.5:
* #463 Unexpected keyword \"mergeCell\"
* #484 Unusual dimensions breaks read-only mode
* #485 Move return out of loop
- update to version 2.2.4:
* #464 Cannot use images when preserving macros
* #465 ws.cell() returns an empty cell on read-only workbooks
* #467 Cannot edit a file with ActiveX components
* #471 Sheet properties elements must be in order
* #475 Do not redefine class __slots__ in subclasses
* #477 Write-only support for SheetProtection
* #478 Write-only support for DataValidation
* Improved regex when checking for datetime formats
- update to version 2.2.3:
* Enable 64bit extensions for all versions of Python.
* Update docs.
* Do not preserve relation to printer part without preserving the
printer part.
* Don\'t force namespace on worksheet child as we set the default
namespace for all worksheets.
* Use print() instead of print statement
* Pass locale settings into envs (needed for somethings for tox 2 >=
2).
* Fix failing doctest.
* Correct the schema for saving strings.
* fixed typo in sample code
Fri May 8 14:00:00 2015 benoit.moninAATTgmx.fr
- update to version 2.2.2:
* #447 Uppercase datetime number formats not recognised.
* #453 Borders broken in shared_styles.
- additional changes from version 2.2.1:
* PR54 Improved precision on times near midnight.
* PR55 Preserve macro buttons
* #429 Workbook fails to load because header and footers cannot
be parsed.
* #433 File-like object with encoding=None
* #434 SyntaxError when writing page breaks.
* #436 Read-only mode duplicates empty rows.
* #437 Cell.offset raises an exception
* #438 Cells with pivotButton and quotePrefix styles cannot be
read
* #440 Error when customised versions of builtin formats
* #442 Exception raised when a fill element contains no children
* #444 Styles cannot be copied
- additional changes from version 2.2.0:
* #415 Improved exception when passing in invalid in memory files.
- additional changes from version 2.2.0-b1:
* Cell styles deprecated, use formatting objects (fonts, fills,
borders, etc.) directly instead
* Charts will no longer try and calculate axes by default
* Support for template file types - PR21
* Moved ancillary functions and classes into utils package -
single place of reference
* PR 34 Fully support page setup
* Removed SAX-based XML Generator. Special thanks to Elias Rabel
for implementing xmlfile for xml.etree
* Preserve sheet view definitions in existing files (frozen
panes, zoom, etc.)
* #103 Set the zoom of a sheet
* #199 Hide gridlines
* #215 Preserve sheet view setings
* #262 Set the zoom of a sheet
* #392 Worksheet header not read
* #387 Cannot read files without styles.xml
* #410 Exception when preserving whitespace in strings
* #417 Cannot create print titles
* #420 Rename confusing constants
* #422 Preserve color index in a workbook if it differs from the
standard
* Use a 2-way cache for column index lookups
* Clean up tests in cells
* PR 40 Support frozen panes and autofilter in write-only mode
* Use ws.calculate_dimension(force=True) in read-only mode for
unsized worksheets
- additional changes from version 2.1.5:
* #403 Cannot add comments in write-only mode
* #401 Creating cells in an empty row raises an exception
* #408 from_excel adjustment for Julian dates 1 < x < 60
* #409 refersTo is an optional attribute
* Allow cells to be appended to standard worksheets for code
compatibility with write-only mode.
- additional changes from version 2.1.4:
* #393 IterableWorksheet skips empty cells in rows
* #394 Date format is applied to all columns (while only first
column contains dates)
* #395 temporary files not cleaned properly
* #396 Cannot write “=” in Excel file
* #398 Cannot write empty rows in write-only mode with LXML
installed
* Add relation namespace to root element for compatibility with
iWork
* Serialize comments relation in LXML-backend
- additional changes from version 2.1.3:
* PR 31 Correct tutorial
* PR 32 See #380
* PR 37 Bind worksheet to ColumnDimension objects
* #379 ws.append() doesn’t set RowDimension Correctly
* #380 empty cells formatted as datetimes raise exceptions
- additional changes from version 2.1.2:
* PR 30 Fix regex for positive exponentials
* PR 28 Fix for #328
* #120, #168 defined names with formulae raise exceptions, #292
* #328 ValueError when reading cells with hyperlinks
* #369 IndexError when reading definedNames
* #372 number_format not consistently applied from styles
- additional changes from version 2.1.1:
* PR 20 Support different workbook code names
* Allow auto_axis keyword for ScatterCharts
* #332 Fills lost in ConditionalFormatting
* #360 Support value=”none” in attributes
* #363 Support undocumented value for textRotation
* #364 Preserve integers in read-only mode
* #366 Complete read support for DataValidation
* #367 Iterate over unsized worksheets
- additional changes from version 2.1.0:
* “read_only” and “write_only” new flags for workbooks
* Support for reading and writing worksheet protection
* Support for reading hidden rows
* Cells now manage their styles directly
* ColumnDimension and RowDimension object manage their styles
directly
* Use xmlfile for writing worksheets if available - around 3
times faster
* Datavalidation now part of the worksheet package
* Number formats are now just strings
* Strings can be used for RGB and aRGB colours for Fonts, Fills
and Borders
* Create all style tags in a single pass
* Performance improvement when appending rows
* Cleaner conversion of Python to Excel values
* PR6 reserve formatting for empty rows
* standard worksheets can append from ranges and generators
* #153 Cannot read visibility of sheets and rows
* #181 No content type for worksheets
* #153 Cannot read visibility of sheets and rows
* #181 No content type for worksheets
* #241 Cannot read sheets with inline strings
* #322 1-indexing for merged cells
* #339 Correctly handle removal of cell protection
* #341 Cells with formulae do not round-trip
* #347 Read DataValidations
* #353 Support Defined Named Ranges to external workbooks
- additional changes from version 2.0.5:
* #348 incorrect casting of boolean strings
* #349 roundtripping cells with formulae
- additional changes from version 2.0.4:
* Add a sample file illustrating colours
* #331 DARKYELLOW was incorrect
* Correctly handle extend attribute for fonts
- additional changes from version 2.0.3:
* Updated docs
* #319 Cannot load Workbooks with vertAlign styling for fonts
- additional changes from version 2.0.2:
* This is last release that will support Python 3.2
* Cells are referenced with 1-indexing: A1 == cell(row=1,
column=1)
* Use jdcal for more efficient and reliable conversion of
datetimes
* Significant speed up when reading files
* Merged immutable styles
* Type inference is disabled by default
* RawCell renamed ReadOnlyCell
* ReadOnlyCell.internal_value and ReadOnlyCell.value now behave
the same as Cell
* Provide no size information on unsized worksheets
* Lower memory footprint when reading files
* All tests converted to pytest
* Pyflakes used for static code analysis
* Sample code in the documentation is automatically run
* Support GradientFills
* BaseColWidth set
* #70 Add filterColumn, sortCondition support to AutoFilter
* #80 Reorder worksheets parts
* #82 Update API for conditional formatting
* #87 Add support for writing Protection styles, others
* #89 Better handling of content types when preserving macros
* #46 ColumnDimension style error
* #86 reader.worksheet.fast_parse sets booleans to integers
* #98 Auto sizing column widths does not work
* #137 Workbooks with chartsheets
* #185 Invalid PageMargins
* #230 Using v in cells creates invalid files
* #243 - IndexError when loading workbook
* #263 - Forded conversion of line breaks
* #267 - Raise exceptions when passed invalid types
* #270 - Cannot open files which use non-standard sheet names or
reference Ids
* #269 - Handling unsized worksheets in IterableWorksheet
* #270 - Handling Workbooks with non-standard references
* #275 - Handling auto filters where there are only custom filters
* #277 - Harmonise chart and cell coordinates
* #280- Explicit exception raising for invalid characters
* #286 - Optimized writer can not handle a datetime.time value
* #296 - Cell coordinates not consistent with documentation
* #300 - Missing column width causes load_workbook() exception
* #304 - Handling Workbooks with absolute paths for worksheets
(from Sharepoint)
- additional changes from version 1.8.6:
* Fixed typo for import Elementtree
* #279 Incorrect path for comments files on Windows
- additional changes from version 1.8.5:
* The ‘=’ string is no longer interpreted as a formula
* When a client writes empty xml tags for cells (e.g.
), reader will not crash
- additional changes from version 1.8.4:
* #260 better handling of undimensioned worksheets
* #268 non-ascii in formualae
* #282 correct implementation of register_namepsace for Python 2.6
- additional changes from version 1.8.3:
* Always parse using cElementTree
* Slight improvements in memory use when parsing
* #256 - error when trying to read comments with optimised reader
* #260 - unsized worksheets
* #264 - only numeric cells can be dates
- additional changes from version 1.8.2:
* #247 - iterable worksheets open too many files
* #252 - improved handling of lxml
* #253 - better handling of unique sheetnames
- additional changes from version 1.8.1:
* #246
- additional changes from version 1.8.0:
* Support for Python 2.5 dropped.
* Support conditional formatting
* Support lxml as backend
* Support reading and writing comments
* pytest as testrunner now required
* Improvements in charts: new types, more reliable
* load_workbook now accepts data_only to allow extracting values
only from formulae. Default is false.
* Images can now be anchored to cells
* Docs updated
* Provisional benchmarking
* Added convenience methods for accessing worksheets and cells by
key
- add python-jdcal as dependency
- remove python-nose and %check: tests are not provided in
the archive anymore
- rename documentation files: changed upstream
- remove CHANGES: not provided anymore
Thu Jul 17 14:00:00 2014 toddrme2178AATTgmail.com
- Add LICENSE to %doc
Thu Dec 5 13:00:00 2013 p.drouandAATTgmail.com
- Update to version 1.7.0
+ Read CHANGES file from package documentation
Thu Oct 24 14:00:00 2013 speilickeAATTsuse.com
- Require python-setuptools instead of distribute (upstreams merged)
Fri May 10 14:00:00 2013 toddrme2178AATTgmail.com
- Initial version
