v1.12

Release 1.12 is a feature-packed release with many improvements, bug fixes and code cleanups.

Over the past two releases, there have been many cleanups to the Rcpp code. For the user this results in some parts of the code running a bit faster, like wb_load() and wb_to_df(). On the developer side, we can now silently build the package with -Wconversion -Wno-sign-conversion, but we went even further and it is now possible to create a build with -Wall -Wpedantic -Wshadow -Wunused -Wconversion -Wsign-compare. Needed? No. Lots of static_cast<>()s? Yes.

A feature requested and provided by @trekonom is the new direction argument which allows grouping of sparklines. It's now also possible to use the current_sheet() waiver with sparkline(). We now load (and save) a few more files without hickups. And it is possible to build the package again with R 3.6 (on Windows just make sure the compiler uses C++11).

There are still bugs/issues/things that have avoided detection for a long time. One of them, discovered by @elipousson, was that the sep argument for combining list columns wasn't implemented at all. Support for partial labels didn't work as intended, and reading non-consecutive dims didn't work as expected. All these issues are now fixed.

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.12 release is the 24th 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

• Add modify date, don't auto-change create date by @mlell in #1176
• [wb_to_df] make equal sized non consecutive dims behave similar to unequal sized non concsecutive dims. by @JanMarvin in #1183
• [Rcpp] avoid copying objects by @JanMarvin in #1184
• [load] attempt to improve the amp_split() function. fixes #1185 by @JanMarvin in #1186
• [misc] cleanup of imported stringi functions by @JanMarvin in #1187
• [write] improve support for partial labels by @JanMarvin in #1189
• [misc] extend bookview handling by @JanMarvin in #1193
• [misc] unify arguments by @JanMarvin in #1195
• [misc] C++ cleanup by @JanMarvin in #1196
• [misc] Fix -Wsign-compare by @JanMarvin in #1197
• [write] restore sep functionality. closes #1199 by @JanMarvin in #1200
• [misc] further file type and file extension checking by @JanMarvin in #1201
• [groups] allow grouping over A1 columns by @JanMarvin in #1203
• [load] handle activeX folder. fixes #1202 by @JanMarvin in #1204
• [misc] enable use of sheet waivers in create functions. fixes #1206 by @JanMarvin in #1207
• [load] read file with d3p1 namespace by @JanMarvin in #1194
• Add functionality to add multiple sparklines as a group. by @trekonom in #1205
• [merge_cells] allow splitting into dimensions by @JanMarvin in #1212
• [load] read featurePropertyBag folder by @JanMarvin in #1216
• [misc] exclude merged cells from wb_set_col_widths(width = "auto") by @JanMarvin in #1215
• [hf] allow updating skipping header / footer as documented. fixes #1209 by @JanMarvin in #1211
• [write] protect against overwriting a shared formula reference. closes #1217 by @JanMarvin in #1218
• [gha] test with the earliest supported R by @JanMarvin in #1219
• Release 1.12 by @JanMarvin in #1220

New Contributors

• @mlell made their first contribution in #1176
• @trekonom made their first contribution in #1205

Full Changelog: v1.11...v1.12