v0.3.1

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 #346
• [wb_add_data] encode formula by @JanMarvin in #351
• [wb_to_df] Show formula by @JanMarvin in #352
• change update_cell() logic. fixes #356 by @JanMarvin in #358
• simplify code by @JanMarvin in #361
• [wb_load] xml cleanup by @JanMarvin in #362
• fix partial match. closes #364 by @JanMarvin in #366
• remove deprecated. fixes #239 by @JanMarvin in #367
• [wb_add_data] unify hyperlink and numeric styling by @JanMarvin in #365
• Data validation list by @JanMarvin in #347
• Update pugi by @JanMarvin in #377
• [styles] avoid sample names. fixes #383 by @JanMarvin in #385
• Gh issue 360 by @JanMarvin in #363
• [add_data_table] improve rowNames. closes #354 by @JanMarvin in #375
• [(un)merge_cells] rm build cell merges by @JanMarvin in #390
• allow having hyperlinks in formulas by @JanMarvin in #388
• Lintr cleanups by @JanMarvin in #392
• [write_xlsx] remove keepNA from man page. closes #373 by @JanMarvin in #382
• [reland] cleanup column width and font size setting by @JanMarvin in #350
• release 0.3.1 by @JanMarvin in #395

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