v0.5.1

[JanMarvin]

Release 0.5.1 mainly brings improvements to the existing code as well as the usual bug fixes. A newly integrated feature is form controls. It is now possible to create radio buttons, dropdown menus and check boxes directly from openxlsx2.

Cell initialization has been improved, it is now possible to use nested groupings, and external links are now imported in the correct order. Date detection should now be better, and when filling merged cells, the content that is not in the selected dimensions is now taken into account. The biggest change was made to the internal relationship detection, which should now be smarter and behaves more like openxml relationships should work.

The integration of form controls, the faster cell initialization and the possibility of nested grouping were feature requests or resulted from discussion topics. Thank you for the suggestion and the interest in openxlsx2.

The release 0.5.1 is the sixth 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

• Cleanup drawings and vmlDrawings reference by @JanMarvin in Cleanup drawings and vmlDrawings reference #536
• allow nested grouping by @JanMarvin in allow nested grouping #537
• cleanups in wb_load by @JanMarvin in cleanups in wb_load #538
• add form control. closes [FR] add check boxes #532 by @JanMarvin in add form control. closes #532 #533
• improve fillMergedCells. closes fillMergedCells earlier in wb_to_df #324 by @JanMarvin in improve fillMergedCells. closes #324 #541
• additional cleanup from Cleanup drawings and vmlDrawings reference #536 by @JanMarvin in additional cleanup from #536 #542
• create initialize_cell function by @JanMarvin in create initialize_cell function #545
• try to avoid passing long xml strings to file.exists() by @JanMarvin in try to avoid passing long xml strings to file.exists() #543
• Improve wb to df by @JanMarvin in Improve wb to df #547
• 473 na strings by @jmbarbone in 473 na strings #474
• release 0.5.1 by @JanMarvin in release 0.5.1 #549

Full Changelog: v0.5...v0.5.1

---

This discussion was created from the release v0.5.1.