v0.5

Release 0.5 brings a number of changes and the usual bug fixes. In particular, we now use American English by default (aka color) from now on. However, we still support the British English colour. This change was introduced for consistency, previously we had both variants in different functions.

Among the changes, the following stand out: grouping has been improved, as well as reading escaped XML. We provide a new function wb_copy_cells() for copying (and transposing) cells, cell values or cell references in a workbook, and are now able to write both shared strings and inline strings (the previous standard). Shared strings are advantageous when you have many identical strings in a workbook. Writing data to the worksheet has been further improved and two new features have been introduced. 1) there is an experimental option openxlsx2.string_nums that changes the way strings containing numbers are written and 2) a new function has been added to the package. It is now possible to write pivot tables using wb_add_pivot_table(). These are evaluated once the workbook is opened in spreadsheet software. However, be aware that both were introduced recently and may still contain bugs and cause unexpected behavior. Be careful (make some more backups than usual) when using these functions and please give feedback if you do.

The release 0.5 is the fifth openxlsx2 release which is available under CRAN. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• update gha. closes #482 by @JanMarvin in #487
• Fix minor typo by @JanMarvin in #488
• improve row and column grouping. closes #177 by @JanMarvin in #486
• [wb_add_data] Force when writing by @JanMarvin in #492
• Fix wb_load() with multiple sheetView sections. fixes #494 by @JanMarvin in #495
• fix typo in add_border by @JanMarvin in #496
• fix reading of xml escapes by @JanMarvin in #497
• Group depending on outlinePr by @JanMarvin in #491
• fix slicer and slicerCache loading. fixes #504 by @JanMarvin in #505
• fix tab selection by @JanMarvin in #506
• tabColour accepts wb_colour() by @JanMarvin in #500
• New cf by @JanMarvin in #493
• Colour color pt1 by @JanMarvin in #501
• Colour color pt2 by @JanMarvin in #502
• [wb_group_rows] fix copy & paste error. fixes #511 by @JanMarvin in #512
• Load pivot by @JanMarvin in #513
• provide wb_copy_cells. closes #282 by @JanMarvin in #515
• [wb_add_data] string_nums option. closes #503 by @JanMarvin in #516
• correct description. closes #483 by @JanMarvin in #517
• Write sst with inline_string = FALSE by @JanMarvin in #499
• Empty relship by @JanMarvin in #519
• [new feature] Add pivot table by @JanMarvin in #520
• safe speedups for add_data by @JanMarvin in #522
• Speedup add data pt4 by @JanMarvin in #525
• move R code to Rcpp function by @JanMarvin in #526
• move this out of the loop by @JanMarvin in #527
• release 0.5 by @JanMarvin in #529

Full Changelog: v0.4.1...v0.5