v1.6

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 #982
• [WIP] add MIP support. closes #979 by @JanMarvin in #983
• update wb_dims error by @olivroy in #984
• Avoid partial matching by @olivroy in #986
• [write] do not try to apply a cell style to data frames with zero rows. fixes #985 by @JanMarvin in #987
• [dims] add check for valid cols argument. fixes #987 by @JanMarvin in #989
• fix corner cases of wb_dims + standardize error messages by @olivroy in #990
• Partial match by @olivroy in #992
• [gha] add recheck.yml by @JanMarvin in #994
• [pt] provide downfill option. This fill labels vertically by @JanMarvin in #996
• Rm start first by @olivroy in #997
• use Rf_isBlankString() by @JanMarvin in #999
• [WIP] More flexible dims by @JanMarvin in #993
• [xlsb] update defines to revision 17.0 by @JanMarvin in #1004
• Be strict about cols, widths, hidden lengths. by @olivroy in #991
• Release 1.6 by @JanMarvin in #1008

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