v0.3.1

[JanMarvin]

Release 0.3.1 mainly contains bug fixes for problems found since release 0.3. A big thank you to everyone who reported issues! Among the fixed issues are the following: Writing data to worksheets has been improved. This should speed up writing large data frames onto worksheets #356 . It should be possible to use basic openxlsx2 workbooks with Powerquery #360. Data validation using lists is no longer relying on the x14 extension of openxml #347. Formulas no longer require xml encoding on the user side #384. A few style related issues have been closed: Styles were lost when writing on a existing workbook#359, hyperlink coloring was buggy #344 and some cell styles were behaving inconsistently #372.

The release 0.3.1 is the second 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 create_dxfs_style by @JanMarvin in update create_dxfs_style #346
• [wb_add_data] encode formula by @JanMarvin in [wb_add_data] encode formula #351
• [wb_to_df] Show formula by @JanMarvin in [wb_to_df] Show formula #352
• change update_cell() logic. fixes Writing a large dataframe on a preformated worksheet is slow #356 by @JanMarvin in change update_cell() logic. fixes #356 #358
• simplify code by @JanMarvin in simplify code #361
• [wb_load] xml cleanup by @JanMarvin in [wb_load] xml cleanup #362
• fix partial match. closes partial match of 'dxf' to 'dxfs' in read_xlsx #364 by @JanMarvin in fix partial match. closes #364 #366
• remove deprecated. fixes Rgui names deprecated warning  #239 by @JanMarvin in remove deprecated. fixes #239 #367
• [wb_add_data] unify hyperlink and numeric styling by @JanMarvin in [wb_add_data] unify hyperlink and numeric styling #365
• Data validation list by @JanMarvin in Data validation list #347
• Update pugi by @JanMarvin in Update pugi #377
• [styles] avoid sample names. fixes Formatting a workbook #383 by @JanMarvin in [styles] avoid sample names. fixes #383 #385
• Gh issue 360 by @JanMarvin in Gh issue 360 #363
• [add_data_table] improve rowNames. closes rowNames=TRUE generates a 1 at top-left of the table #354 by @JanMarvin in [add_data_table] improve rowNames. closes #354 #375
• [(un)merge_cells] rm build cell merges by @JanMarvin in [(un)merge_cells] rm build cell merges #390
• allow having hyperlinks in formulas by @JanMarvin in allow having hyperlinks in formulas #388
• Lintr cleanups by @JanMarvin in Lintr cleanups #392
• [write_xlsx] remove keepNA from man page. closes keepNA doesn't work when using write_xlsx #373 by @JanMarvin in [write_xlsx] remove keepNA from man page. closes #373 #382
• [reland] cleanup column width and font size setting by @JanMarvin in [reland] cleanup column width and font size setting #350
• release 0.3.1 by @JanMarvin in release 0.3.1 #395

Full Changelog: v0.3...v0.3.1

---

This discussion was created from the release v0.3.1.