v0.4.1

Release 0.4.1 mainly contains bug fixes for problems found since release 0.4. A bug with broken XML specials has been fixed #467 and the calculation chain is now an optional feature #432. Options to use mschart output in openxlsx2 has been improved and it is now possible to add chart sheets! Examples for charts are now included via an openxlsx2 charts manual vignette.

The release 0.4.1 is the fourth openxlsx2 release which is available under CRAN. 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

• fix add_drawing() sheet logic. closes #457 by @JanMarvin in #458
• add calc_chain argument to wb_load. closes #432 by @JanMarvin in #461
• Fix writing xml escaped characters. fixes #467 by @JanMarvin in #468
• fix freeze pane and support loading freezePane. closes #459 by @JanMarvin in #465
• improve wb_data(). closes #460 by @JanMarvin in #462
• Row hide by @JanMarvin in #475
• create chartsheets. closes 464 by @JanMarvin in #466
• Charts vignette by @JanMarvin in #478
• release 0.4.1 by @JanMarvin in #481

Full Changelog: v0.4...v0.4.1

v0.4

Release 0.4 brings again a number of improvements under the hood. For example, writing formatted cells has been improved, but work has also been done to add support for a number of different openxml functions. For example, support for calculation chains and connections has been improved, and form controls are now supported, as are chart extensions and custom properties. Work has also been done on the basics of many openxml functions. It is now possible to request output from right to left ("openxlsx2.rightToLeft") and printing options have been revised.

As a major new feature openxlsx2 now brings support for the external packages mschart and rvg. Thanks to @davidgohel for the packages and the quick review and release of mschart 0.4!

The inspiration for many of the new features came from issues and discussions on Github. Many thanks to @AnnePdM, @nicojx and @sjewo!

PS: As always, thanks to deepl :)

What's Changed

• fix implicit cast warning by @JanMarvin in #398
• [pugixml] update to release 1.13 by @JanMarvin in #400
• [wb_load] update vml file name. fixes #402 by @JanMarvin in #403
• [vignettes] fix a replace all mistake by @JanMarvin in #401
• [wb_load] read x namespace by @JanMarvin in #405
• add ... as argument for wb_to_df() wrappers by @JanMarvin in #381
• Skip empty sheet. fixes #409 by @JanMarvin in #413
• add further named region arguments by @JanMarvin in #386
• Fix sheetPr creation. fixes #416 by @JanMarvin in #417
• Doc custom by @JanMarvin in #418
• handle customXml folder by @JanMarvin in #419
• speedup numfmt assignment by @JanMarvin in #423
• Enforce fullCalcOnLoad. closes #427 by @JanMarvin in #428
• tweaks for dates. by @JanMarvin in #424
• Gh issue 429. fixes #429 by @JanMarvin in #430
• [wb_add_data] fix double escapes. fixes #435 by @JanMarvin in #436
• 378 wb save by @jmbarbone in #431
• [wb_load] avoid bailing with empty header by @JanMarvin in #438
• remove all.equal.wbWorkbook by @JanMarvin in #434
• Fix fill merged cells by @sjewo in #441
• Cleanup by @JanMarvin in #442
• update or remove calculation chain. fixes #437 by @JanMarvin in #439
• [wb_load] support chartEX by @JanMarvin in #444
• Fix setting and removing row heights by @JanMarvin in #446
• implement formControl. closes #206 by @JanMarvin in #426
• Set sheetview by @JanMarvin in #399
• improve print options. closes #393 by @JanMarvin in #440
• [wbWorkbook] set_bookview by @JanMarvin in #410
• Minor cleanup by @JanMarvin in #450
• provide add_drawing() for {rvg} by @JanMarvin in #449
• Support {mschart} by @JanMarvin in #451
• release 0.4 by @JanMarvin in #453

New Contributors

• @sjewo made their first contribution in #441

Full Changelog: v0.3.1...v0.4

v0.3.1

Release 0.3.1 mainly contains bug fixes for problems found since release 0.3. A big thank you to everyone who reported issues! Among the fixed issues are the following: Writing data to worksheets has been improved. This should speed up writing large data frames onto worksheets #356 . It should be possible to use basic openxlsx2 workbooks with Powerquery #360. Data validation using lists is no longer relying on the x14 extension of openxml #347. Formulas no longer require xml encoding on the user side #384. A few style related issues have been closed: Styles were lost when writing on a existing workbook #359, hyperlink coloring was buggy #344 and some cell styles were behaving inconsistently #372.

The release 0.3.1 is the second openxlsx2 release which is available under CRAN. 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

