Openpyexcel

==================


Bugfixes
--------

* `949 <https://bitbucket.org/openpyxl/openpyxl/issues/949>`_ High memory use when reading text-heavy files.
* `970 <https://bitbucket.org/openpyxl/openpyxl/issues/970>`_ Copying merged cells copies references.
* `978 <https://bitbucket.org/openpyxl/openpyxl/issues/978>`_ Cannot set comment size.
* `985 <https://bitbucket.org/openpyxl/openpyxl/issues/895>`_ Exception when trying to save workbooks with no views.
* `995 <https://bitbucket.org/openpyxl/openpyxl/issues/995>`_ Cannot delete last row or column.
* `1002 <https://bitbucket.org/openpyxl/openpyxl/issues/1002>`_ Cannot read Drawings containing embedded images.


Minor changes
-------------

* Support for dataframes with multiple columns and multiple indices.

==================


Bugfixes
--------

* `934 <https://bitbucket.org/openpyxl/openpyxl/issues/934>`_ Headers and footers not included in write-only mode.
* `960 <https://bitbucket.org/openpyxl/openpyxl/issues/960>`_ Deprecation warning raised when using ad-hoc access in read-only mode.
* `964 <https://bitbucket.org/openpyxl/openpyxl/issues/964>`_ Not all cells removed when deleting multiple rows.
* `966 <https://bitbucket.org/openpyxl/openpyxl/issues/966>`_ Cannot read 3d bar chart correctly.
* `967 <https://bitbucket.org/openpyxl/openpyxl/issues/967>`_ Problems reading some charts.
* `968 <https://bitbucket.org/openpyxl/openpyxl/issues/968>`_ Worksheets with SHA protection become corrupted after saving.
* `974 <https://bitbucket.org/openpyxl/openpyxl/issues/974>`_ Problem when deleting ragged rows or columns.
* `976 <https://bitbucket.org/openpyxl/openpyxl/issues/976>`_ GroupTransforms and GroupShapeProperties have incorrect descriptors
* Make sure that headers and footers in chartsheets are included in the file

==================


Minor changes
-------------

* Correct definition for Connection Shapes. Related to 958

=====================


Bugfixes
--------

* `915 <https://bitbucket.org/openpyxl/openpyxl/issues/915>`_ TableStyleInfo has no required attributes
* `925 <https://bitbucket.org/openpyxl/openpyxl/issues/925>`_ Cannot read files with 3D drawings
* `926 <https://bitbucket.org/openpyxl/openpyxl/issues/926>`_ Incorrect version check in installer
* Cell merging uses transposed parameters
* `928 <https://bitbucket.org/openpyxl/openpyxl/issues/928>`_ ExtLst missing keyword for PivotFields
* `932 <https://bitbucket.org/openpyxl/openpyxl/issues/932>`_ Inf causes problems for Excel
* `952 <https://bitbucket.org/openpyxl/openpyxl/issues/952>`_ 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.

=====================


Bugfixes
--------
* `812 <https://bitbucket.org/openpyxl/openpyxl/issues/812>`_ Explicitly support for multiple cell ranges in conditonal formatting
* `827 <https://bitbucket.org/openpyxl/openpyxl/issues/827>`_ Non-contiguous cell ranges in validators get merged
* `837 <https://bitbucket.org/openpyxl/openpyxl/issues/837>`_ Empty data validators create invalid Excel files
* `860 <https://bitbucket.org/openpyxl/openpyxl/issues/860>`_ Large validation ranges use lots of memory
* `876 <https://bitbucket.org/openpyxl/openpyxl/issues/876>`_ Unicode in chart axes not handled correctly in Python 2
* `882 <https://bitbucket.org/openpyxl/openpyxl/issues/882>`_ ScatterCharts have defective axes
* `885 <https://bitbucket.org/openpyxl/openpyxl/issues/885>`_ Charts with empty numVal elements cannot be read
* `894 <https://bitbucket.org/openpyxl/openpyxl/issues/894>`_ Scaling options from existing files ignored
* `895 <https://bitbucket.org/openpyxl/openpyxl/issues/895>`_ Charts with PivotSource cannot be read
* `903 <https://bitbucket.org/openpyxl/openpyxl/issues/903>`_ Cannot read gradient fills
* `904 <https://bitbucket.org/openpyxl/openpyxl/issues/904>`_ Quotes in number formats could be treated as datetimes


Major Changes
-------------

`worksheet.cell()` no longer accepts a `coordinate` parameter. The syntax is now `ws.cell(row, column, value=None)`


Minor Changes
-------------

Added CellRange and MultiCellRange types (thanks to Laurent LaPorte for the
suggestion) as a utility type for things like data validations, conditional
formatting and merged cells.


Deprecations
------------

ws.merged_cell_ranges has been deprecated because MultiCellRange provides sufficient functionality

=====================


Bugfixes
--------
* `848 <https://bitbucket.org/openpyxl/openpyxl/issues/848>`_ Reading workbooks with Pie Charts raises an exception
* `857 <https://bitbucket.org/openpyxl/openpyxl/issues/857>`_ Pivot Tables without Worksheet Sources raise an exception