v1.12

Release 1.12 is a feature-packed release with many improvements, bug fixes and code cleanups.

Over the past two releases, there have been many cleanups to the Rcpp code. For the user this results in some parts of the code running a bit faster, like wb_load() and wb_to_df(). On the developer side, we can now silently build the package with -Wconversion -Wno-sign-conversion, but we went even further and it is now possible to create a build with -Wall -Wpedantic -Wshadow -Wunused -Wconversion -Wsign-compare. Needed? No. Lots of static_cast<>()s? Yes.

A feature requested and provided by @trekonom is the new direction argument which allows grouping of sparklines. It's now also possible to use the current_sheet() waiver with sparkline(). We now load (and save) a few more files without hickups. And it is possible to build the package again with R 3.6 (on Windows just make sure the compiler uses C++11).

There are still bugs/issues/things that have avoided detection for a long time. One of them, discovered by @elipousson, was that the sep argument for combining list columns wasn't implemented at all. Support for partial labels didn't work as intended, and reading non-consecutive dims didn't work as expected. All these issues are now fixed.

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.12 release is the 24th 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 modify date, don't auto-change create date by @mlell in #1176
• [wb_to_df] make equal sized non consecutive dims behave similar to unequal sized non concsecutive dims. by @JanMarvin in #1183
• [Rcpp] avoid copying objects by @JanMarvin in #1184
• [load] attempt to improve the amp_split() function. fixes #1185 by @JanMarvin in #1186
• [misc] cleanup of imported stringi functions by @JanMarvin in #1187
• [write] improve support for partial labels by @JanMarvin in #1189
• [misc] extend bookview handling by @JanMarvin in #1193
• [misc] unify arguments by @JanMarvin in #1195
• [misc] C++ cleanup by @JanMarvin in #1196
• [misc] Fix -Wsign-compare by @JanMarvin in #1197
• [write] restore sep functionality. closes #1199 by @JanMarvin in #1200
• [misc] further file type and file extension checking by @JanMarvin in #1201
• [groups] allow grouping over A1 columns by @JanMarvin in #1203
• [load] handle activeX folder. fixes #1202 by @JanMarvin in #1204
• [misc] enable use of sheet waivers in create functions. fixes #1206 by @JanMarvin in #1207
• [load] read file with d3p1 namespace by @JanMarvin in #1194
• Add functionality to add multiple sparklines as a group. by @trekonom in #1205
• [merge_cells] allow splitting into dimensions by @JanMarvin in #1212
• [load] read featurePropertyBag folder by @JanMarvin in #1216
• [misc] exclude merged cells from wb_set_col_widths(width = "auto") by @JanMarvin in #1215
• [hf] allow updating skipping header / footer as documented. fixes #1209 by @JanMarvin in #1211
• [write] protect against overwriting a shared formula reference. closes #1217 by @JanMarvin in #1218
• [gha] test with the earliest supported R by @JanMarvin in #1219
• Release 1.12 by @JanMarvin in #1220

New Contributors

• @mlell made their first contribution in #1176
• @trekonom made their first contribution in #1205

Full Changelog: v1.11...v1.12

v1.11

Release 1.11 brings bug fixes and internal cleanups.

This release fixes a bug identified earlier this week, where adding a summary row to a data table could result in data loss. A miscalculation in table length caused the last row of the table to be overwritten instead of correctly appending the summary row below. This issue arose as part of an effort to implement a fully customizable totals row, similar to those in spreadsheet software.
Hopefully, the lack of reports suggests the feature was not widely used. However, the bug may have gone unnoticed by some users, as the table’s appearance remained otherwise normal, with only the last column missing.

Additional cleanups include improvements to the Rcpp code and enhanced documentation for number formats.

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.11 release is the 23rd 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

• [pugi] replace child_value() with text().get() by @JanMarvin in #1165
• [misc] avoid scientific notation in as.character(rows). closes #1167 by @JanMarvin in #1170
• [slicer] allow setting hide items with no data by @JanMarvin in #1169
• [docs] extend wb_add_numfmt() details with more detailed guides by @JanMarvin in #1175
• [misc] Cleanup cpp code by @JanMarvin in #1177
• [table] total row must be placed below the table. fixes #1178 by @JanMarvin in #1179
• [tables] escape specials in total row formula by @JanMarvin in #1181
• Release 1.11 by @JanMarvin in #1182

Full Changelog: v1.10...v1.11

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

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

v1.8

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

