v0.7
Release 0.7 brings many new features, alongside the usual bug fixes.
Formula handling has been greatly improved in wb_add_formula() to include cell metadata and ranges for array formulas. You can read about these features in the newly added formula vignette, which covers various types of formulas. In addition ,you might be interested in wb_add_ignore_error() to suppress unwanted evaluation errors in spreadsheet software.
In the style sections, fmt_txt() has been introduced as a new function to style parts of strings. An example of how to use this function is included in the updated style vignette. Finally, it is now possible to use custom table styles and create them.
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 is the ninth 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
- [wb_add_formula] updates to formulas including vignette. closes #490 by @JanMarvin in #593
- allow custom table styles by @JanMarvin in #594
- unify genBaseCore usage in wbWorkbook and write_xlsx. fixes #599 by @JanMarvin in #600
- [doc] fix typo in write_xlsx by @JanMarvin in #602
- Support hms writing by @JanMarvin in #601
- load tableStyles by @JanMarvin in #603
- Random axis ids by @JanMarvin in #605
- Fmt txt. closes #107 by @JanMarvin in #607
- Outdec. closes #610 by @JanMarvin in #611
- Default to char by @JanMarvin in #615
- create_tablestyle by @JanMarvin in #609
- update vignettes.closes #613 by @JanMarvin in #616
- ignore error by @JanMarvin in #617
- update style vignette by @JanMarvin in #618
- Chartsheet cleanup by @JanMarvin in #619
- Safer removal of mixed sheet type workbooks by @JanMarvin in #621
- Update table by @JanMarvin in #606
- [WIP] check for missing files by @JanMarvin in #267
- add wb_set_sheetview. closes #394 by @JanMarvin in #604
- Write Hyperlinks if required. closes #624 by @JanMarvin in #625
- Release 0.7 by @JanMarvin in #626
Full Changelog: v0.6.1...v0.7
