Release 1.11 brings bug fixes and internal cleanups.
This release fixes a bug identified earlier this week, where adding a summary row to a data table could result in data loss. A miscalculation in table length caused the last row of the table to be overwritten instead of correctly appending the summary row below. This issue arose as part of an effort to implement a fully customizable totals row, similar to those in spreadsheet software.
Hopefully, the lack of reports suggests the feature was not widely used. However, the bug may have gone unnoticed by some users, as the table’s appearance remained otherwise normal, with only the last column missing.
Additional cleanups include improvements to the Rcpp code and enhanced documentation for number formats.
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.11 release is the 23rd 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
- [pugi] replace
child_value()
withtext().get()
by @JanMarvin in #1165 - [misc] avoid scientific notation in as.character(rows). closes #1167 by @JanMarvin in #1170
- [slicer] allow setting
hide items with no data
by @JanMarvin in #1169 - [docs] extend
wb_add_numfmt()
details with more detailed guides by @JanMarvin in #1175 - [misc] Cleanup cpp code by @JanMarvin in #1177
- [table] total row must be placed below the table. fixes #1178 by @JanMarvin in #1179
- [tables] escape specials in total row formula by @JanMarvin in #1181
- Release 1.11 by @JanMarvin in #1182
Full Changelog: v1.10...v1.11