v0.3

Since the last release there have been a lot of smaller and bigger changes, besides the normal improvements and bug fixes. The biggest change was one that was not visible to the users. With release 0.3 openxlsx2 no longer automatically binds directories like drawings and vmlDrawings. Furthermore there were big improvements like sheets can be cloned, a new helper function for color selection (wb_colour()), a consistent behavior when reading worksheets, it is now possible to add sparklines from openxlsx2, copy cell styles and there was further work on vignettes.

The release 0.3 is the first openxlsx2 release which is available under CRAN. This makes it easier for users to get an impression of openxlsx2. However, the package is not yet fully stable. Until the stable version 1.0 there may still be changes in the API. A look at the issue tracker and the NEWs is recommended in any case.

What's Changed

• [R/tests] add style wrapper tests by @JanMarvin in #259
• [R/print] update print returns by @JanMarvin in #258
• [R/save] fix writing headerFooter. fixes #261 by @JanMarvin in #262
• Revert "[manual] check for ggplot2" by @JanMarvin in #260
• 246 data warn by @jmbarbone in #264
• [R/save] fix writing integers without colNames by @JanMarvin in #266
• [R/cf] cleanups and outsourcing by @JanMarvin in #268
• [vignettes] cf add a few images by @JanMarvin in #269
• cloneSheetStyle -> wb_clone_sheet_style by @JanMarvin in #233
• [tests] add data validation by @JanMarvin in #271
• [R/add_data_table] cleanup update_cell() by @JanMarvin in #275
• [R/update_cell_loop] further speedups by @JanMarvin in #276
• [R/pugi] provide xml_rm_child() by @JanMarvin in #273
• [pugi] print consistency and new format flags to indent attributes by @JanMarvin in #279
• improve random strings by @JanMarvin in #281
• implement add_sparklines() by @JanMarvin in #280
• [man] add family styles by @JanMarvin in #285
• [R/write] add dims argument to write by @JanMarvin in #236
• provide private workbook function do_cell_init() by @JanMarvin in #284
• add wb$add_style() and wrapper wb_add_style(). closes #287 by @JanMarvin in #288
• Allow creation of dxfs style w/o font and bg color. closes #291 by @JanMarvin in #293
• Dxf nofont by @JanMarvin in #290
• fix set_sheet_names by @JanMarvin in #295
• fix get_cell_styles by @JanMarvin in #296
• fix remove_worksheet by @JanMarvin in #297
• [R/save] use dir.exist(). closes #263 by @JanMarvin in #265
• improve NA handling #closes #300 by @JanMarvin in #301
• [R/dataValidation] Fixes #277. by @JanMarvin in #299
• More color options by @JanMarvin in #289
• Charts reading by @JanMarvin in #304
• Add r-universe to readme by @JanMarvin in #298
• allow writing data.table. closes #312 by @JanMarvin in #313
• fixes for clone_worksheet with tables, charts and drawings by @JanMarvin in #305
• wrap more results to keep encoding by @JanMarvin in #315
• fix reading charts. fixes #318 by @JanMarvin in #320
• Fix comments from loaded workbooks by @JanMarvin in #310
• Improve drawings by @JanMarvin in #323
• stop if sheet not found. closes 319 by @JanMarvin in #321
• align dims and rows & cols by @JanMarvin in #326
• No drawings dir by @JanMarvin in #311
• style picking by @JanMarvin in #306
• 329 sheet name by @jmbarbone in #331
• wbColor by @JanMarvin in #292
• wb_to_df gets startCol by @JanMarvin in #330
• add_comment/remove_comment. closes #309 by @JanMarvin in #336
• enable multiple ext in extLst by @JanMarvin in #338
• Begin a basic upgrade vignette by @JanMarvin in #337
• change default col size to 10 by @JanMarvin in #341
• Compress jpeg by @JanMarvin in #342
• bump version by @JanMarvin in #339

Full Changelog: v0.2.1...v0.3