v0.2.1

[JanMarvin]

Since the first public release there have been many small and larger changes under the hood. Most notably, the handling of non-Unicode encodings in R versions prior to 4.2 has been improved, as has the handling of missing data when writing output files. Newly added are a few helper functions for working with style formatting. Also, a pretty cool new feature is that some of our internal functions now remember the last sheet you were working on, further improving the way you can work with data.

The full pull request log is below, but the full list of changes is even more extensive.

What's Changed

• read cell attributes cm, ph, and vm by @JanMarvin in read cell attributes cm, ph, and vm #173
• [R/conditional_formatting] fix multiple databar entries per sheet by @JanMarvin in [R/conditional_formatting] fix multiple databar entries per sheet #174
• Update issue templates by @jmbarbone in Update issue templates #172
• Empty cell information by @JanMarvin in Empty cell information #178
• Wb to df cleanup by @JanMarvin in Wb to df cleanup #180
• 170 open windows by @jmbarbone in 170 open windows #171
• Combine writes by @JanMarvin in Combine writes #175
• [tests] styles read write test pt2 by @JanMarvin in [tests] styles read write test pt2 #182
• [R/load] remove references to printerSettings.bin. Closes remove printerSettings1.bin from worksheets_rels #184 by @JanMarvin in [R/load] remove references to printerSettings.bin. Closes #184 #185
• [c++/load] load file without row attribute by @JanMarvin in [c++/load] load file without row attribute #187
• [c++/pugi] use parse_ws_pcdata. closes Issue with shared strings #188 by @JanMarvin in [c++/pugi] use parse_ws_pcdata. closes #188 #189
• [R/load] fix duplicates in example file with missing r attributes by @JanMarvin in [R/load] fix duplicates in example file with missing r attributes #190
• provide data_only mode for wb_load() by @JanMarvin in provide data_only mode for wb_load() #181
• replace tables list object with data frame by @JanMarvin in replace tables list object with data frame #191
• [styles] Table styles read/write by @JanMarvin in [styles] Table styles read/write #194
• Wrap std::string in Rcpp::String by @JanMarvin in Wrap std::string in Rcpp::String #198
• Attempt to write UTF-8 from non UTF-8 systems. Did not test this by @JanMarvin in Attempt to write UTF-8 from non UTF-8 systems. Did not test this #199
• [R/load] guard against broken vml. closes vml must not be valid xml #201 and imported xlsm shoud write temp xlsm for wb$open() #200 by @JanMarvin in [R/load] guard against broken vml. closes #201 and #200 #202
• [R/load&save] change slicer numbers. closes slicers can be assigned incorrectly  #203 by @JanMarvin in [R/load&save] change slicer numbers. closes #203 #205
• [R/save] check that comments are saved correctly by @JanMarvin in [R/save] check that comments are saved correctly #209
• Encoding by @JanMarvin in Encoding #207
• update codecov.yml by @JanMarvin in update codecov.yml #211
• update theme by @JanMarvin in update theme #212
• 176 options by @jmbarbone in 176 options #210
• 165 sheet names by @jmbarbone in 165 sheet names #179
• [R/get_named_region] add tables to get_named_region() by @JanMarvin in [R/get_named_region] add tables to get_named_region()  #193
• [R/add_border] add_border and wb_add_border by @JanMarvin in [R/add_border] add_border and wb_add_border #220
• [R/add_fill] provide add_fill helper by @JanMarvin in [R/add_fill] provide add_fill helper #222
• [R/add_font] add font for cells by @JanMarvin in [R/add_font] add font for cells #228
• [R/add_numfmt] wb_add_numfmt and wb$add_numfmt by @JanMarvin in [R/add_numfmt] wb_add_numfmt and wb$add_numfmt #229
• [R/add_cell_style] initial creation of add_cell_style. by @JanMarvin in [R/add_cell_style] initial creation of add_cell_style.  #230
• 113 sheet funs by @jmbarbone in 113 sheet funs #183
• [R/wbWorkbook] remove createFontNode by @JanMarvin in [R/wbWorkbook] remove createFontNode #235
• remove wb_get_sheet_name by @JanMarvin in remove wb_get_sheet_name #240
• a helper column with the cell name. closes custom `.DollarNames` #251 by @JanMarvin in a helper column with the cell name. closes #251 #242
• Encoding fixes by @JanMarvin in Encoding fixes  #243
• [c++] remove match from col_to_df() by @JanMarvin in [c++] remove match from col_to_df() #245
• re-enable oldrel-1 by @jmbarbone in re-enable oldrel-1 #247
• [manual] check for ggplot2 by @JanMarvin in [manual] check for ggplot2 #248
• 214 conditional formatting by @jmbarbone in 214 conditional formatting #227
• [R/write] update cell dups by @JanMarvin in [R/write] update cell dups #249
• [R/write] fixes for NA, NaN, and Inf. Closes capture infinite and nan when writing  #254 by @JanMarvin in [R/write] fixes for NA, NaN, and Inf. Closes #254 #255
• [R/write] add na.strings argument to write functions by @JanMarvin in [R/write] add na.strings argument to write functions #256
• release 0.2.1 by @JanMarvin in release 0.2.1 #253

Full Changelog: v0.2.0...v0.2.1

---

This discussion was created from the release v0.2.1.