Rustpy-xlsxwriter

Added

- Added support for setting the default worksheet row height and also hiding all
unused rows.

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

See [`Worksheet::set_default_row_height()`] and [`Worksheet::hide_unused_rows()`].

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

Added

- Added support for cell Notes (previously called Comments). See the
documentation for [`Note`].

A Note is a post-it style message that is revealed when the user mouses over
a worksheet cell. The presence of a Note is indicated by a small red
triangle in the upper right-hand corner of the cell.

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

In versions of Excel prior to Office 365 Notes were referred to as
"Comments". The name Comment is now used for a newer style threaded comment
and Note is used for the older non threaded version.

[`Note`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.Note.html

Added

- Added support for adding VBA Macros to `rust_xlsxwriter` using files
extracted from Excel files.

An Excel `xlsm` file is structurally the same as an `xlsx` file except that
it contains an additional `vbaProject.bin` binary file containing VBA
functions and/or macros.

Unlike other components of an xlsx/xlsm file this data isn't stored in an
XML format. Instead the functions and macros as stored as a pre-parsed
binary format. As such it wouldn't be feasible to programmatically define
macros and create a `vbaProject.bin` file from scratch (at least not in the
remaining lifespan and interest levels of the author).

Instead, as a workaround, the Rust [`vba_extract`] utility is used to
extract `vbaProject.bin` files from existing xlsm files which can then be
added to `rust_xlsxwriter` files.

See [Working with VBA Macros].

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

[`vba_extract`]: https://crates.io/crates/vba_extract
[Working with VBA Macros]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/macros/index.html

Added

- Added support for adding Excel data validations to worksheet cells.

Data validation is a feature of Excel that allows you to restrict the data
that a user enters in a cell and to display associated help and warning
messages. It also allows you to restrict input to values in a dropdown list.

See [`DataValidation`] for details.

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


[`DataValidation`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.DataValidation.html

Added

- Added support for adjusting the layout position of chart elements: plot
area, legend, title and axis labels. See [`ChartLayout`].

[`ChartLayout`]: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/chart/struct.ChartLayout.html

Fixed

- Fixed issue where a worksheet name required quoting when used with
`Worksheet::repeat_row()`. There was some checks to handle this but they
weren't comprehensive enough. [Issue 95].

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

Added

- Added support for urls in images. [Feature Request 91].

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

Changed

- Changed the method signatures of the [`Image`] helper methods from `&mut
self` to `mut self` to allow method chaining. This is an API/ABI break.