v1.6

[JanMarvin]

Release 1.6 brings the usual bug fixes and internal cleanups as well as a few selected new features. Big thanks again to @olivroy for his ongoing help with documentation fixes and internal cleanups!

We fulfilled a user request by adding MIP support, which is a kind of confidentiality stamp added to the xlsx file. This only works in certain business environments as we couldn't test it ourselves, thanks for the request and the testing! In addition, it is now possible to add custom properties via wb_set_properties().

Initial support for richData folders has been added, so it is possible to read spreadsheets with images embedded in cells. (This has not been fully tested, please let us know if you encounter problems). After a long time, another nice addition is the added support for non-contiguous dimensions, finally something like "A1:B2,B4:C5" can be used with e.g. wb_add_fill() and it is even possible to write data into different cells!

Among the bug fixes and internal cleanups: It is now possible to write data frames with zero rows, we've fixed the remaining few cases of partial matching, and improved some error and warning messages to let our users know what exactly is going on.

A lot of time was spent on 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 1.6 release is the 18th openxlsx2 release available on CRAN. Even though the package is now semi-stable, it is always a good idea to make regular backups and check the output files. A look at the issue tracker and the NEWs is highly recommended.

What's Changed

• [load] read & write richData folder by @JanMarvin in [load] read & write richData folder #982
• [WIP] add MIP support. closes Handling of MIP Sensitivity Labels #979 by @JanMarvin in [WIP] add MIP support. closes #979 #983
• update wb_dims error by @olivroy in update wb_dims error #984
• Avoid partial matching by @olivroy in Avoid partial matching #986
• [write] do not try to apply a cell style to data frames with zero rows. fixes writing an empty data frame containing date variables results in "Error: stoi" #985 by @JanMarvin in [write] do not try to apply a cell style to data frames with zero rows. fixes #985 #987
• [dims] add check for valid cols argument. fixes [write] do not try to apply a cell style to data frames with zero rows. fixes #985 #987 by @JanMarvin in [dims] add check for valid cols argument. fixes #987 #989
• fix corner cases of wb_dims + standardize error messages by @olivroy in fix corner cases of wb_dims + standardize error messages #990
• Partial match by @olivroy in Partial match #992
• [gha] add recheck.yml by @JanMarvin in [gha] add recheck.yml #994
• [pt] provide downfill option. This fill labels vertically by @JanMarvin in [pt] provide downfill option. This fill labels vertically #996
• Rm start first by @olivroy in Rm start first #997
• use Rf_isBlankString() by @JanMarvin in use Rf_isBlankString() #999
• [WIP] More flexible dims by @JanMarvin in [WIP] More flexible dims #993
• [xlsb] update defines to revision 17.0 by @JanMarvin in [xlsb] update defines to revision 17.0 #1004
• Be strict about cols, widths, hidden lengths. by @olivroy in Be strict about cols, widths, hidden lengths. #991
• Release 1.6 by @JanMarvin in Release 1.6 #1008

Full Changelog: v1.5...v1.6

---

This discussion was created from the release v1.6.