Most of the work went into our xlsb parser. This has been significantly improved, files that previously could not be imported or were not imported correctly now work. We provide support for "rich" text, hopefully parse array functions much better and even provide support for data validation. There are still many things untouched (like pivot tables and conditional formatting), but loading files should work better than ever. Our previous statement remains, we only offer this as an option for our users, and the recommendation remains, if you want to make sure the file has been imported correctly, use spreadsheet software to convert the file.

We have started to deprecate some features that were used in openxlsx and were useful in early stages of openxlsx2, but are now long since replaced by our own functions or are now internalized and should not be used by users directly. Users should see a warning and a note on what to do. If in doubt, please open a discussion. Everybodys darling wb_dims() can now handle multiple column selections and we've fixed a nasty bug that slowed down writing files with non-consecutive numeric formats (like dates in columns A and C).

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.8 release is the 20th 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

• [xlsb] fix choose by @JanMarvin in #1037
• [misc] avoid cryptic error on blank inline string. fixes #1038 by @JanMarvin in #1039
• [xlsb] fix maybe used uninitialized warning by @JanMarvin in #1040
• [xlsb] fix more array fmls by @JanMarvin in #1042
• [dims] extend wb_dims() to accept multiple columns by @JanMarvin in #1019
• [xlsb] enable rich txt by @JanMarvin in #1044
• [styles] improve/fix style detection. fixes #1045 by @JanMarvin in #1046
• [dims] fix unhandled condtion by @JanMarvin in #1047
• [load] fix loading table slicers by @JanMarvin in #1048
• [xlsb] read PtgMemErr by @JanMarvin in #1049
• [xlsb] parse some table formulas by @JanMarvin in #1052
• [read] add check_names argument. closes #1050 by @JanMarvin in #1051
• [cf] add x14 icon sets as discussed in #1053 by @JanMarvin in #1055
• [write] allow sheet as sheet name in write_xlsx(). closes #1056 by @JanMarvin in #1057
• [xlsb] add data validations by @JanMarvin in #1054
• Unrelated lints to tests by @olivroy in #1063
• Deprecate old functions write_*() and remove_*() by @olivroy in #1064
• [load] fix
  fixing in vml files. closes #1061 by @JanMarvin in #1062
• Update .covrignore by @olivroy in #1065
• [dims] speed up non consecutive dims. fixes #1066 by @JanMarvin in #1067
• [dims] code cleanup by @JanMarvin in #1068
• [write] table column names have to be characters by @JanMarvin in #1071
• Release 1.8 by @JanMarvin in #1069

Full Changelog: v1.7...v1.8

v1.7

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

The support for MIP that was added in 1.6 has been further improved. Previously we added a check for internal folders not being handled by openxlsx2 which was triggered on the [trash] folder, this has been reported and fixed. This folder was added by third party software, similar to a binary blob added when synchronizing files with a third party cloud software. A long time hidden bug was reported and fixed, when columns with special formats surrounded columns in a different format, the styling was applied to those columns as well. Previously, if there were two date columns to the left and right of another column, the column in the middle was also formatted as a date.

There has been support for slicers for some time. This has been extended and now we can create timelines for pivot tables. Our wb_add_timeline() was created to work similarly to wb_add_slicer() on pivot tables created with wb_add_pivot_table(). It is possible to select a specific period, obviously the dim placement and different styles.

We have started to extend our work on the undo changes function. Now we provide wb_remove_conditional_formatting(), wb_remove_slicer() and wb_remove_timeline(). This work has not yet been completed.

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.7 release is the 19th 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 wb_remove_conditional_formatting(). part of #1010 by @JanMarvin in #1011
• [load] silence warning on "[trash]" folder. closes #1012 by @JanMarvin in #1013
• [dims] previously non-consecutive dims could get lost by @JanMarvin in #1015
• [pt] initial support for timelines by @JanMarvin in #1016
• [pt] add wb_add_timeline() by @JanMarvin in #1017
• add remove_slicer(). part of #1010 by @JanMarvin in #1020
• add remove_timeline(). part of #1010 by @JanMarvin in #1021
• [dims] fix overlapping column types. fixes #1023 by @JanMarvin in #1026
• Clearer message for bad select in wb_dims() by @olivroy in #1022
• [xlsb] fix max ccolspan by @JanMarvin in #1030
• [mips] handle docMetadata folder with "LabelInfo.xml" file. closes #1027 by @JanMarvin in #1028
• [vignette] begin redesign of basic manual by @JanMarvin in #1018
• fix warnings from implicit conversions by @JanMarvin in #1035
• [load] remove binary blob. fixes #1032 by @JanMarvin in #1034
• Release 1.7 by @JanMarvin in #1036

