v1.1

[JanMarvin]

will update release notes later

What's Changed

• Join named regions docs by @olivroy in Join named regions docs #777
• Add more details for waiver functions + add xrefs in styledocs. by @olivroy in Add more details for waiver functions + add xrefs in styledocs. #778
• [wb_group_cols()] automate column creation by @JanMarvin in [wb_group_cols()] automate column creation #781
• [wb_add_drawing] read and add "mc:alternateContent" by @JanMarvin in [wb_add_drawing] read and add "mc:alternateContent" #783
• [WIP] initial xlsb attempts by @JanMarvin in [WIP] initial xlsb attempts #688
• [xlsb] more fixes for formula heavy workbooks by @JanMarvin in [xlsb] more fixes for formula heavy workbooks #787
• [xlsb] avoid hard to spot crash with unhandled array formulas by @JanMarvin in [xlsb] avoid hard to spot crash with unhandled array formulas #788
• [remove_worksheet] update activeTab. closes Excel throws an error- "Removed Records: View from /xl/workbook.xml part (Workbook)" #792 by @JanMarvin in [remove_worksheet] update activeTab. closes #792 #793
• [pivot_table] add sort_item param option by @JanMarvin in [pivot_table] add sort_item param option #795
• [properties] Rework setter/getter functions for workbook properties by @JanMarvin in [properties] Rework setter/getter functions for workbook properties #782
• improve assert_class(). closes Suggestion: Better error message openxlsx2:::assert_workbook #770 by @JanMarvin in improve assert_class(). closes #770 #772
• [properties] get/set keywords and comments by @JanMarvin in [properties] get/set keywords and comments #798
• Review workbook properties + add company and manager by @olivroy in Review workbook properties + add company and manager #799
• [vignette] Provide a why openxlsx2 section. closes Vignette/documentation comparing with existing solutions? #800 by @JanMarvin in [vignette] Provide a why openxlsx2 section. closes #800 #801
• [update_table] check if autofilter is available. closes wb_update_table doesn't work with tables with no filter #802 by @JanMarvin in [update_table] check if autofilter is available. closes #802 #804
• [workbook] move default style initialization to workbook. fixes All cell styles are removed when registering new cell styles before adding the first worksheet #803 by @JanMarvin in [workbook] move default style initialization to workbook. fixes #803 #805
• [update_table] guard against unknown xml nodes by @JanMarvin in [update_table] guard against unknown xml nodes #806
• [pugixml] update to release 1.14 by @JanMarvin in [pugixml] update to release 1.14 #808
• [tests] improve testfile_path() to download files by @JanMarvin in [tests] improve testfile_path() to download files  #785
• [wb_load] minimal workbook by @JanMarvin in [wb_load] minimal workbook #810
• Tweaks to docs by @olivroy in Tweaks to docs #812
• comment unused variable by @JanMarvin in comment unused variable #813
• [clone_worksheet] copy worksheet across workbooks by @JanMarvin in [clone_worksheet] copy worksheet across workbooks #622
• [wbWorkbook] separate sheets in print() with comma. closes modernize self$print() for R6 classes #46 by @JanMarvin in [wbWorkbook] separate sheets in print() with comma. closes #46 #814
• [wbWorkbook] enforce datetime_created. closes provide a file creation date for wrapper tests #685 by @JanMarvin in [wbWorkbook] enforce datetime_created. closes #685 #815
• [tests] cleanup options by @JanMarvin in [tests] cleanup options #816
• update NEWS and wb_load man page by @JanMarvin in update NEWS and wb_load man page #817
• Skip testfile_path() tests on cran. by @JanMarvin in Skip testfile_path() tests on cran. #818
• [drawing] do not overwrite worksheet relationships by @JanMarvin in [drawing] do not overwrite worksheet relationships #821
• [styles] fix typo by @JanMarvin in [styles] fix typo #825
• [clone] fix cloning from a workbook with included media by @JanMarvin in [clone] fix cloning from a workbook with included media #826
• [WIP] add wb_add_slicers by @JanMarvin in [WIP] add wb_add_slicers #822
• Release 1.1 by @JanMarvin in Release 1.1 #823

Full Changelog: v1.0...v1.1

---

This discussion was created from the release v1.1.