• update create_dxfs_style by @JanMarvin in #346
• [wb_add_data] encode formula by @JanMarvin in #351
• [wb_to_df] Show formula by @JanMarvin in #352
• change update_cell() logic. fixes #356 by @JanMarvin in #358
• simplify code by @JanMarvin in #361
• [wb_load] xml cleanup by @JanMarvin in #362
• fix partial match. closes #364 by @JanMarvin in #366
• remove deprecated. fixes #239 by @JanMarvin in #367
• [wb_add_data] unify hyperlink and numeric styling by @JanMarvin in #365
• Data validation list by @JanMarvin in #347
• Update pugi by @JanMarvin in #377
• [styles] avoid sample names. fixes #383 by @JanMarvin in #385
• Gh issue 360 by @JanMarvin in #363
• [add_data_table] improve rowNames. closes #354 by @JanMarvin in #375
• [(un)merge_cells] rm build cell merges by @JanMarvin in #390
• allow having hyperlinks in formulas by @JanMarvin in #388
• Lintr cleanups by @JanMarvin in #392
• [write_xlsx] remove keepNA from man page. closes #373 by @JanMarvin in #382
• [reland] cleanup column width and font size setting by @JanMarvin in #350
• release 0.3.1 by @JanMarvin in #395

Full Changelog: v0.3...v0.3.1

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

v0.2.1

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

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

v0.2.0

Initial public release

What's Changed

• Dataframe by @JanMarvin in #1
• Moves lookup tables by @jmbarbone in #7
• reindents lines by @jmbarbone in #8
• Update rc-cleanup by @jmbarbone in #12
• ReferenceClass cleanup by @jmbarbone in #14
• row_attr to dataframe. closes #16 by @JanMarvin in #17
• 15 clean r grep by @jmbarbone in #21
• 15 clean r length by @jmbarbone in #23
• provide col to df funcions by @JanMarvin in #25
• add new xml functions. closes #24 by @JanMarvin in #26
• [WIP] basic style operations by @JanMarvin in #10
• add covr by @JanMarvin in #29
• 16 roxygen (#19) by @jmbarbone in #28
• Clean loading by @JanMarvin in #30
• R6 classes by @jmbarbone in #47
• 15 clean r by @jmbarbone in #59
• Speedup saving by @JanMarvin in #63
• Quick fixes by @jmbarbone in #69
• use_pipe() by @jmbarbone in #74
• R6 classes - update for wrappers by @jmbarbone in #82
• 87 testthat by @jmbarbone in #100
• [R/writeData2] add hash_id for formats by @JanMarvin in #102
• [R/wbStyle] remove the remaining parts of wbStyle by @JanMarvin in #103
• Fontwidth by @JanMarvin in #109
• [vignettes] add a base to build on by @JanMarvin in #111
• [R/writeFormula] write array formula by @JanMarvin in #114
• [c++/openxlsx2_types] provide simpler types by @JanMarvin in #115
• [R/namedRegion] use getNamedRegion in wb_to_df and delteNamedRegion by @JanMarvin in #117
• explicitly use "sh" for shQuote() by @jmbarbone in #120
• [WIP] read xlsx with Chartsheet. closes #123 by @JanMarvin in #124
• [R/loadWorkbook] Fix reading external links by @JanMarvin in #125
• [R/drawings] Drawings id per sheet. closes #126 by @JanMarvin in #127
• [R/threadedComments] fix loading and saving xlsx with threadedComment. closes #131 by @JanMarvin in #132
• [R/protectWorkbook] add fileSharing to protectWorkbook. closes #130 by @JanMarvin in #133
• [R/loadWorkbook] remove isUnzipped option. closes #121 by @JanMarvin in #122
• [R/tests] initial test of styles by @JanMarvin in #134
• Delete deprecated.R by @JanMarvin in #136
• Update onUnload.R by @JanMarvin in #137
• 84 expect wrapper by @jmbarbone in #99
• 75 remove col wdiths by @jmbarbone in #139
• 75 remove col widths by @jmbarbone in #138
• [R/various] renaming functions pt1 by @JanMarvin in #140
• [R/various] renaming functions. pt2 by @JanMarvin in #143
• 75 modify base font by @jmbarbone in #141
• 75 set header footer by @jmbarbone in #144
• 75 colwidths by @jmbarbone in #112
• 75 add image plot by @jmbarbone in #145
• 75 page setup by @jmbarbone in #146
• 75 filters by @jmbarbone in #147
• 75 get tables by @jmbarbone in #148
• 75 grid lines by @jmbarbone in #149
• [R/various] renaming R functions pt3 by @JanMarvin in #155
• Rename functions pt4 by @JanMarvin in #156
• 75 order by @jmbarbone in #158
• 75 named regions by @jmbarbone in #159
• 75 data validation by @jmbarbone in #160
• 75 sheet visibility by @jmbarbone in #161
• 75 ungroup col row by @jmbarbone in #163
• 75 page break by @jmbarbone in #162
• 75 protect by @jmbarbone in #157
• 75 add data by @jmbarbone in #166
• [DESCRIPTION] Version bump. closes #150 by @JanMarvin in #151

New Contributors

• @JanMarvin made their first contribution in #1
• @jmbarbone made their first contribution in #7

Full Changelog: https://github.com/JanMarvin/openxlsx2/commits/v0.2.0