v1.7
Release 1.7 brings the usual bug fixes and internal cleanups as well as a few selected new features.
The support for MIP that was added in 1.6 has been further improved. Previously we added a check for internal folders not being handled by openxlsx2
which was triggered on the [trash]
folder, this has been reported and fixed. This folder was added by third party software, similar to a binary blob added when synchronizing files with a third party cloud software. A long time hidden bug was reported and fixed, when columns with special formats surrounded columns in a different format, the styling was applied to those columns as well. Previously, if there were two date columns to the left and right of another column, the column in the middle was also formatted as a date.
There has been support for slicers for some time. This has been extended and now we can create timelines for pivot tables. Our wb_add_timeline()
was created to work similarly to wb_add_slicer()
on pivot tables created with wb_add_pivot_table()
. It is possible to select a specific period, obviously the dim placement and different styles.
We have started to extend our work on the undo changes function. Now we provide wb_remove_conditional_formatting()
, wb_remove_slicer()
and wb_remove_timeline()
. This work has not yet been completed.
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.7 release is the 19th 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
wb_remove_conditional_formatting()
. part of #1010 by @JanMarvin in #1011 - [load] silence warning on "[trash]" folder. closes #1012 by @JanMarvin in #1013
- [dims] previously non-consecutive dims could get lost by @JanMarvin in #1015
- [pt] initial support for timelines by @JanMarvin in #1016
- [pt] add
wb_add_timeline()
by @JanMarvin in #1017 - add
remove_slicer()
. part of #1010 by @JanMarvin in #1020 - add
remove_timeline()
. part of #1010 by @JanMarvin in #1021 - [dims] fix overlapping column types. fixes #1023 by @JanMarvin in #1026
- Clearer message for bad select in wb_dims() by @olivroy in #1022
- [xlsb] fix max ccolspan by @JanMarvin in #1030
- [mips] handle docMetadata folder with "LabelInfo.xml" file. closes #1027 by @JanMarvin in #1028
- [vignette] begin redesign of basic manual by @JanMarvin in #1018
- fix warnings from implicit conversions by @JanMarvin in #1035
- [load] remove binary blob. fixes #1032 by @JanMarvin in #1034
- Release 1.7 by @JanMarvin in #1036
Full Changelog: v1.6...v1.7