v0.4

[JanMarvin]

Release 0.4 brings again a number of improvements under the hood. For example, writing formatted cells has been improved, but work has also been done to add support for a number of different openxml functions. For example, support for calculation chains and connections has been improved, and form controls are now supported, as are chart extensions and custom properties. Work has also been done on the basics of many openxml functions. It is now possible to request output from right to left (openxlsx2.rightToLeft") and printing options have been revised.

As a major new feature openxlsx2 now brings support for the external packages mschart and rvg. Thanks to @davidgohel for the packages and the quick review and release of mschart 0.4!

The inspiration for many of the new features came from issues and discussions on Github. Many thanks to @AnnePdM, @nicojx and @sjewo!

PS: As always, thanks to deepl :)

What's Changed

• fix implicit cast warning by @JanMarvin in fix implicit cast warning #398
• [pugixml] update to release 1.13 by @JanMarvin in [pugixml] update to release 1.13 #400
• [wb_load] update vml file name. fixes Update vmlDrawing in worksheets_rels #402 by @JanMarvin in [wb_load] update vml file name. fixes #402 #403
• [vignettes] fix a replace all mistake by @JanMarvin in [vignettes] fix a replace all mistake #401
• [wb_load] read x namespace by @JanMarvin in [wb_load] read x namespace #405
• add ... as argument for wb_to_df() wrappers by @JanMarvin in add ... as argument for wb_to_df() wrappers #381
• Skip empty sheet. fixes wb_to_df empty sheet causes error  #409 by @JanMarvin in Skip empty sheet. fixes #409 #413
• add further named region arguments by @JanMarvin in add further named region arguments #386
• Fix sheetPr creation. fixes Sheet-based macros are removed on Workbook save #416 by @JanMarvin in Fix sheetPr creation. fixes #416 #417
• Doc custom by @JanMarvin in Doc custom #418
• handle customXml folder by @JanMarvin in handle customXml folder #419
• speedup numfmt assignment by @JanMarvin in speedup numfmt assignment #423
• Enforce fullCalcOnLoad. closes Workbook formulas are not recalculated on opening in Excel #427 by @JanMarvin in Enforce fullCalcOnLoad. closes #427 #428
• tweaks for dates. by @JanMarvin in tweaks for dates. #424
• Gh issue 429. fixes wb_add_data(..., na.string = NULL) does not work with NA_character_  #429 by @JanMarvin in Gh issue 429. fixes #429 #430
• [wb_add_data] fix double escapes. fixes Ampersands ("&") are read as "&"  #435 by @JanMarvin in [wb_add_data] fix double escapes. fixes #435 #436
• 378 wb save by @jmbarbone in 378 wb save #431
• [wb_load] avoid bailing with empty header by @JanMarvin in [wb_load] avoid bailing with empty header #438
• remove all.equal.wbWorkbook by @JanMarvin in remove all.equal.wbWorkbook #434
• Fix fill merged cells by @sjewo in Fix fill merged cells #441
• Cleanup by @JanMarvin in Cleanup #442
• update or remove calculation chain. fixes Overwriting existing formula causes error when opening file in Excel #437 by @JanMarvin in update or remove calculation chain. fixes #437 #439
• [wb_load] support chartEX by @JanMarvin in [wb_load] support chartEX #444
• Fix setting and removing row heights by @JanMarvin in Fix setting and removing row heights #446
• implement formControl. closes handle ctrlProps folder and files #206 by @JanMarvin in implement formControl. closes #206 #426
• Set sheetview by @JanMarvin in Set sheetview #399
• improve print options. closes add printerOption modifications #393 by @JanMarvin in improve print options. closes #393 #440
• [wbWorkbook] set_bookview by @JanMarvin in [wbWorkbook] set_bookview #410
• Minor cleanup by @JanMarvin in Minor cleanup #450
• provide add_drawing() for {rvg} by @JanMarvin in provide add_drawing() for {rvg} #449
• Support {mschart} by @JanMarvin in Support {mschart} #451
• release 0.4 by @JanMarvin in release 0.4 #453

New Contributors

• @sjewo made their first contribution in Fix fill merged cells #441

Full Changelog: v0.3.1...v0.4

---

This discussion was created from the release v0.4.