v1.15

Release 1.15 is a big release that brings quite a few changes along the usual fixes.

A lot of time has been spent improving the date, datetime and hms handling in openxlsx2. While the package does not care about the timezone when writing to a spreadsheet, it was returning dates in the local user timezone. This has been changed. Now all dates are returned as in the UTC timezone. Changing this caused a lot of turbulence and required additional patches afterwards. The impact on the user side should be limited to, well all read timezones are now UTC, which may require additional changes on the user side. But, this allows for a much faster import of spreadsheets with many dates. See the PR and issues for changes and examples.

While we try to maintain a semi-stable API changes are inevitable. To prepare for this, deprecated API access now generates warnings. The use of arguments rows =..., cols=... arguments should be replaced with dims = wb_dims(rows = ..., cols = ...). The use of create_comment() is deprecated in favor of wb_comment(). (If you run our code regularly, please try to set options("openxlsx2.soon_deprecated" = TRUE) time and time again, in the future we will deprecate the use of camel case arguments).

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.15 release is the 27th 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

• [load] avoid deconstructing styles XML as data frame if possible by @JanMarvin in #1296
• [load] avoid shared string parsing on load by @JanMarvin in #1297
• [misc] cache the Rcpp::String() result by @JanMarvin in #1298
• [clone] cleanup after #1297 by @JanMarvin in #1299
• [write] fix named hyperlinks as documented by @JanMarvin in #1301
• [grouping] initializes rows if required by @JanMarvin in #1303
• [comments] fix wb_get_comment() and return a visible data frame by @JanMarvin in #1305
• [shape] enable markup compability by @JanMarvin in #1306
• [fml] normalize formulas and fix another cc bug by @JanMarvin in #1307
• [fml] make cm formulas behave like array formulas by @JanMarvin in #1308
• [shape] restore styling shape txt strings by @JanMarvin in #1309
• [xlsb] Fix two issues with external links and unescaped XML by @JanMarvin in #1311
• [write] support table name in write_xlsx() by @JanMarvin in #1314
• [write] Inf, -Inf, and NaN by @JanMarvin in #1317
• [write] improve code to avoid bottlenecks by @JanMarvin in #1318
• [styles] assign name to wb_get_cell_styles() by @JanMarvin in #1319
• [styles] set default value for create_fill() by @JanMarvin in #1321
• [dims] improve dims_to_dataframe() by @JanMarvin in #1324
• [dims] allow dims to be all column or all row by @JanMarvin in #1326
• [misc] Dont wrap by @JanMarvin in #1327
• [read] improve long_to_wide() by @JanMarvin in #1328
• [rcpp] cleanup by @JanMarvin in #1329
• [read] improve date handling by @JanMarvin in #1331
• [misc] convert camelCase to snake_case by @JanMarvin in #1332
• [misc] housekeeping deprecating by @JanMarvin in #1330
• [read] Document changes to reading date/datetime by @JanMarvin in #1335
• [read] reduce date/datetime differences to releases prior 1.15 by @JanMarvin in #1336
• Release 1.15 by @JanMarvin in #1337

Full Changelog: v1.14...v1.15