v1.9

Release 1.9 brings the usual bug fixes and internal cleanups as well as a few selected new features, and our documentation is now available in dark mode.

A lot of work has been invested in the integration of shared formulas. It is now possible to create shared formulas, similar to how you can drag cells horizontally or vertically in spreadsheet software. Gone are the days of having to be creative to create formulas just to sum a few columns. To use this function, select a dimension where you want to place the formulas, add a formula and select shared = TRUE. We can now also show shared formulas with show_formula = TRUE.

The wb_dims() function has been extensively rewritten as part of the maintenance work to simplify the code and eliminate corner case issues. User requests included improvements to creating spreadsheet headers (#1085), reading formulas as formula with wb_to_df() (#1072), as well as a fix in wb_to_df()'s skip_hidden_row, which previously only worked with wbWorkbooks and not with paths (#1120), and we fixed a bug with unknown fonts (#1079). Finally, we have fixed an issue with CRANs oldrel Mac builds so that CRAN binaries are available again for all R variants.

A lot of time was spent on 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 1.9 release is the 21st openxlsx2 release available on CRAN. Even though the package is now semi-stable, it is always a good idea to make regular backups and check the output files. A look at the issue tracker and the NEWs is highly recommended.

What's Changed

• Add dark mode to website by @olivroy in #1076
• [fml] create shared formulas by @JanMarvin in #1074
• [fonts] fallback to Aptos Narrow width if font not found. closes #1079 by @JanMarvin in #1080
• [header] add scaling with doc and allign with margins options. closes #1085 by @JanMarvin in #1086
• [read] read shared formulas. closes #1072 by @JanMarvin in #1091
• [named_region] add checks for named region string. closes #1095 by @JanMarvin in #1097
• [wb_dims] without x and non sequential rows, incorrect results were returned. fixes #1093 by @JanMarvin in #1094
• Correct DESCRIPTION by @olivroy in #1102
• [wb_to_df] create type f when reading formula by @JanMarvin in #1103
• Avoid adding the worksheet styling image on the CRAN vignette by @olivroy in #1106
• Wb dims bug by @olivroy in #1107
• [xlsb] comment due to gcc 12 false positive. Was not used. by @JanMarvin in #1109
• [misc] document compression level option. closes #1113 by @JanMarvin in #1119
• [wb_to_df] Fix skip_hidden_cols = TRUE. closes #1121 by @JanMarvin in #1122
• [doc] add a sentence how the column type is selected. closes #1117 by @JanMarvin in #1123
• [tests] skip online checks by @JanMarvin in #1127
• [dims] simplify wb_dims(). fixes #1124 by @JanMarvin in #1125
• [vignette] add purl = FALSE to chunks using ggplot2. fixes #1073 by @JanMarvin in #1128
• Release 1.9 by @JanMarvin in #1129

Full Changelog: v1.8...v1.9