baserev update by copy to link target

• Files Changed
• Browse Source

- update to 3.1.2:
  * #1963 Cannot read worksheets in read-only mode with locally
    scoped definitions
  * #1974 Empty custom properties cause invalid files
  * #1881 DocumentProperties times set by module import only
  * #1947 Worksheet-specific definitions are missing
  * #1156 Table filters are always overriden
  * #1360 Can't read some ScatterCharts if n
  * #1724 Problem with multilevel indices in dataframes
  * #1772 Problem with category indices in dataframes
  * #1786 NamedStyles share attributes - mutables gotcha
  * #1851 Allow print area to be set to None
  * #1852 Worksheet for print title and print areas can't be found
  * #1853 Custom document properties that are strings can be empty
  * #1858 ConditionalFormatting lost when pivot table updated
  * #1864 Better handling of defined names
  * #1904 dataframe_to_rows() misalignment on multiindex
  * #1912 Excel doesn't like xmlns:space on nodes with only
    whitespace, which it treats as empty.
  * #1942 Exception when print areas use table references.
  * Adding tables in write-only mode raises an exception.

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

update to latest version

• Files Changed
• Browse Source

update to latest version

• Files Changed
• Browse Source

- update to 3.0.7:
  * https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1588
  * Exception raised when merging cells which do not have borders all the way
    round.
  * Fix Python 2.x specific statement in documentation
  * 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
  * 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
  * 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.

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 3.0.3:
  + Bugfixes
    * Exception when handling merged cells with hyperlinks
    * Problems when both lxml and defusedxml are installed
    * CFVO with incorrect values cannot be processed
- Update to 3.0.2:
  + Bugfixes
    * 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

Update to 3.0.1

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 2.6.4:
  * Cannot save workbooks with comments more than once.
  * #1237 Fix 3D charts.
  * #1290 Minimum for holeSize in Doughnut charts too high
  * #1291 Warning for MergedCells with comments
  * #1296 Pagebreaks duplicated
  * #1309 Workbook has no default CellStyle
  * #1330 Workbooks with comments cannot be saved multiple times

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 2.6.2:
  * #1173 Workbook has no _date_formats attribute
  * #1190 Cannot create charts for worksheets with quotes in the title
  * #1228 MergedCells not removed when range is unmerged
  * #1232 Link to pivot table lost from charts
  * #1233 Chart colours change after saving
  * #1236 Cannot use ws.cell in read-only mode with Python 2.7

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 2.6.1:
  * #1174 ReadOnlyCell.is_date does not work properly
  * #1175 Cannot read Google Docs spreadsheet with a Pivot Table
  * #1180 Charts created with openpyxl cannot be styled
  * #1181 Cannot handle some numpy number types
  * #1182 Exception when reading unknowable number formats
  * #1186 Only last formatting rule for a range loaded
  * #1191 Give MergedCell a value attribute
  * #1193 Cannot process worksheets with comments
  * #1197 Cannot process worksheets with both row and page breaks
  * #1204 Cannot reset dimensions in ReadOnlyWorksheets
  * #1211 Incorrect descriptor in ParagraphProperties
  * #1213 Missing hier attribute in PageField raises an exception

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 2.6.0 (2019-02-06)
  + Bugfixes
    * #1162 Exception on tables with names containing spaces.
    * #1170 Cannot save files with existing images.
- Update to 2.6.-b1 (2019-01-08)
  + Bugfixes
    * #1141 Cannot use read-only mode with stream
    * #1143 Hyperlinks always set on A1
    * #1151 Internal row counter not initialised when reading files
    * #1152 Exception raised on out of bounds date
- Update to 2.6-a1 (2018-11-21)
  + 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
  + Deprecations
    * Type inference and coercion for cell values
- Update to 2.5.15 (unreleased)
- Update to 2.5.14 (2019-01-23)
  + Bugfixes
    * #1150 Correct typo in LineProperties
    * #1142 Exception raised for unsupported image files
    * #1159 Exception raised when cannot find source for non-local
      cache object
  + Pull Requests

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 2.5.12
  + Bugfixes
    * 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
  + Pull Requests
    * Use defusedxml if available
- Update to 2.5.11
  + Pull Requests
    * Improved handling of missing rows
    * Add support for defined names to tokeniser
- Update to 2.5.10
  + Bugfixes
    * 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.
- Update to 2.5.9
  + Bugfixes
    * 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
- Update to 2.5.8
  * Cannot control how missing values are displayed in charts.
  * Cell references can't be used for chart titles
  * Params in iter_cols and iter_rows methods are slightly wrong.
- Update to 2.5.7
  * Sheet title containing % need quoting in references
  * Cannot set quote prefix
  * Pandas timestamps raise KeyError
- Update 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
- Update to 2.5.5
  + Bugfixes
    * Files with Mac epoch are read incorrectly
    * Cannot copy merged cells
    * Cannot access ws.active_cell2.5.12

• Files Changed
• Browse Source