CVS log for pkgsrc/textproc/py-xlsxwriter/Makefile

Up to [cvs.NetBSD.org] / pkgsrc / textproc / py-xlsxwriter

Request diff between arbitrary revisions

Keyword substitution: kv
Default branch: MAIN

py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays

py-xlsxwriter: updated to 3.2.0

Release 3.2.0 - February 17 2024
--------------------------------

This is the 10th anniversary release of XlsxWriter. Version 0.0.1 was released
on February 17 2013. Since they there have been 167 releases, 25,000 lines of
code, 1600 test cases, 700 pages of documentation, 71,000 users on GitHub, 50
contributors, 1000 closed issues and 150 million yearly downloads. Thanks to
everyone who has contributed code, given feedback or just used the library.

* 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.

py-xlsxwriter: updated to 3.1.9

Release 3.1.9 - October 19 2023
* Add fix for errant XML tag in chart leader lines for non-Pie charts.

py-xlsxwriter: updated to 3.1.8

Release 3.1.8 - October 15 2023
-------------------------------

* Add support for formatting the data label in chart trendlines.

py-xlsxwriter: updated to 3.1.7

Release 3.1.7 - October 9 2023
------------------------------

* 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.

py-xlsxwriter: updated to 3.1.6

Release 3.1.6 - October 1 2023
* Added support for chart leader lines for chart types other than Pie and Doughnut.

py-xlsxwriter: updated to 3.1.5

Release 3.1.5 - September 24 2023
---------------------------------
* Added support for adding signed VBA macros to workbooks via the via the
  :func:`add_signed_vba_project` method. See `Working with VBA Macros`_.


Release 3.1.4 - September 18 2023
---------------------------------
* Added support for enabling the Excel "Show #N/A as an empty cell" chart option
  via the :func:`show_na_as_empty_cell` method.

py-xlsxwriter: updated to 3.1.3

Release 3.1.3 - September 8 2023
--------------------------------
* Added support for custom total formulas to worksheet tables.

py-xlsxwriter: updated to 3.1.2

Release 3.1.2
* Added worksheet page break preview mode via ``worksheet.set_pagebreak_view()``.

py-xlsxwriter: updated to 3.1.1

Release 3.1.1
* Add support for new Excel dynamic functions added in 2023.
* Added support for adding a color to the `invert_if_negative` chart option.

py-xlsxwriter: updated to 3.1.0

Release 3.1.0 - April 13 2023
-----------------------------
* Minor fix for cell color issue.

py-xlsxwriter: updated to 3.0.9

Release 3.0.9 - March 10 2023
-----------------------------

* Add documentation and examples on :ref:`ewx_polars` to demonstrate new `Polars
  <https://www.pola.rs>`_ integration of XlsxWriter in `write_excel()`_.

* Add fix for rare issue with duplicate number formats.

py-xlsxwriter: updated to 3.0.8

Release 3.0.8
* Fix for ``autofit()`` exception when user defined column width was ``None``.

py-xlsxwriter: updated to 3.0.7

Release 3.0.7 - January 14 2023
-------------------------------

* Improved :func:`autofit` algorithm to account for the additional width of
  autofilter and table dropdowns.

* Improved :func:`autofit` take user defined column widths into account.

  Autofit will now only update the width for an existing column if it is greater
  than the user defined value. This allows the user to pre-load a minimum column
  width.

py-xlsxwriter: updated to 3.0.6

Release 3.0.6 - January 5 2023
------------------------------
* Added simulated worksheet :func:`autofit` method.

py-xlsxwriter: updated to 3.0.5

Release 3.0.5 - January 1 2023
------------------------------
* Added `OverlappingRange` exception which is raised during Worksheet
  :func:`add_table()` or :func:`merge_range()` if the range overlaps an existing
  worksheet table or merge range. This is a file corruption error in Excel. See
  :ref:`exceptions`.

py-xlsxwriter: updated to 3.0.4

Release 3.0.4 - December 28 2022
--------------------------------
* Roll up release of several minor fixes.
* Drop support for EOL Python 3.4 and 3.5.

py-xlsxwriter: updated to 3.0.3

Release 3.0.3 - March 27 2021
-----------------------------

* Added :func:`print_black_and_white` worksheet method to set "Black and
  White" print options.


Release 3.0.2 - October 31 2021
-------------------------------

* Added :func:`set_top_left_cell` worksheet method to position the first
  visible cell in a worksheet.


Release 3.0.1 - August 10 2021
------------------------------

* Add python_requires version to setup.py to help pip find the correct
  matching version for Python 2 and 3.


Release 3.0.0 - August 10 2021
------------------------------

