v0.8

Release 0.8 might be the last milestone on the way to 1.0 and brings a lot of changes and cleanups to the API and exported functions. Please note: If no drastic issues show up in bug reports in the coming days, the current API will become the 1.0 API, which will be semi-stable (i.e. if no changes are required, it will not change in the foreseeable future). The current changes were needed to streamline the API and provide a pleasant user experience.

Finally, the long overdue cleanup of arguments from camel case to snake case has been addressed. Hopefully this has been archived in a way that is backwards compatible and warnings and broken code should be limited. Basically, a function foo(camelCase=bar) is now foo(snake_case=bar), although for now it should accept both variants. The solution to this problem was to pass the arguments for camelCase to ... and convert them under the hood to variables for snake case. There are obviously some limitations to this approach, but we felt it was too close to a 1.0 release to break the API in such a drastic way.

Another addition is the introduction of wb_dims(), a helper function introduced for interacting with the dims argument of openxlsx2 workbook functions. Many of the previous row/rows, col/cols and xy variants are deprecated, and users are recommended to use dims either the simple A1 notation for cells with the existing helper functions like int2col() or the feature-rich wb_dims(). Thanks to the work of @olivroy, who improved the function in various commits, there is a detailed man page for this function with many examples of how to use it.

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.8 is the eleventh 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

• Rename convertToExcelDate by @olivroy in #672
• Rename convertToExcelDate and cleanups for deprecated functions by @JanMarvin in #673
• [data_table] Do not break on zero row data frame input. fixes #676 by @JanMarvin in #677
• [experimental] standardize function arguments by @JanMarvin in #678
• Update vignettes to snake_case, and other code quality updates by @olivroy in #682
• R/write.R cleanup by @olivroy in #683
• warn on unused arguments in standardize_case_names() by @JanMarvin in #690
• provide wb_dims() by @JanMarvin in #691
• [WIP] handling of threaded comments by @JanMarvin in #674
• Gh issue 681 pt1 by @JanMarvin in #693
• Stop advertising functions that don't fit in openxlsx2 API by @olivroy in #694
• Update vignettes to latest recommended API. by @olivroy in #698
• Misc by @JanMarvin in #701
• update .lintr by @JanMarvin in #700
• force datetime creation. closes #685 by @JanMarvin in #686
• clean up by @JanMarvin in #704
• validate_new_sheet now tries to fix the sheet name. closes #687 by @JanMarvin in #705
• Review wb_dims() by @olivroy in #702
• Fix deprecation code for start_col/start_row. closes #706 by @JanMarvin in #707
• Gh issue 681 pt2 by @JanMarvin in #708
• [write_xlsx] supply sheetName for single argument. closes #711 by @JanMarvin in #712
• unique is not enough for pivot tables. closes #713 by @JanMarvin in #714
• return all formulas. previously dates would interfere by @JanMarvin in #715
• Improve wbWorkbook documentation. by @olivroy in #718
• Rename workbook_grouping to wb_grouping by @olivroy in #719
• Review examples by @olivroy in #720
• silence warnings in create_dxfs_style() by @JanMarvin in #721
• Documentation improvements by @olivroy in #717
• Save path by @JanMarvin in #723
• wb_grid_lines -> wb_set_grid_lines by @JanMarvin in #725
• Release 0.8 by @JanMarvin in #709

New Contributors

• @olivroy made their first contribution in #672

Full Changelog: v0.7.1...v0.8