v1.2

Release 1.2 brings the usual bug fixes and some improvements to pivot tables and copy cells.

Since its first implementation, wb_add_pivot_table() has undergone a number of unfortunately still largely undocumented changes. It is now possible to select outline and compact to change the appearance of the pivot table and to select subsets of data to be included with choose. This also works with slicers and is a nice feature for pre-selecting pivot tables. Note, however, that this does not work with pivot tables loaded via wb_load() and that support for modifying these loaded pivot tables is not currently planned.

Another function that has been reworked a little is wb_copy_cells(). This is another of the many sparsely documented functions, but actually one that has some nice features. For example, similar to copying cells in spreadsheet programs, it is possible to copy the cell as a value or as is. It is also possible to copy cells as references and it is also possible to transpose what is being copied.

Some long overlooked escaping issue with class(df$x) <- "formula" was fixed. Which strangely didn't bother anybody for several months, but once the first report came in and was fixed, various duplicates of this issue appeared. Thanks to @olivroy options for min and max width were restored. And since this release it is also possible to use openxlsx2 with webr (see #849 for details).

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.2 is the 14th 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

• [named region] fix local_sheet counting. fixes #829 by @JanMarvin in #830
• [pivot tables] add show_data_as and compact/outline by @JanMarvin in #833
• [write_data] escape all formulas in write_data by @JanMarvin in #834
• [write_data] make formula encoding more general by @JanMarvin in #835
• [pivot tables] use standardize_case_names() and as_xml_attr() by @JanMarvin in #836
• [drawings] improve relationship id selection by @JanMarvin in #838
• [clone] column and row styles by @JanMarvin in #839
• [pt] add choose param by @JanMarvin in #840
• [pt] Improve item selection and fix slicers names with whitespace by @JanMarvin in #842
• [numfmt] fix forward slash escaping. closes #847 by @JanMarvin in #848
• [copy_cells] copy hyperlinks and fix handling of transposed cells. fixes #846 by @JanMarvin in #850
• [copy cells] fill empty cells by @JanMarvin in #851
• Document options by @olivroy in #853
• [copy_cells] pass ... to wb_add_data(). close #852 by @JanMarvin in #855
• [tests] provide testsetup function and use it. by @JanMarvin in #857
• [pt] cleanup choose by @JanMarvin in #858
• [xlsb] fix formats. closes #860 by @JanMarvin in #861
• Release 1.2 by @JanMarvin in #862

Full Changelog: v1.1...v1.2