* This is the first Python 3 only version of XlsxWriter. It is approximately
  10-15% faster than the Python2/3 version.

  Python 2 users should use XlsxWriter version 2.0.0, see below.

Release 2.0.0 - August 9 2021
-----------------------------

* This is the last XlsxWriter release to support Python 2. From now bug fixes
  and new features will only be available for Python 3. The deprecation notice
  for Python 2 support in XlsxWriter has been in place since May 2020 and the
  Python community support for Python 2 ended in January 2020. Downloads of
  XlsxWriter for Python 2 is currently less than 6% of all downloads of the
  library, and decreasing month by month.

  Python 2 users should still be able to install versions of XlsxWriter up to
  this release but not any releases afterwards.

*: bump PKGREVISION for egg.mk users

They now have a tool dependency on py-setuptools instead of a DEPENDS

py-xlsxwriter: updated to 1.4.5

Release 1.4.5
* Added Description/Alt Text and Decorative accessibility options for charts,
  textboxes and buttons. These options were already available for images.

py-xlsxwriter: updated to 1.4.4

Release 1.4.4
* Added some performance improvements. Performance for larger files should be
  5-10% better.

py-xlsxwriter: updated to 1.4.3

Release 1.4.3 - May 12 2021
---------------------------

* Added support for background images in worksheets. See
  :func:`set_background` and :ref:`ex_background`.

py-xlsxwriter: updated to 1.4.2

Release 1.4.2 - May 7 2021
--------------------------

* Added support for GIF image files (and in Excel 365, animated GIF files).


Release 1.4.1 - May 6 2021
--------------------------

* Added support for dynamic arrays and new Excel 365 functions like UNIQUE and
  FILTER. See :func:`write_dynamic_array_formula`,
  :ref:`formula_dynamic_arrays` and :ref:`ex_dynamic_arrays`.

* Added constructor option "use_future_functions" to enable newer Excel
  "future" functions in Formulas. See :ref:`formula_future`, and the
  :func:`Workbook` constructor.

py-xlsxwriter: updated to 1.4.0

Release 1.4.0 - April 23 2021
-----------------------------
* Add fix for issue for where a y_axis font rotation of 0 was ignored.

py-xlsxwriter: updated to 1.3.9

Release 1.3.9
* Added option to set row heights and column widths in pixels via the
  :func:`set_row_pixels` and :func:`set_column_pixels` methods.

py-xlsxwriter: updated to 1.3.8

Release 1.3.8 - March 29 2021
-----------------------------

* Added accessibility options "description" and "decorative" to
  :func:`insert_image`.

* Added fix for datetime.timedelta values that exceed the Excel 1900 leap day
  (timedeltas greater than 59 days, in hours). This is a backward incompatible
  change.

* Added the worksheet :func:`read_only_recommended` method to set the Excel
  "Read-only Recommended" option that is available when saving a file.

* Fixed issue where temp files used in `constant_memory` mode weren't
  closed/deleted if the workbook object was garbage collected.

* Fixed issue where pattern formats without colors where given a default black
  fill color.

* Added option to set a chart crossing to 'min' as well as the existing 'max'
  option. The 'min' option isn't available in the Excel interface but can be
  enabled via VBA.

py-xlsxwriter: updated to 1.3.7

Release 1.3.7

* Fixed issue where custom chart data labels didn't inherit the position of
  the data labels in the series.

* 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.

* Added Python 3.9 to the test matrix.

py-xlsxwriter: updated to 1.3.6

Release 1.3.6:
* Added the worksheet :func:`unprotect_range()` method to allow ranges within
  a protected worksheet to be unprotected.
* There are now over 1500 test cases in the test suite, including 900 tests
  that compare the output from XlsxWriter, byte for byte, against test files
  created in Excel. This is to ensure the maximum possible compatibility with
  Excel.

Release 1.3.5:
* Fixed issue where relative url links in images didn't work.
* Added ``use_zip64`` as a constructor option.
* Added check, and warning, for worksheet tables with no data row.
  Either with or without a header row.
* Add a warning when the string length in :func:`write_rich_string()` exceeds
  Excel's limit.

Release 1.3.4:
* 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.

py-xlsxwriter: updated to 1.3.3

Release 1.3.3

* Added :func:`ignore_errors()` worksheet method to to allow Excel worksheet
  errors/warnings to be ignored in user defined ranges. See also
  :ref:`ex_ignore_errors`.

* Added warning when closing a file more than once via :func:`close()` to help
  avoid errors where a file is closed within a loop or at the wrong scope
  level.

py-xlsxwriter: updated to 1.3.2

