v0.5

[JanMarvin]

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 Update github actions #482 by @JanMarvin in update gha. closes #482 #487
• Fix minor typo by @JanMarvin in Fix minor typo #488
• improve row and column grouping. closes Port grouping from openxlsx pr#297 #177 by @JanMarvin in improve row and column grouping. closes #177 #486
• [wb_add_data] Force when writing by @JanMarvin in [wb_add_data] Force when writing #492
• Fix wb_load() with multiple sheetView sections. fixes wb_load() throws error if worksheets have "freeze panes" activated #494 by @JanMarvin in Fix wb_load() with multiple sheetView sections. fixes #494 #495
• fix typo in add_border by @JanMarvin in fix typo in add_border #496
• fix reading of xml escapes by @JanMarvin in fix reading of xml escapes #497
• Group depending on outlinePr by @JanMarvin in Group depending on outlinePr #491
• fix slicer and slicerCache loading. fixes Loading Existing Workbook with Slicers Corrupts on Save #504 by @JanMarvin in fix slicer and slicerCache loading. fixes #504 #505
• fix tab selection by @JanMarvin in fix tab selection #506
• tabColour accepts wb_colour() by @JanMarvin in tabColour accepts wb_colour() #500
• New cf by @JanMarvin in New cf #493
• Colour color pt1 by @JanMarvin in Colour color pt1 #501
• Colour color pt2 by @JanMarvin in Colour color pt2 #502
• [wb_group_rows] fix copy & paste error. fixes group_rows collapsed is broken #511 by @JanMarvin in [wb_group_rows] fix copy & paste error. fixes #511 #512
• Load pivot by @JanMarvin in Load pivot #513
• provide wb_copy_cells. closes Various cell copy functions #282 by @JanMarvin in provide wb_copy_cells. closes #282 #515
• [wb_add_data] string_nums option. closes Write number as character without Excel error #503 by @JanMarvin in [wb_add_data] string_nums option. closes #503 #516
• correct description. closes update wb_add_chart_xml description #483 by @JanMarvin in correct description. closes #483 #517
• Write sst with inline_string = FALSE by @JanMarvin in Write sst with inline_string = FALSE #499
• Empty relship by @JanMarvin in Empty relship #519
• [new feature] Add pivot table by @JanMarvin in [new feature] Add pivot table #520
• safe speedups for add_data by @JanMarvin in safe speedups for add_data #522
• Speedup add data pt4 by @JanMarvin in Speedup add data pt4 #525
• move R code to Rcpp function by @JanMarvin in move R code to Rcpp function #526
• move this out of the loop by @JanMarvin in move this out of the loop #527
• release 0.5 by @JanMarvin in release 0.5 #529

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

---

This discussion was created from the release v0.5.