v1.4

Release 1.4 brings the usual bug fixes and some improvements to pivot tables and new style options.

An important change that users will notice immediately is the switch to a new Office theme and from Calibri as the default font to Aptos Narrow. The included themes have been slightly extended and we have optimized wb_set_base_font() and added wb_set_base_colors()/wb_get_base_colors(). Yes, now it is possible to change the font and colors of a worksheet theme directly from openxlsx2.

This release also brings another round of improvements for pivot tables. It is now possible to calculate formulas (a previous user request), and sorting elements should finally work as intended. In the often neglected write_xlsx() function, it is now possible to freeze columns and rows, something that did not work before and was discovered when writing tests and examining coverage reports.

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.4 is the 16th 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

• [pt] calculate pivot table field with formula by @JanMarvin in #892
• [XML] fix writing characters with xml content. closes #894 by @JanMarvin in #895
• [write] fix hyperlink issue with third party class tbl_df. closes #893 by @JanMarvin in #898
• [load] better error message for zip compressed input files. closes #896 by @JanMarvin in #897
• [styles] Update default style Office Theme and default font by @JanMarvin in #899
• [write] rbind() and reorder is quicker and cleanup unused elements by @JanMarvin in #901
• [write] cleanup by @JanMarvin in #902
• [write_xlsx] restore first_active_{col,row} and first_{col,row} by @JanMarvin in #903
• [pt] fix non distinct names in wb_data object by @JanMarvin in #911
• [pt] another attemt to fix item sorting by @JanMarvin in #912
• [pt] disable subtotals by @JanMarvin in #913
• [tests increase coverage by @JanMarvin in https://github.com//pull/916
• [pt] Create pivot table styles by @JanMarvin in #914
• [misc] cleanup and coverage by @JanMarvin in #917
• [comments] fix adding more than two background images. closes #918 by @JanMarvin in #919
• [sparklines] improve sparklines by @JanMarvin in #920
• code lints by @olivroy in #924
• Partial matching + table name error message. by @olivroy in #923
• Update tests + various lints by @olivroy in #922
• [write_xlsx] allow tab_colour by @JanMarvin in #927
• [doc] Update openxlsx2-package by @JanMarvin in #928
• [wb_data] add subset method by @JanMarvin in #906
• [misc] update NEWS, WORDLIST, _pkgdown.yml by @JanMarvin in #931
• [docs] update wb_add_data()/wb_add_data_table() by @JanMarvin in #932
• [style] fix wb$set_base_font() by @JanMarvin in #933
• [styles] improve wb_set_base_font() by @JanMarvin in #935
• Misc doc edits by @olivroy in #936
• [style] update hyperlink to use theme and base size by @JanMarvin in #937
• [styles] add wb_set_base_colors()/wb_get_base_colors() by @JanMarvin in #938
• [style] further tweaking of theme colors by @JanMarvin in #940
• Snake case conversion. by @olivroy in #943
• Improve wb_add_data() error message when no worksheet by @olivroy in #942
• [doc] minor doc cleanup by @JanMarvin in #945
• Release 1.4 by @JanMarvin in #947

Full Changelog: v1.3...v1.4