v1.0

Release 1.0 is finally here. While it's just a number in the grand scheme of things, the goal is that we've achieved a semi-stable API. This means that the public API will not change in the foreseeable future, unless pressing reasons force us to do so. That being said, a lot has been done and worked on in the last few weeks.

Thanks to the work of @olivroy, the long-neglected documentation in examples and vignettes has been overhauled and now looks better than ever. Examples have been added where they were missing and cleaned up where they were outdated. The entire pkgdown page has been reworked. Building on the consistent arguments work we did in the previous version, this really makes the version shine.

A lot of time went into various bug fixes, cleanups and minor improvements here and there. Among the few fixes, there is one that requires a detailed explanation. It was discovered that we were not handling the 1904 date format correctly. As a result, our dates were always 4 years off for this date format, which was mainly used by Excel on the Mac. That's a little shameful that it took so long and came up rather by accident. Hopefully it's a sign that this format is rarely used. However, it's certainly a reminder that no code is error-free, not even the most scrutinized in the world, so it's always wise to remain vigilant and question unusual output. In addition, a number of fixes and features were developed based on user requests and needs. If you find an error, please let us know!

The release 1.0 is the twelfth openxlsx2 release which is available under CRAN. Even though the package is now now semi-stable, it is always a good idea to make regular backups and check output files regularly. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• [get_sheet_names] add escape argument. closes #252 by @JanMarvin in #724
• [vignette] Fix dataTable formula by @JanMarvin in #727
• Sharp hex by @JanMarvin in #728
• fixes for wb_load() from #688 by @JanMarvin in #732
• Fix threaded comment id. closes #731 by @JanMarvin in #734
• Flexible merge by @JanMarvin in #733
• Various wb$sheet_names related fixes and cleanups in wb_functions.R by @JanMarvin in #735
• [wb_to_df] fix date1904 conversion by @JanMarvin in #737
• guard against empty cc cases. closes #739 by @JanMarvin in #740
• [wb_load] add path to object on. closes #741 by @JanMarvin in #742
• fix wb_set_header_footer(). closes #747 by @JanMarvin in #748
• restore and improve tab_color by @JanMarvin in #750
• copy header/footer code by @JanMarvin in #751
• Review documentation and examples by @olivroy in #749
• provide basename2 for to long strings by @JanMarvin in #755
• [fmt_txt] escape xml by @JanMarvin in #757
• Export wb_comment() by @olivroy in #758
• [docs] update man page for create_hyperlink() by @JanMarvin in #759
• Remove wbChartSheet from exports by @olivroy in #760
• Vignette names by @olivroy in #762
• Make wb_get_named_regions() a wrapper. by @olivroy in #764
• Pkgdown family by @olivroy in #763
• Review threaded comment docs by @olivroy in #765
• internal: use wb_comment() in wb_add_thread + deprecations guide by @olivroy in #766
• Final reordering in pkgdown by @olivroy in #768
• Remove duplicated docs + remove internal functions docs. by @olivroy in #769
• Release 1.0 by @JanMarvin in #743

Full Changelog: v0.8...v1.0