v0.4
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 #398
- [pugixml] update to release 1.13 by @JanMarvin in #400
- [wb_load] update vml file name. fixes #402 by @JanMarvin in #403
- [vignettes] fix a replace all mistake by @JanMarvin in #401
- [wb_load] read x namespace by @JanMarvin in #405
- add ... as argument for wb_to_df() wrappers by @JanMarvin in #381
- Skip empty sheet. fixes #409 by @JanMarvin in #413
- add further named region arguments by @JanMarvin in #386
- Fix sheetPr creation. fixes #416 by @JanMarvin in #417
- Doc custom by @JanMarvin in #418
- handle customXml folder by @JanMarvin in #419
- speedup numfmt assignment by @JanMarvin in #423
- Enforce
fullCalcOnLoad
. closes #427 by @JanMarvin in #428 - tweaks for dates. by @JanMarvin in #424
- Gh issue 429. fixes #429 by @JanMarvin in #430
- [wb_add_data] fix double escapes. fixes #435 by @JanMarvin in #436
- 378 wb save by @jmbarbone in #431
- [wb_load] avoid bailing with empty header by @JanMarvin in #438
- remove all.equal.wbWorkbook by @JanMarvin in #434
- Fix fill merged cells by @sjewo in #441
- Cleanup by @JanMarvin in #442
- update or remove calculation chain. fixes #437 by @JanMarvin in #439
- [wb_load] support chartEX by @JanMarvin in #444
- Fix setting and removing row heights by @JanMarvin in #446
- implement formControl. closes #206 by @JanMarvin in #426
- Set sheetview by @JanMarvin in #399
- improve print options. closes #393 by @JanMarvin in #440
- [wbWorkbook] set_bookview by @JanMarvin in #410
- Minor cleanup by @JanMarvin in #450
- provide add_drawing() for {rvg} by @JanMarvin in #449
- Support {mschart} by @JanMarvin in #451
- release 0.4 by @JanMarvin in #453
New Contributors
Full Changelog: v0.3.1...v0.4