Release 1.3.2
* Added Border, Fill, Pattern and Gradient formatting to chart data labels and
  chart custom data labels. See :ref:`chart_series_option_data_labels` and
  :ref:`chart_series_option_custom_data_labels`.

py-xlsxwriter: updated to 1.3.1

Release 1.3.1
* Fix for issue where array formulas weren't included in the output file for
  certain ranges/conditions.

py-xlsxwriter: updated to 1.3.0

Release 1.3.0:
* Added support for custom chart :ref:`custom data labels
  <chart_series_option_custom_data_labels>`.

py-xlsxwriter: updated to 1.2.9

1.2.9:
* Added support for ``stacked`` and ``percent_stacked`` Line charts.

py-xlsxwriter: updated to 1.2.8

Release 1.2.8:

* Fix for issue where duplicate images with hyperlinks weren't handled
  correctly.

* Removed ``ReservedWorksheetName`` exception which was used with the reserved
  worksheet name "History" since this name is allowed in some Excel variants.

* Fix for worksheet objects (charts, images and textboxes) that are inserted
  with an offset that starts in a hidden cell.

* Fix to allow handling of NoneType in :func:`add_write_handler`.

py-xlsxwriter: updated to 1.2.7

Release 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>`_.

py-xlsxwriter: updated to 1.2.6

Release 1.2.6:
* Added option to remove style from worksheet tables.

py-xlsxwriter: updated to 1.2.5

Release 1.2.5:
* Added option to add hyperlinks to textboxes.

Release 1.2.4:
* Added option to link textbox text from a cell.
* Added option to rotate text in a textbox.

py-xlsxwriter: updated to 1.2.3

Release 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.

py-xlsxwriter: updated to 1.2.2

Release 1.2.2:
* Fixed Python 3.8.0 warnings.

py-xlsxwriter: updated to 1.2.1

Release 1.2.1:
Added the add_write_handler() method to allow user defined types to be handled by the write() method. See Writing user defined types for more information.
Add support for East Asian vertical fonts in charts.

py-xlsxwriter: updated to 1.2.0

Release 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.

py-xlsxwriter: updated to 1.1.9

Release 1.1.9:
* Another fix for issues where zipfile.py raises "ZIP does not support
  timestamps before 1980" exception.

py-xlsxwriter: updated to 1.1.8

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.

py-xlsxwriter: updated to 1.1.7

Release 1.1.7:

* Added docs on :ref: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.

py-xlsxwriter: updated to 1.1.6

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.

py-xlsxwriter: updated to 1.1.5

Release 1.1.5:
* This version removes support for end of life Pythons 2.5, 2.6, 3.1, 3.2 and
  3.3. For older, unsupported versions of Python use version 1.1.4 of
  XlsxWriter.

py-xlsxwriter: updated to 1.1.4

Release 1.1.4:
* Fix for issues where zipfile.py raises "ZIP does not support timestamps
  before 1980" exception.

Release 1.1.3:
* Fix handling of 'num_format': '0' in duplicate formats.

py-xlsxwriter: updated to 1.1.2

1.1.2:
* Fix for issue where in_memory files weren't compressed.
* Fix write() so that it handles array formulas as documented.
* Fix for issue with special characters in worksheet table functions.
* Added warnings for input issues in :func:write_rich_string() such as blank
  strings, double formats or insufficient parameters.

py-xlsxwriter: updated to 1.1.1

Release 1.1.1:
* Added comment font name and size options.
* Fix for issue when using text boxes in the same workbook as a chartsheet.

py-xlsxwriter: updated to 1.1.0

Release 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.
* Added the :func:set_tab_ratio() method to set the ratio between the
  worksheet tabs and the horizontal slider.
* Fixed issue with icon conditional formats when the values were zero.

py-xlsxwriter: updated to 1.0.9

Release 1.0.9:
Fix for issue with formulas quoted as strings in conditional formats, introduced in version 1.0.7.

py-xlsxwriter: updated to 1.0.8

Release 1.0.8:
Added named exceptions to XlsxWriter. See The Exceptions Class.
Removed the implicit 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 close().
Added border, fill, pattern and gradient formatting options to set_legend().
Added top_right position to set_legend().

py-xlsxwriter: updated to 1.0.7

Release 1.0.7:
Fix for unicode type error in Python 3.

Release 1.0.6:
Added some performance improvements.

textproc/py-xlsxwriter: Update to 1.0.5.

- Added example of how to subclass the Workbook and Worksheet objects.
- Added support for WMF and EMF image formats to the Worksheet
  :func:`add_image` method.

textproc/py-xlsxwriter: Update to 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.
- Fix for jpeg images that reported unknown height/width due to
  unusual SOF markers.
- Added support for blanks in list autofilter.

textproc/py-xlsxwriter: Update to 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
  :ref:`ex_cond_format`.
- Fixed :func:`set_column` parameter names to match docs and other methods.
  Note, this is a backward incompatible change.
- Fixed missing plotarea formatting in pie/doughnut charts.

py-xlsxwriter: update to 1.0.2

Release 1.0.2:
* Fix for cases where the hyperlink style added in the previous release didn't
  work.

py-xlsxwriter: update to 1.0.0

Release 1.0.0:
* Added icon sets to conditional formatting.

Release 0.9.9:
* Added ``stop_if_true`` parameter to conditional formatting.

Use correct CATEGORIES

Switch github HOMEPAGEs to https.

Update textproc/py-xlsxwriter to 0.9.8.

Release 0.9.8 - July 1 2017
- Fixed issue where spurious deprecation warning was raised in ``-Werror`` mode.

Release 0.9.7 - June 25 2017
- Minor bug and doc fixes.

Update textproc/py-xlsxwriter to 0.9.6.

Release 0.9.6 - Dec 26 2016
---------------------------

* Fix for table with data but without a header.

* Add a warning when the number of series in a chart exceeds Excel's limit
  of 255.


Release 0.9.5 - Dec 24 2016
---------------------------

* Fix for missing `remove_timezone` option in Chart class.


Release 0.9.4 - Dec 2 2016
--------------------------

* Added user definable removal of timezones in datetimes. See the
  :func:`Workbook` constructor option ``remove_timezone`` and :ref:`Timezone
  Handling in XlsxWriter <timezone_handling>`.

* Fix duplicate header warning in :func:`add_table` when there is only one
  user defined header.

* Fix for `center_across` property in :func:`add_format`.

Update textproc/py-xlsxwriter to 0.9.3.

- Added check to :func:`add_table` to prevent duplicate header names
  which leads to a corrupt Excel file.

Update textproc/py-xlsxwriter to 0.9.2.

Release 0.9.2 - June 13 2016
---------------------------

* Added workbook :func:`set_size` method to set the workbook
  window size.


Release 0.9.1 - June 8 2016
---------------------------

* Added font support to chart :func:`set_table`.

* Documented used of font rotation in chart :ref:`data labels
  <chart_series_option_data_labels>`.


Release 0.9.0 - June 7 2016
---------------------------

* Added :ref:`trendline properties
  <chart_series_option_trendline>`:
  ``intercept``, ``display_equation`` and ``display_r_squared``.


Release 0.8.9 - June 1 2016
---------------------------

* Fix for :func:`insert_image` issue when handling images with
  zero dpi.


Release 0.8.8 - May 31 2016
---------------------------

* Added workbook :func:`set_custom_property` method to set custom
  document properties.

Update textproc/py-xlsxwriter to 0.8.7.

* Fix for issue when inserting read-only images on Windows.

* 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.

Update textproc/py-xlsxwriter to 0.8.6.

* Fix for ``external:`` urls where the target/anchor contains
  spaces.

Update textproc/py-xlsxwriter to 0.8.5.

* Added additional documentation on :ref:`ewx_pandas` and
  :ref:`pandas_examples`.
* Added fix for :func:`set_center_across` format method.

Update textproc/py-xlsxwriter to 0.8.4.

Release 0.8.4 - January 16 2016
-------------------------------

* 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.
  Issue `#330 <https://github.com/jmcnamara/XlsxWriter/issues/330>`_.


Release 0.8.3 - January 14 2016
-------------------------------

* Added options to configure chart axis tick placement. See :func:`set_x_axis()`.


Release 0.8.2 - January 13 2016
-------------------------------

* Added transparency option to solid fill colors in chart areas
  (:ref:`chart_formatting_fill`).
  Feature request `#298 <https://github.com/jmcnamara/XlsxWriter/issues/298>`_.


Release 0.8.1 - January 12 2016
-------------------------------

* Added option to set chart tick interval.
  Feature request `#251 <https://github.com/jmcnamara/XlsxWriter/issues/251>`_.


Release 0.8.0 - January 10 2016
-------------------------------

* Added additional documentation on :ref:`working_with_formulas`.


Release 0.7.9 - January 9 2016
------------------------------

* Added chart pattern fills, see :ref:`chart_formatting_pattern` and
  :ref:`ex_chart_pattern`.
  Feature request `#268 <https://github.com/jmcnamara/XlsxWriter/issues/268>`_.

Update textproc/py-xlsxwriter to 0.7.8.

* Add checks for valid and non-duplicate worksheet table names.

Import XlsxWriter as textproc/py-xlsxwriter.

XlsxWriter is a Python module for writing files in the Excel
2007+ XLSX file format.