Full Changelog: v1.6...v1.7

v1.6

Release 1.6 brings the usual bug fixes and internal cleanups as well as a few selected new features. Big thanks again to @olivroy for his ongoing help with documentation fixes and internal cleanups!

We fulfilled a user request by adding MIP support, which is a kind of confidentiality stamp added to the xlsx file. This only works in certain business environments as we couldn't test it ourselves, thanks for the request and the testing! In addition, it is now possible to add custom properties via wb_set_properties().

Initial support for richData folders has been added, so it is possible to read spreadsheets with images embedded in cells. (This has not been fully tested, please let us know if you encounter problems). After a long time, another nice addition is the added support for non-contiguous dimensions, finally something like "A1:B2,B4:C5" can be used with e.g. wb_add_fill() and it is even possible to write data into different cells!

Among the bug fixes and internal cleanups: It is now possible to write data frames with zero rows, we've fixed the remaining few cases of partial matching, and improved some error and warning messages to let our users know what exactly is going on.

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.6 release is the 18th 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] read & write richData folder by @JanMarvin in #982
• [WIP] add MIP support. closes #979 by @JanMarvin in #983
• update wb_dims error by @olivroy in #984
• Avoid partial matching by @olivroy in #986
• [write] do not try to apply a cell style to data frames with zero rows. fixes #985 by @JanMarvin in #987
• [dims] add check for valid cols argument. fixes #987 by @JanMarvin in #989
• fix corner cases of wb_dims + standardize error messages by @olivroy in #990
• Partial match by @olivroy in #992
• [gha] add recheck.yml by @JanMarvin in #994
• [pt] provide downfill option. This fill labels vertically by @JanMarvin in #996
• Rm start first by @olivroy in #997
• use Rf_isBlankString() by @JanMarvin in #999
• [WIP] More flexible dims by @JanMarvin in #993
• [xlsb] update defines to revision 17.0 by @JanMarvin in #1004
• Be strict about cols, widths, hidden lengths. by @olivroy in #991
• Release 1.6 by @JanMarvin in #1008

Full Changelog: v1.5...v1.6

v1.5

Release 1.5 brings the usual bug fixes and a few improvements to vector writing. The release was a bit bumpier than previous releases as the package is now suggested by three CRAN packages and even an import for one. Thanks for your trust in us!

Our beloved dims handler wb_dims() received another round of improvements and is now able to handle the positioning of dims using a new from_dims argument, you guessed it. Additionally, it is possible to use other positioning arguments (below, above, left, right) that can be given integer offsets (wb_dims(from_dims = "A1", right = 2), places the new dimension two columns right to the previous dimension). Quite exited to see if this works as well as I hope!

A feature request has been solved with the new openxlsx2.na.strings option, which can be used to change the default na.strings, and the page setup feature has been placed on a new foundation. What caused the bumpy release was a revdep failure discovered at the last minute by CRAN: this was caused by us changing how vectors can be positioned. Previously, it was necessary to transpose vectors before writing them to the worksheet with t(vector). Since version 1.5 it is possible to position the vector with dims only. The initial implementation caused a test in one of the CRAN packages to fail, and of course this had to be fixed first.

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 1.5 is the 17th 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

• [misc] restore start_row/start_col in deprecated function arguments. Closes #952 by @JanMarvin in #953
• [wrapper] export wb_add_ignore_error(). Fixes #954 by @JanMarvin in #955
• [comment] export wb_get_comment() by @JanMarvin in #956
• [formulas] allow passing array formula vectors by @JanMarvin in #958
• [write] add total_row option to wb_add_data_table() by @JanMarvin in #959
• Add from_dims to wb_dims by @olivroy in #960
• [add_image] fix logic to allow adding images after a drawing w/o relships by @JanMarvin in #961
• Fix doc typo by @olivroy in #963
• Add openxlsx2.na.strings option by @olivroy in #968
• [page_setup] improve page setup by @JanMarvin in #966
• Fix docs by @olivroy in #970
• [write] dims impact the direction vectors are written by @JanMarvin in #974
• Release 1.5 by @JanMarvin in #977

Full Changelog: v1.4...v1.5

v1.4

Release 1.4 brings the usual bug fixes and some improvements to pivot tables and new style options.

An important change that users will notice immediately is the switch to a new Office theme and from Calibri as the default font to Aptos Narrow. The included themes have been slightly extended and we have optimized wb_set_base_font() and added wb_set_base_colors()/wb_get_base_colors(). Yes, now it is possible to change the font and colors of a worksheet theme directly from openxlsx2.

