Rustpy-xlsxwriter

Added

- Added support for setting a custom temp file directory when using the
`constant_memory` feature. This can be useful if the default temp directory
isn't accessible or if it is loaded in memory (which would negate the effect
of `constant_memory` mode).

See [`Workbook::set_tempfile()`].

[`Workbook::set_tempfile()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/workbook/struct.Workbook.html#method.set_tempfile

Fixed

- Fixed issue when handling Unicode escapes in strings that don't occur at
character boundaries.

[Issue 141].

[Issue 141]: https://github.com/jmcnamara/rust_xlsxwriter/issues/141

Added

- Updated `zip.rs` version to v2.5.x.

Added

- Added `serde` serialization support for enum values.

Added serialization support for unit variant enum types like `enum Direction
{Forward, Reverse, Park}` and newtype variant enum types like `enum State
{Temperature(i16), Pressure(u32)}`.

[Request 139].

[Request 139]: https://github.com/jmcnamara/rust_xlsxwriter/issues/139

Added

- Added support for merging Formats via the [`Format::merge()`] method.

This also enables the automatic handling of implicit formats at the
intersection of row and column formats, see [Row and Column Formats].

<img src="https://rustxlsxwriter.github.io/images/format_merge3.png">

- Added additional utility/helper functions:

- [`utility::quote_sheet_name()`] - Enclose a worksheet name in single quotes
as required by Excel.
- [`utility::worksheet_range()`] - Convert a worksheet name and cell reference
to an Excel "`Sheet1!A1:B1`" style range string.
- [`utility::worksheet_range_absolute()`] - Convert a worksheet name and cell
reference to an Excel "`Sheet1!$A$1:$B$1`" style absolute range string.

[`Format::merge()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.Format.html#method.merge
[Row and Column Formats]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.Format.html#row-and-column-formats
[`utility::quote_sheet_name()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.quote_sheet_name.html
[`utility::worksheet_range()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.worksheet_range.html
[`utility::worksheet_range_absolute()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/utility/fn.worksheet_range_absolute.html

Added

- Added support for worksheet outline groupings.

In Excel an outline is a group of rows or columns that can be collapsed or
expanded to simplify hierarchical data. It is often used with the
`SUBTOTAL()` function. For example:

<img src="https://rustxlsxwriter.github.io/images/worksheet_group_rows2.png">

See [Grouping and outlining data].

[Grouping and outlining data]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/index.html#grouping-and-outlining-data
<br>
<br>

- Added support for ignoring Excel worksheet cell errors.

Excel flags a number of data errors and inconsistencies with a a small
green triangle in the top left hand corner of the cell:

<img
src="https://rustxlsxwriter.github.io/images/worksheet_ignore_error1.png">

These warnings can be useful indicators that there is an issue in the
spreadsheet but sometimes it is preferable to turn them off. At the file level
these errors can be ignored by using [`Worksheet::ignore_error()`] and
[`Worksheet::ignore_error_range()`].

[`Worksheet::ignore_error()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.ignore_error
[`Worksheet::ignore_error_range()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.ignore_error_range
<br>
<br>

- Added support for worksheet background images via the [`Worksheet::insert_background_image()`] method.

<img src="https://rustxlsxwriter.github.io/images/app_background_image.png">

[`Worksheet::insert_background_image()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.insert_background_image

Added

- Added support for checkboxes via the [`Worksheet::insert_checkbox()`] method.

Checkboxes are [a new feature added to Excel] in the last year. 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.

<img src="https://rustxlsxwriter.github.io/images/checkbox.png">

[a new feature added to Excel]: https://techcommunity.microsoft.com/blog/excelblog/introducing-checkboxes-in-excel/4173561
[`Worksheet::insert_checkbox()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.insert_checkbox

- Added support for overriding the default handling of NaN and Infinity numbers.
These aren't supported by Excel so they are replaced with default or custom
string values. See:

- [`Worksheet::set_nan_value()`]
- [`Worksheet::set_infinity_value()`]
- [`Worksheet::set_neg_infinity_value()`]

[`Worksheet::set_nan_value()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_nan_value
[`Worksheet::set_infinity_value()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_infinity_value
[`Worksheet::set_neg_infinity_value()`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/worksheet/struct.Worksheet.html#method.set_neg_infinity_value


- Updated `polars` dependency to 0.46 to pick up latest Polars additions for
[`polars_excel_writer`].