- update to 3.2.0:
* This is the 10th anniversary release of XlsxWriter.
* Add :func:`embed_image()` worksheet method to embed images in
cells. This is equivalent to Excel's menu item to insert an
image using the option to "Place in Cell". It scales images
automatically to the dimensions of the cell.
* This has been a frequently requested feature for people
creating spreadsheets with images for product items. See also
:ref:`ex_embedded_images`.
* Fix issue where a horizontal alignment format was ignored if
indentation was also set.
OBS-URL: https://build.opensuse.org/request/show/1158525
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-XlsxWriter?expand=0&rev=17
* This is the 10th anniversary release of XlsxWriter.
* Add :func:`embed_image()` worksheet method to embed images in
cells. This is equivalent to Excel's menu item to insert an
image using the option to "Place in Cell". It scales images
automatically to the dimensions of the cell.
* This has been a frequently requested feature for people
creating spreadsheets with images for product items. See also
:ref:`ex_embedded_images`.
* Fix issue where a horizontal alignment format was ignored if
indentation was also set.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python:numeric/python-XlsxWriter?expand=0&rev=27
- update to 3.1.9:
* Add fix for errant XML tag in chart leader lines for non-Pie
charts.
* Add support for formatting the data label in chart
trendlines.
* Add the :func:`very_hidden()` method to hide a worksheet.
This is similar to the :func:`hide()` method except that the
worksheet cannot be unhidden in the the Excel user interface.
The Excel worksheet "xlSheetVeryHidden" option can only be
unset programmatically via VBA.
* Added fixes for column formulas in tables that were
overridden by table data and which also didn't take future
functions into account.
* Added support for chart leader lines for chart types other
than Pie and Doughnut.
* Added support for adding signed VBA macros to workbooks via
the via the
* Added support for enabling the Excel "Show #N/A as an empty
cell" chart option via the :func:`show_na_as_empty_cell` method.
* Added support for custom total formulas to worksheet tables.
* Added worksheet page break preview mode via
:func:`set_pagebreak_view()`.
* Add support for new Excel dynamic functions added in 2023.
* Added support for adding a color to the `invert_if_negative`
chart option.
* Minor fix for cell color issue.
OBS-URL: https://build.opensuse.org/request/show/1132846
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-XlsxWriter?expand=0&rev=16
* Add fix for errant XML tag in chart leader lines for non-Pie
charts.
* Add support for formatting the data label in chart
trendlines.
* Add the :func:`very_hidden()` method to hide a worksheet.
This is similar to the :func:`hide()` method except that the
worksheet cannot be unhidden in the the Excel user interface.
The Excel worksheet "xlSheetVeryHidden" option can only be
unset programmatically via VBA.
* Added fixes for column formulas in tables that were
overridden by table data and which also didn't take future
functions into account.
* Added support for chart leader lines for chart types other
than Pie and Doughnut.
* Added support for adding signed VBA macros to workbooks via
the via the
* Added support for enabling the Excel "Show #N/A as an empty
cell" chart option via the :func:`show_na_as_empty_cell` method.
* Added support for custom total formulas to worksheet tables.
* Added worksheet page break preview mode via
:func:`set_pagebreak_view()`.
* Add support for new Excel dynamic functions added in 2023.
* Added support for adding a color to the `invert_if_negative`
chart option.
* Minor fix for cell color issue.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python:numeric/python-XlsxWriter?expand=0&rev=25
- Update to 1.3.7
* Added support for chart custom data labels
* Added Border, Fill, Pattern and Gradient formatting to chart data labels and
chart custom data labels.
* Replaced internal MD5 digest used to check for duplicate images with a SHA256
digest to avoid issues on operating systems such as Red Hat in FIPS mode
which don't support MD5 for security reasons.
* Added check, and warning, for worksheet tables with no data row.
Either with or without a header row.
* Added text alignment for textboxes. The existing options allowed the text
area to be aligned but didn't offer control over the text within that area.
OBS-URL: https://build.opensuse.org/request/show/847453
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python:numeric/python-XlsxWriter?expand=0&rev=17
- Update to version 1.2.7
* Fix for duplicate images being copied to an XlsxWriter file. Excel uses an
optimization where it only stores one copy of a repeated/duplicate image in
a workbook. XlsxWriter didn't do this which meant that the file size would
increase when then was a large number of repeated images. This release fixes
that issue and replicates Excel's behavior.
* Added documentation on :ref:`num_format_categories` and
:ref:`num_format_locale`.
* Added note to :func:`protect()` about how it is possible to encrypt an
XlsxWriter file using a third party, cross platform, open source tool called
`msoffice-crypt <https://github.com/herumi/msoffice>`_.
- Update to version 1.2.6
* Added option to remove style from worksheet tables.
- Update to version 1.2.5
* Added option to add hyperlinks to textboxes. See :ref:`textbox_hyperlink`.
- Update to version 1.2.4
* Added option to link textbox text from a cell. See :ref:`textbox_textlink`.
* Added option to rotate text in a textbox. See
:ref:`textbox_formatting_rotation`.
- Update to version 1.2.3
* Increased allowable worksheet url length from 255 to 2079 characters, as
supported in more recent versions of Excel. A lower or user defined limit
can be set via the ``max_url_length`` property in the :func:`Workbook`
constructor.
* Fixed several issues with hyperlinks in worksheet images.
- Update to version 1.2.2
* Fixed Python 3.8.0 warnings.
- Update to version 1.2.1
* Added the :func:`add_write_handler` method to allow user defined types to be
handled by the :func:`write` method. See :ref:`writing_user_types` for more
information.
* Add support for East Asian vertical fonts in charts.
- Update to version 1.2.0
* Refactored exception handling around the workbook file :func:`close()`
method to allow exceptions to be caught and handled. See
:ref:`ex_check_close`. Also refactored the code to clean up temp files in
the event of an exception.
* Added the option to allow chart fonts to be rotated to 270 degrees
to give a stacked orientation. See :ref:`chart_fonts`.
- Update to version 1.1.9
* Another fix for issues where zipfile.py raises "ZIP does not support
timestamps before 1980" exception.
OBS-URL: https://build.opensuse.org/request/show/768819
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python:numeric/python-XlsxWriter?expand=0&rev=13
- Update to Release 1.1.8
* Added ability to combine Doughnut and Pie charts.
* Added gauge chart example which is a combination of a Doughnut and a Pie
chart.
- Update to Release 1.1.7
* Added docs on object_position.
* Added fix for sizing of cell comment boxes when they cross columns/rows that
have size changes that occur after the comment is written.
* Added fix for the sizing of worksheet objects (images, charts, textboxes)
when the underlying cell sizes have changed and the "object_position"
parameter has been set to 1 "Move and size with cells". An additional mode 4
has been added to simulate inserting the object in hidden rows.
* Added object positioning for charts and textboxes, it was already supported
for images. Note, the parameter is now called ``object_position``. The
previous parameter name ``positioning`` is deprecated but still supported
for images.
- Update to Release 1.1.6
* Fixed issue where images that started in hidden rows/columns weren't placed
correctly in the worksheet.
* Fixed the mime-type reported by system ``file(1)``. The mime-type reported
by "file --mime-type"/magic was incorrect for XlsxWriter files since it
expected the ``[Content_types]`` to be the first file in the zip container.
OBS-URL: https://build.opensuse.org/request/show/717650
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python:numeric/python-XlsxWriter?expand=0&rev=9
anag_factory
dirkmueller
mimi_vx
RBrownFactory
dimstar_suse
mcalabkova
mcepl
Todd R
Tomáš Chvátal
Stephan Kulow
maxlin_factory