v1.1
Release 1.1 is a release with many new features to try, in addition to the usual bug fixes and improvements to our existing code. Grouping columns is now a bit more user-friendly, we've updated the pugixml library, and our tests can be run in parallel again. We've added new functions for getting and setting file properties that improve and extend the existing ways to set them, a feature requested and worked on by @olivroy.
In addition, some long-requested features have been added. Reading xlsb files, cloning across workbooks, and adding slicers. Please be aware that all of these features are still somewhat experimental, have known limitations, and probably contain a few bugs. Therefore, if you try this, you should make more backups than usual and test the features more thoroughly than usual.
This release is the first to include our own xlsb file reader. With this it should be possible to load xlsb files similar to xlsx/xlsm files. Please be aware that this file parser is still limited (and probably will remain this way) and should only be considered as a sort of last resort when no other tool is available to convert the binary openxml file into a simple xlsx file. If you try this, please have a look at the NEWS file first.
Another long requested feature has been added in the form of cloning worksheets across workbooks. This extends the wb_clone_worksheet()
function with a new from
argument that allows copying worksheets across workbooks.
Last but not least, support for pivot tables has been further improved. It is now possible to sort by elements and it is possible to add a slicer to a pivot table after adding it.
A lot of time went into 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 release 1.1 is the 13th openxlsx2
release which is available under CRAN. Even though the package is now now semi-stable, it is always a good idea to make regular backups and check output files regularly. A look at the issue tracker and the NEWs is recommended in any case.
What's Changed
- Join named regions docs by @olivroy in #777
- Add more details for waiver functions + add xrefs in styledocs. by @olivroy in #778
- [wb_group_cols()] automate column creation by @JanMarvin in #781
- [wb_add_drawing] read and add "mc:alternateContent" by @JanMarvin in #783
- [WIP] initial xlsb attempts by @JanMarvin in #688
- [xlsb] more fixes for formula heavy workbooks by @JanMarvin in #787
- [xlsb] avoid hard to spot crash with unhandled array formulas by @JanMarvin in #788
- [remove_worksheet] update activeTab. closes #792 by @JanMarvin in #793
- [pivot_table] add sort_item param option by @JanMarvin in #795
- [properties] Rework setter/getter functions for workbook properties by @JanMarvin in #782
- improve assert_class(). closes #770 by @JanMarvin in #772
- [properties] get/set keywords and comments by @JanMarvin in #798
- Review workbook properties + add
company
andmanager
by @olivroy in #799 - [vignette] Provide a why openxlsx2 section. closes #800 by @JanMarvin in #801
- [update_table] check if autofilter is available. closes #802 by @JanMarvin in #804
- [workbook] move default style initialization to workbook. fixes #803 by @JanMarvin in #805
- [update_table] guard against unknown xml nodes by @JanMarvin in #806
- [pugixml] update to release 1.14 by @JanMarvin in #808
- [tests] improve testfile_path() to download files by @JanMarvin in #785
- [wb_load] minimal workbook by @JanMarvin in #810
- Tweaks to docs by @olivroy in #812
- comment unused variable by @JanMarvin in #813
- [clone_worksheet] copy worksheet across workbooks by @JanMarvin in #622
- [wbWorkbook] separate sheets in print() with comma. closes #46 by @JanMarvin in #814
- [wbWorkbook] enforce
datetime_created
. closes #685 by @JanMarvin in #815 - [tests] cleanup options by @JanMarvin in #816
- update NEWS and wb_load man page by @JanMarvin in #817
- Skip testfile_path() tests on cran. by @JanMarvin in #818
- [drawing] do not overwrite worksheet relationships by @JanMarvin in #821
- [styles] fix typo by @JanMarvin in #825
- [clone] fix cloning from a workbook with included media by @JanMarvin in #826
- [WIP] add wb_add_slicers by @JanMarvin in #822
- Release 1.1 by @JanMarvin in #823
Full Changelog: v1.0...v1.1