v0.7.1

Release 0.7.1 is another milestone on the way to 1.0, bringing a few style improvements and the usual bug fixes.

The release introduces wb_add_named_style(), a new function to create named styles like Note or Title from openxlsx2. This function is accompanied by the introduction of workbook themes. The fmt_txt() function, introduced in release 0.7, has been improved to provide a class with print() and + methods. This should make it easier for the user to create and design workbooks.

Further optimizations have been made to the creation of conditional formatting. A new function wb_add_dxfs_style() has been introduced and color gradients can now be used to create conditional formatting styles. Objects with a label attribute are now treated according to the label, new (experimental) changes have been made to the creation of pivot table number formats and ordering.

A lot of time went into various bug fixes, cleanups, and minor improvements here and there. A number of the fixes and features were developed based on user requests and needs. If you find a bug, please let us know!

The release 0.7.1 is the tenth 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

• [wbWorkbook] Themes by @JanMarvin in #630
• [wb_to_df] Fix cols by @JanMarvin in #631
• Download files in setup.R. closes #345 by @JanMarvin in #632
• download_testfiles() for coverage by @JanMarvin in #633
• try 100 times by @JanMarvin in #634
• [wbStyles] Add as_xml_attr by @JanMarvin in #637
• [fmt_txt] add class and methods by @JanMarvin in #636
• add to_string() to convert variables with labels attribute by @JanMarvin in #639
• [styles] Create named styles. closes #274 by @JanMarvin in #628
• attempt to write utf8 on non utf8 os by @JanMarvin in #641
• [cf] add dims argument by @JanMarvin in #645
• [wb_load; cf] fix conditional formatting range. closes #646 by @JanMarvin in #647
• add gradientFill option to `create_dxfs_style(). closes #648 by @JanMarvin in #651
• escape if pivot cacheField is string. closes #649 by @JanMarvin in #650
• export internal dims helpers.closes #652 by @JanMarvin in #653
• add dims to wb_add_conditional_formatting(). closes #654 by @JanMarvin in #655
• [wb_set_sheet_names] add details text. closes #656 by @JanMarvin in #657
• [add_clone_worksheet] fix comments. closes #658 by @JanMarvin in #659
• fix named regions by @JanMarvin in #660
• restore coverage for styles_mgr by @JanMarvin in #661
• [protect] allow logical operators in protect worksheet by @JanMarvin in #662
• [styles] add wb_add_dxfs_style() wrapper by @JanMarvin in #665
• attempt to escape conditional formatting by @JanMarvin in #666
• [experimental] Pivot table improvements by @JanMarvin in #669
• [experimental] cleanup pivot sorting by @JanMarvin in #670
• Release 0.7.1 by @JanMarvin in #671

Full Changelog: v0.7...v0.7.1