Package Release Info


Update Info: Base Release
Available in Package Hub : 15 SP3





Change Logs

Version: 0.9.6-bp150.2.4
* Thu Mar 02 2017
- Update to version 0.9.6 (changes since 0.9.3):
  * Add user definable removal of timezones in datetimes
  * Fix a duplicate header warning in add_table when there is only
    one user defined header (gh#jmcnamara/XlsxWriter#380).
  * A fix for the center_across property in add_format
  * A fix for a missing remove_timezone option in the Chart class
  * A fix for a table with data but without a header
  * Add a warning when the number of series in a chart exceeds
    Excel's limit of 255 (gh#jmcnamara/XlsxWriter#399).
- Update for the multipython build.
* Mon Aug 15 2016
- Fix update-alternatives implementation.
* Fri Jul 22 2016
- Update to version 0.9.3 (changes since 0.8.7):
  * Add workbook :func:`set_custom_property` method to set custom
    document properties.
  * Fix for :func:`insert_image` issue when handling images with
    zero dpi.
  * Add :ref:`trendline properties <chart_series_option_trendline>`:
  ``intercept``, ``display_equation`` and ``display_r_squared``.
  * Documented used of font rotation in chart :ref:`data labels
  * Add workbook :func:`set_size` method to set the workbook window
  * Add check to :func:`add_table` to prevent duplicate header
    names which leads to a corrupt Excel file.
- Fix SLE 11 build.
* Wed May 25 2016
- Update to 0.8.7
  * Fix for issue when inserting read-only images on Windows.
    Issue `#352 <>`_.
  * Added :func:`get_worksheet_by_name()` method to allow the retrieval of a
    worksheet from a workbook via its name.
  * Fixed issue where internal file creation and modification dates where in the
    local timezone instead of UTC.
- Switch to pythonhosted URL.
- Rename to python3-XlsxWriter to conform to python packaging guidelines
- Implement update-alternatives
* Thu Apr 28 2016
- Update to version 0.8.6 (changes since 0.8.4):
  * Add additional documentation on :ref:`ewx_pandas` and
  * Add fix for :func:`set_center_across` format method.
  * Fix for ``external:`` urls where the target/anchor contains
* Thu Feb 11 2016
- Update to 0.8.4 (changes since 0.7.7):
  * Add checks for valid and non-duplicate worksheet table names.
  * Add chart pattern fills, see :ref:`chart_formatting_pattern`
    and :ref:`ex_chart_pattern`.
  * Add additional documentation on :ref:`working_with_formulas`.
  * Add option to set chart tick interval.
  * Add transparency option to solid fill colours in chart areas
  * Add options to configure chart axis tick placement.
    See :func:`set_x_axis()`.
  * Fix for :func:`write_url` exception when the URL contains two
    ``#`` location/anchors. Note, URLs like this aren't strictly
    valid and cannot be entered manually in Excel.
* Mon Nov 23 2015
- Update to 0.7.7:
  * Add support for table header formatting and a fix for wrapped
    lines in the header.
* Sat Oct 10 2015
- Update to 0.7.6:
  * Add option to allow data validation input messages with the
    'any' validate parameter.
  * Fix url encoding of links to external files and directories.
  * Allow hyperlinks longer than 255 characters when the link and
    anchor are each less than or equal to 255 characters.
  * Add ``hyperlink_base`` document property.
  * Fix for images with negative offsets.
* Sat Jul 18 2015
- Initial package.
Version: 1.2.7-bp152.1.8
* Thu Jan 30 2020 Todd R <>
- 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
  * 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 <>`_.
- 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
- 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`
  * 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
  * 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 raises "ZIP does not support
    timestamps before 1980" exception.
* Sat Sep 14 2019 John Vandenberg <>
- Use %pytest, as test invokes python which does not exist
  if only python3 flavour is built.
* Mon Jul 22 2019 Todd R <>
- 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
- 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.
* Mon Feb 25 2019 John Vandenberg <>
- Update to v1.1.5
  * Break compatibility with Python 2.6
* Fri Feb 22 2019 John Vandenberg <>
- Update to v1.1.4
  * Fix for issues where raises "ZIP does not support
    timestamps before 1980" exception.
    Issue `#535 <>`_.
- from v1.1.3
  * Fix handling of ``'num_format': '0'`` in duplicate formats.
    Issue `#584 <>`_.
- Activate the test suite using the GitHub repository archive.
* Sat Dec 22 2018 Todd R <>
- Update to version 1.1.2
  * Fix for issue where ``in_memory`` files weren't compressed.
    Issue `#573 <>`_.
  * Fix ``write()`` so that it handles array formulas as documented.
    Issue `#418 <>`_.
  * Fix for issue with special characters in worksheet table functions.
    Issue `#442 <>`_.
  * Added warnings for input issues in :func:`write_rich_string()` such as blank
    strings, double formats or insufficient parameters.
    Issue `#425 <>`_.
- Update to version 1.1.1
  * Added comment font name and size options.
    Issue `#201 <>`_.
  * Fix for issue when using text boxes in the same workbook as a chartsheet.
    Issue `#420 <>`_.
- Update to version 1.1.0
  * Added functionality to align chart category axis labels. See the
    ``label_align`` property of the :func:`set_x_axis()` method.
  * Added worksheet :func:`hide_row_col_headers()` method to turn off worksheet
    row and column headings.
    Issue `#480 <>`_.
  * Added the :func:`set_tab_ratio()` method to set the ratio between the
    worksheet tabs and the horizontal slider.
    Issue `#481 <>`_.
  * Fixed issue with icon conditional formats when the values were zero.
    Issue `#565 <>`_.
- Update to version 1.0.9
  * Fix for issue with formulas quoted as strings in conditional formats,
    introduced in version 1.0.7.
    Issue `#564 <>`_.
- Update to version 1.0.8
  * Added named exceptions to XlsxWriter. See :ref:`exceptions`.
  * Removed the implicit :func:`close()` in the destructor since it wasn't
    guaranteed to work correctly and raised a confusing exception when any other
    exception was triggered. **Note that this is a backward incompatible
    change.** The ``with`` context manager is a better way to close
    automatically, see :func:`close()`.
  * Added border, fill, pattern and gradient formatting options to
    Issue `#545 <>`_.
  * Added ``top_right`` position to :func:`set_legend()`.
    Issue `#537 <>`_.
- Update to version 1.0.7
  * Fix for unicode type error in Python 3.
    Issue `#554 <>`_.
- Update to version 1.0.6
  * Added some performance improvements.
    PR `#551 <>`_.
- Update to version 1.0.5
  * Added example of how to subclass the Workbook and Worksheet objects. See
    :ref:`ex_inheritance1` and :ref:`ex_inheritance2`.
  * Added support for WMF and EMF image formats to the Worksheet
    :func:`add_image` method.
- Update to version 1.0.4
  * Set the xlsx internal file member datetimes to 1980-01-01 00:00:00 like
    Excel so that apps can produce a consistent binary file once the workbook
    :func:`set_properties` ``created`` date is set.
    Pull request `#495 <>`_.
  * Fix for jpeg images that reported unknown height/width due to unusual SOF markers.
    Issue `#506 <>`_.
  * Added support for blanks in list autofilter.
    Issue `#505 <>`_.
- Update to version 1.0.3
  * Added Excel 2010 data bar features such as solid fills and control over the
    display of negative values. See :ref:`working_with_conditional_formats` and
    Feature request `#502 <>`_.
  * Fixed :func:`set_column` parameter names to match docs and other methods.
    Note, this is a backward incompatible change.
    Issue `#504 <>`_.
  * Fixed missing plotarea formatting in pie/doughnut charts.
- Update to version 1.0.2
  * Fix for cases where the hyperlink style added in the previous release didn't
    Feature request `#455 <>`_.
- Update to version 1.0.1
  * Changed default :func:`write_url` format to the Excel hyperlink style so that
    it changes when the theme is changed and also so that it indicates that the
    link has been clicked.
    Feature request `#455 <>`_.
- Update to version 1.0.0
  * Added icon sets to conditional formatting. See
    :ref:`working_with_conditional_formats` and :ref:`ex_cond_format`.
    Feature request `#387 <>`_.
- Update to version 0.9.9
  * Added ``stop_if_true`` parameter to conditional formatting.
    Feature request `#386 <>`_.
- Update to version 0.9.8
  * Fixed issue where spurious deprecation warning was raised in ``-Werror`` mode.
    ssue `#451 <>`_.
- Update to version 0.9.7
  * Minor bug and doc fixes.