This release also brings another round of improvements for pivot tables. It is now possible to calculate formulas (a previous user request), and sorting elements should finally work as intended. In the often neglected write_xlsx() function, it is now possible to freeze columns and rows, something that did not work before and was discovered when writing tests and examining coverage reports.

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 1.4 is the 16th 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

• [pt] calculate pivot table field with formula by @JanMarvin in #892
• [XML] fix writing characters with xml content. closes #894 by @JanMarvin in #895
• [write] fix hyperlink issue with third party class tbl_df. closes #893 by @JanMarvin in #898
• [load] better error message for zip compressed input files. closes #896 by @JanMarvin in #897
• [styles] Update default style Office Theme and default font by @JanMarvin in #899
• [write] rbind() and reorder is quicker and cleanup unused elements by @JanMarvin in #901
• [write] cleanup by @JanMarvin in #902
• [write_xlsx] restore first_active_{col,row} and first_{col,row} by @JanMarvin in #903
• [pt] fix non distinct names in wb_data object by @JanMarvin in #911
• [pt] another attemt to fix item sorting by @JanMarvin in #912
• [pt] disable subtotals by @JanMarvin in #913
• [tests increase coverage by @JanMarvin in https://github.com//pull/916
• [pt] Create pivot table styles by @JanMarvin in #914
• [misc] cleanup and coverage by @JanMarvin in #917
• [comments] fix adding more than two background images. closes #918 by @JanMarvin in #919
• [sparklines] improve sparklines by @JanMarvin in #920
• code lints by @olivroy in #924
• Partial matching + table name error message. by @olivroy in #923
• Update tests + various lints by @olivroy in #922
• [write_xlsx] allow tab_colour by @JanMarvin in #927
• [doc] Update openxlsx2-package by @JanMarvin in #928
• [wb_data] add subset method by @JanMarvin in #906
• [misc] update NEWS, WORDLIST, _pkgdown.yml by @JanMarvin in #931
• [docs] update wb_add_data()/wb_add_data_table() by @JanMarvin in #932
• [style] fix wb$set_base_font() by @JanMarvin in #933
• [styles] improve wb_set_base_font() by @JanMarvin in #935
• Misc doc edits by @olivroy in #936
• [style] update hyperlink to use theme and base size by @JanMarvin in #937
• [styles] add wb_set_base_colors()/wb_get_base_colors() by @JanMarvin in #938
• [style] further tweaking of theme colors by @JanMarvin in #940
• Snake case conversion. by @olivroy in #943
• Improve wb_add_data() error message when no worksheet by @olivroy in #942
• [doc] minor doc cleanup by @JanMarvin in #945
• Release 1.4 by @JanMarvin in #947

Full Changelog: v1.3...v1.4

v1.3

Release 1.3 brings the usual bug fixes and some improvements to documentation.

Even though I don't like working on performance issues, this version brings long overdue improvements to wb_add_data(). In particular, writing larger matrix objects should now be much faster. In addition, wb_load() has received minor improvements and a much longer documentation text. The documentation for wb_add_pivot_table() has also been improved. Further documentation can be found in the WIP book.

In wb_to_df() an error has been fixed where the column name was omitted in combination with col_names = FALSE for logical columns. Due to issues raised by @Layalchristine24, a new function wb_set_cell_style_across() has been added. This is required in conjunction with some options in wb_protect_worksheet() such as deleteColumns/deleteRows. The currency style has also been reset to the originally intended behavior. It is now also possible to change the color of comments or add a background image for them.

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 1.3 is the 15th 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

• [ignore_error] Ignore error returned a worksheet by @JanMarvin in #865
• Add reference to book by @olivroy in #867
• [wb_comment] modify the background color. closes #869 by @JanMarvin in #870
• Wb add style across by @JanMarvin in #873
• [docs] updates to wb_to_df(), wb_add_pivot_table() and options() by @JanMarvin in #874
• [write] disable hyperlink check for matrix otherwise vapply runs on e… by @JanMarvin in #876
• [Styles] restore currency style. fixes #878 by @JanMarvin in #879
• [load] Minor tweak to loadvals() and update documentation by @JanMarvin in #880
• [write] skip unused fill in dims_to_dataframe(). by @JanMarvin in #882
• [wb_to_df] keep column names with col_names = FALSE for logical columns. closes #883 by @JanMarvin in #884
• [misc] stop on unzip error with explicit message and check dimension limits by @JanMarvin in #887
• Release 1.3 by @JanMarvin in #890

Full Changelog: v1.2...v1.3