Xlsxwriter

-------------------------------

* Added support for checkboxes via the :func:`insert_checkbox()` method.

Checkboxes are a new feature added to `Excel in 2024`_. They are a way of
displaying a boolean value as a checkbox in a cell. The underlying value is
still an Excel ``TRUE/FALSE`` boolean value and can be used in formulas and in
references.

.. image:: _images/checkbox.png

See :ref:`ex_checkbox`.

.. _Excel in 2024: https://techcommunity.microsoft.com/blog/excelblog/introducing-checkboxes-in-excel/4173561

--------------------------------

Added improvements to ``autofit()``.

* Added the optional ``max_width`` parameter to the :func:`autofit()` method to
work around the issue where the autofit width is too big.

Excel autofits very long strings up to limit of 1790 pixels/255 characters.
This is often too wide to display on a single screen at normal zoom. As such
the ``max_width`` parameter is provided to enable a smaller upper pixel limit
for autofitting long strings. See :func:`autofit()`.

:feature:`1106`.

* Added the :func:`cell_autofit_width` utility function to allow users to
calculate the auto-fit width for a cell value. This allows the user to
implement their own auto-fit logic. See :ref:`ex_autofit_manually`.

--------------------------------

This is the 10th anniversary release of XlsxWriter. Version 0.0.1 was released
on February 17 2013. Since then 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`.

.. image:: _images/embedded_images.png


* Fix issue where a horizontal alignment format was ignored if indentation was
also set.

:issue:`1041`.

-------------------------------

* Add fix for errant XML tag in chart leader lines for non-Pie charts.

:issue:`1019` and :feature:`1012`.

-------------------------------

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

:feature:`750`.

------------------------------

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

:feature:`947`.

* Added fixes for column formulas in tables that were overridden by table data
and which also didn't take future functions into account.

:issue:`1015`.