v1.10

Release 1.10 brings the usual bug fixes and internal cleanups as well as a few selected new features.

A lot of work was spent in hyperlink handling. The entire internal structure for shared hyperlinks was rewritten and it is possible to add and remove shared hyperlinks using wb_add_hyperlink()/wb_remove_hyperlink() and wb_to_df() gained a new argument show_hyperlink to show the hyperlink target instead of the hyperlink text.

When reading types with wb_to_df() it is now possible to define the type as R data class, instead of the somewhat cryptic openxlsx2 data types. And tables saw a couple of cleanups, ironing out corner cases. Non distinct column names are handled as well as previously non unique table ids. When saving with na.strings = NULL, cells with missing data are no longer written into the worksheet. This can have significant impact on the file size, you can think of the output as a sparse matrix.

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.10 release is the 22nd 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

• [formula] Restore extending single cell dims for wb_add_formula(). fixes #1130 by @JanMarvin in #1131
• [dims] column names should not be evaluated. fixes #1132 by @JanMarvin in #1133
• [write] skip blanks by @JanMarvin in #1111
• [misc] cleanup in wb_dims code and add curl to gha by @JanMarvin in #1134
• [read] add show_hyperlinks argument. closes #1135 by @JanMarvin in #1136
• [WIP] begin hyperlink rewrite by @JanMarvin in #1137
• [image] add address argument to wb_add_image() by @JanMarvin in #1138
• [hl] helper to remove hyperlinks by @JanMarvin in #1139
• [clean] The wrapper wb_clean_sheet() gained a new argument hyperlinks by @JanMarvin in #1140
• [clone] fix cloning from worksheet with multiple images by @JanMarvin in #1141
• [styles] speedup wb_get_cell_style() by @JanMarvin in #1143
• [tables] correct non distinct column names. closes #1149 by @JanMarvin in #1150
• [tables] enforce unique table id. closes #1151 by @JanMarvin in #1152
• [wb_to_df] improve types. closes #1146 by @JanMarvin in #1147
• [tables] only use active tables in wb_get_named_regions(). closes #1154 by @JanMarvin in #1155
• [wb_to_df] fix reading tables from file path. closes #1159 by @JanMarvin in #1160
• [formula] handle named formulas. closes #1157 by @JanMarvin in #1158

Full Changelog: v1.9...v1.10