v1.3

Release 1.3 brings the usual bug fixes and some improvements to documentation.

Even though I don't like working on performance issues, this version brings long overdue improvements to wb_add_data(). In particular, writing larger matrix objects should now be much faster. In addition, wb_load() has received minor improvements and a much longer documentation text. The documentation for wb_add_pivot_table() has also been improved. Further documentation can be found in the WIP book.

In wb_to_df() an error has been fixed where the column name was omitted in combination with col_names = FALSE for logical columns. Due to issues raised by @Layalchristine24, a new function wb_set_cell_style_across() has been added. This is required in conjunction with some options in wb_protect_worksheet() such as deleteColumns/deleteRows. The currency style has also been reset to the originally intended behavior. It is now also possible to change the color of comments or add a background image for them.

A lot of time went into various bug fixes, cleanups, and minor improvements here and there. A number of the fixes and features were developed based on user requests and needs. If you find a bug, please let us know!

The release 1.3 is the 15th openxlsx2 release which is available under CRAN. Even though the package is now now semi-stable, it is always a good idea to make regular backups and check output files regularly. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• [ignore_error] Ignore error returned a worksheet by @JanMarvin in #865
• Add reference to book by @olivroy in #867
• [wb_comment] modify the background color. closes #869 by @JanMarvin in #870
• Wb add style across by @JanMarvin in #873
• [docs] updates to wb_to_df(), wb_add_pivot_table() and options() by @JanMarvin in #874
• [write] disable hyperlink check for matrix otherwise vapply runs on e… by @JanMarvin in #876
• [Styles] restore currency style. fixes #878 by @JanMarvin in #879
• [load] Minor tweak to loadvals() and update documentation by @JanMarvin in #880
• [write] skip unused fill in dims_to_dataframe(). by @JanMarvin in #882
• [wb_to_df] keep column names with col_names = FALSE for logical columns. closes #883 by @JanMarvin in #884
• [misc] stop on unzip error with explicit message and check dimension limits by @JanMarvin in #887
• Release 1.3 by @JanMarvin in #890

Full Changelog: v1.2...v1.3