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

v1.2

Release 1.2 brings the usual bug fixes and some improvements to pivot tables and copy cells.

Since its first implementation, wb_add_pivot_table() has undergone a number of unfortunately still largely undocumented changes. It is now possible to select outline and compact to change the appearance of the pivot table and to select subsets of data to be included with choose. This also works with slicers and is a nice feature for pre-selecting pivot tables. Note, however, that this does not work with pivot tables loaded via wb_load() and that support for modifying these loaded pivot tables is not currently planned.

Another function that has been reworked a little is wb_copy_cells(). This is another of the many sparsely documented functions, but actually one that has some nice features. For example, similar to copying cells in spreadsheet programs, it is possible to copy the cell as a value or as is. It is also possible to copy cells as references and it is also possible to transpose what is being copied.

Some long overlooked escaping issue with class(df$x) <- "formula" was fixed. Which strangely didn't bother anybody for several months, but once the first report came in and was fixed, various duplicates of this issue appeared. Thanks to @olivroy options for min and max width were restored. And since this release it is also possible to use openxlsx2 with webr (see #849 for details).

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.2 is the 14th 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

• [named region] fix local_sheet counting. fixes #829 by @JanMarvin in #830
• [pivot tables] add show_data_as and compact/outline by @JanMarvin in #833
• [write_data] escape all formulas in write_data by @JanMarvin in #834
• [write_data] make formula encoding more general by @JanMarvin in #835
• [pivot tables] use standardize_case_names() and as_xml_attr() by @JanMarvin in #836
• [drawings] improve relationship id selection by @JanMarvin in #838
• [clone] column and row styles by @JanMarvin in #839
• [pt] add choose param by @JanMarvin in #840
• [pt] Improve item selection and fix slicers names with whitespace by @JanMarvin in #842
• [numfmt] fix forward slash escaping. closes #847 by @JanMarvin in #848
• [copy_cells] copy hyperlinks and fix handling of transposed cells. fixes #846 by @JanMarvin in #850
• [copy cells] fill empty cells by @JanMarvin in #851
• Document options by @olivroy in #853
• [copy_cells] pass ... to wb_add_data(). close #852 by @JanMarvin in #855
• [tests] provide testsetup function and use it. by @JanMarvin in #857
• [pt] cleanup choose by @JanMarvin in #858
• [xlsb] fix formats. closes #860 by @JanMarvin in #861
• Release 1.2 by @JanMarvin in #862

Full Changelog: v1.1...v1.2

v1.1

Release 1.1 is a release with many new features to try, in addition to the usual bug fixes and improvements to our existing code. Grouping columns is now a bit more user-friendly, we've updated the pugixml library, and our tests can be run in parallel again. We've added new functions for getting and setting file properties that improve and extend the existing ways to set them, a feature requested and worked on by @olivroy.

In addition, some long-requested features have been added. Reading xlsb files, cloning across workbooks, and adding slicers. Please be aware that all of these features are still somewhat experimental, have known limitations, and probably contain a few bugs. Therefore, if you try this, you should make more backups than usual and test the features more thoroughly than usual.

This release is the first to include our own xlsb file reader. With this it should be possible to load xlsb files similar to xlsx/xlsm files. Please be aware that this file parser is still limited (and probably will remain this way) and should only be considered as a sort of last resort when no other tool is available to convert the binary openxml file into a simple xlsx file. If you try this, please have a look at the NEWS file first.
Another long requested feature has been added in the form of cloning worksheets across workbooks. This extends the wb_clone_worksheet() function with a new from argument that allows copying worksheets across workbooks.
Last but not least, support for pivot tables has been further improved. It is now possible to sort by elements and it is possible to add a slicer to a pivot table after adding it.

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.1 is the 13th 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

• Join named regions docs by @olivroy in #777
• Add more details for waiver functions + add xrefs in styledocs. by @olivroy in #778
• [wb_group_cols()] automate column creation by @JanMarvin in #781
• [wb_add_drawing] read and add "mc:alternateContent" by @JanMarvin in #783
• [WIP] initial xlsb attempts by @JanMarvin in #688
• [xlsb] more fixes for formula heavy workbooks by @JanMarvin in #787
• [xlsb] avoid hard to spot crash with unhandled array formulas by @JanMarvin in #788
• [remove_worksheet] update activeTab. closes #792 by @JanMarvin in #793
• [pivot_table] add sort_item param option by @JanMarvin in #795
• [properties] Rework setter/getter functions for workbook properties by @JanMarvin in #782
• improve assert_class(). closes #770 by @JanMarvin in #772
• [properties] get/set keywords and comments by @JanMarvin in #798
• Review workbook properties + add company and manager by @olivroy in #799
• [vignette] Provide a why openxlsx2 section. closes #800 by @JanMarvin in #801
• [update_table] check if autofilter is available. closes #802 by @JanMarvin in #804
• [workbook] move default style initialization to workbook. fixes #803 by @JanMarvin in #805
• [update_table] guard against unknown xml nodes by @JanMarvin in #806
• [pugixml] update to release 1.14 by @JanMarvin in #808
• [tests] improve testfile_path() to download files by @JanMarvin in #785
• [wb_load] minimal workbook by @JanMarvin in #810
• Tweaks to docs by @olivroy in #812
• comment unused variable by @JanMarvin in #813
• [clone_worksheet] copy worksheet across workbooks by @JanMarvin in #622
• [wbWorkbook] separate sheets in print() with comma. closes #46 by @JanMarvin in #814
• [wbWorkbook] enforce datetime_created. closes #685 by @JanMarvin in #815
• [tests] cleanup options by @JanMarvin in #816
• update NEWS and wb_load man page by @JanMarvin in #817
• Skip testfile_path() tests on cran. by @JanMarvin in #818
• [drawing] do not overwrite worksheet relationships by @JanMarvin in #821
• [styles] fix typo by @JanMarvin in #825
• [clone] fix cloning from a workbook with included media by @JanMarvin in #826
• [WIP] add wb_add_slicers by @JanMarvin in #822
• Release 1.1 by @JanMarvin in #823

Full Changelog: v1.0...v1.1

v1.0

Release 1.0 is finally here. While it's just a number in the grand scheme of things, the goal is that we've achieved a semi-stable API. This means that the public API will not change in the foreseeable future, unless pressing reasons force us to do so. That being said, a lot has been done and worked on in the last few weeks.

Thanks to the work of @olivroy, the long-neglected documentation in examples and vignettes has been overhauled and now looks better than ever. Examples have been added where they were missing and cleaned up where they were outdated. The entire pkgdown page has been reworked. Building on the consistent arguments work we did in the previous version, this really makes the version shine.

A lot of time went into various bug fixes, cleanups and minor improvements here and there. Among the few fixes, there is one that requires a detailed explanation. It was discovered that we were not handling the 1904 date format correctly. As a result, our dates were always 4 years off for this date format, which was mainly used by Excel on the Mac. That's a little shameful that it took so long and came up rather by accident. Hopefully it's a sign that this format is rarely used. However, it's certainly a reminder that no code is error-free, not even the most scrutinized in the world, so it's always wise to remain vigilant and question unusual output. In addition, a number of fixes and features were developed based on user requests and needs. If you find an error, please let us know!

The release 1.0 is the twelfth 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

• [get_sheet_names] add escape argument. closes #252 by @JanMarvin in #724
• [vignette] Fix dataTable formula by @JanMarvin in #727
• Sharp hex by @JanMarvin in #728
• fixes for wb_load() from #688 by @JanMarvin in #732
• Fix threaded comment id. closes #731 by @JanMarvin in #734
• Flexible merge by @JanMarvin in #733
• Various wb$sheet_names related fixes and cleanups in wb_functions.R by @JanMarvin in #735
• [wb_to_df] fix date1904 conversion by @JanMarvin in #737
• guard against empty cc cases. closes #739 by @JanMarvin in #740
• [wb_load] add path to object on. closes #741 by @JanMarvin in #742
• fix wb_set_header_footer(). closes #747 by @JanMarvin in #748
• restore and improve tab_color by @JanMarvin in #750
• copy header/footer code by @JanMarvin in #751
• Review documentation and examples by @olivroy in #749
• provide basename2 for to long strings by @JanMarvin in #755
• [fmt_txt] escape xml by @JanMarvin in #757
• Export wb_comment() by @olivroy in #758
• [docs] update man page for create_hyperlink() by @JanMarvin in #759
• Remove wbChartSheet from exports by @olivroy in #760
• Vignette names by @olivroy in #762
• Make wb_get_named_regions() a wrapper. by @olivroy in #764
• Pkgdown family by @olivroy in #763
• Review threaded comment docs by @olivroy in #765
• internal: use wb_comment() in wb_add_thread + deprecations guide by @olivroy in #766
• Final reordering in pkgdown by @olivroy in #768
• Remove duplicated docs + remove internal functions docs. by @olivroy in #769
• Release 1.0 by @JanMarvin in #743

Full Changelog: v0.8...v1.0

v0.8

Release 0.8 might be the last milestone on the way to 1.0 and brings a lot of changes and cleanups to the API and exported functions. Please note: If no drastic issues show up in bug reports in the coming days, the current API will become the 1.0 API, which will be semi-stable (i.e. if no changes are required, it will not change in the foreseeable future). The current changes were needed to streamline the API and provide a pleasant user experience.

Finally, the long overdue cleanup of arguments from camel case to snake case has been addressed. Hopefully this has been archived in a way that is backwards compatible and warnings and broken code should be limited. Basically, a function foo(camelCase=bar) is now foo(snake_case=bar), although for now it should accept both variants. The solution to this problem was to pass the arguments for camelCase to ... and convert them under the hood to variables for snake case. There are obviously some limitations to this approach, but we felt it was too close to a 1.0 release to break the API in such a drastic way.

Another addition is the introduction of wb_dims(), a helper function introduced for interacting with the dims argument of openxlsx2 workbook functions. Many of the previous row/rows, col/cols and xy variants are deprecated, and users are recommended to use dims either the simple A1 notation for cells with the existing helper functions like int2col() or the feature-rich wb_dims(). Thanks to the work of @olivroy, who improved the function in various commits, there is a detailed man page for this function with many examples of how to use it.

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 0.8 is the eleventh 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

• Rename convertToExcelDate by @olivroy in #672
• Rename convertToExcelDate and cleanups for deprecated functions by @JanMarvin in #673
• [data_table] Do not break on zero row data frame input. fixes #676 by @JanMarvin in #677
• [experimental] standardize function arguments by @JanMarvin in #678
• Update vignettes to snake_case, and other code quality updates by @olivroy in #682
• R/write.R cleanup by @olivroy in #683
• warn on unused arguments in standardize_case_names() by @JanMarvin in #690
• provide wb_dims() by @JanMarvin in #691
• [WIP] handling of threaded comments by @JanMarvin in #674
• Gh issue 681 pt1 by @JanMarvin in #693
• Stop advertising functions that don't fit in openxlsx2 API by @olivroy in #694
• Update vignettes to latest recommended API. by @olivroy in #698
• Misc by @JanMarvin in #701
• update .lintr by @JanMarvin in #700
• force datetime creation. closes #685 by @JanMarvin in #686
• clean up by @JanMarvin in #704
• validate_new_sheet now tries to fix the sheet name. closes #687 by @JanMarvin in #705
• Review wb_dims() by @olivroy in #702
• Fix deprecation code for start_col/start_row. closes #706 by @JanMarvin in #707
• Gh issue 681 pt2 by @JanMarvin in #708
• [write_xlsx] supply sheetName for single argument. closes #711 by @JanMarvin in #712
• unique is not enough for pivot tables. closes #713 by @JanMarvin in #714
• return all formulas. previously dates would interfere by @JanMarvin in #715
• Improve wbWorkbook documentation. by @olivroy in #718
• Rename workbook_grouping to wb_grouping by @olivroy in #719
• Review examples by @olivroy in #720
• silence warnings in create_dxfs_style() by @JanMarvin in #721
• Documentation improvements by @olivroy in #717
• Save path by @JanMarvin in #723
• wb_grid_lines -> wb_set_grid_lines by @JanMarvin in #725
• Release 0.8 by @JanMarvin in #709

New Contributors

• @olivroy made their first contribution in #672

Full Changelog: v0.7.1...v0.8

v0.7.1

Release 0.7.1 is another milestone on the way to 1.0, bringing a few style improvements and the usual bug fixes.

The release introduces wb_add_named_style(), a new function to create named styles like Note or Title from openxlsx2. This function is accompanied by the introduction of workbook themes. The fmt_txt() function, introduced in release 0.7, has been improved to provide a class with print() and + methods. This should make it easier for the user to create and design workbooks.

Further optimizations have been made to the creation of conditional formatting. A new function wb_add_dxfs_style() has been introduced and color gradients can now be used to create conditional formatting styles. Objects with a label attribute are now treated according to the label, new (experimental) changes have been made to the creation of pivot table number formats and ordering.

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 0.7.1 is the tenth 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

• [wbWorkbook] Themes by @JanMarvin in #630
• [wb_to_df] Fix cols by @JanMarvin in #631
• Download files in setup.R. closes #345 by @JanMarvin in #632
• download_testfiles() for coverage by @JanMarvin in #633
• try 100 times by @JanMarvin in #634
• [wbStyles] Add as_xml_attr by @JanMarvin in #637
• [fmt_txt] add class and methods by @JanMarvin in #636
• add to_string() to convert variables with labels attribute by @JanMarvin in #639
• [styles] Create named styles. closes #274 by @JanMarvin in #628
• attempt to write utf8 on non utf8 os by @JanMarvin in #641
• [cf] add dims argument by @JanMarvin in #645
• [wb_load; cf] fix conditional formatting range. closes #646 by @JanMarvin in #647
• add gradientFill option to `create_dxfs_style(). closes #648 by @JanMarvin in #651
• escape if pivot cacheField is string. closes #649 by @JanMarvin in #650
• export internal dims helpers.closes #652 by @JanMarvin in #653
• add dims to wb_add_conditional_formatting(). closes #654 by @JanMarvin in #655
• [wb_set_sheet_names] add details text. closes #656 by @JanMarvin in #657
• [add_clone_worksheet] fix comments. closes #658 by @JanMarvin in #659
• fix named regions by @JanMarvin in #660
• restore coverage for styles_mgr by @JanMarvin in #661
• [protect] allow logical operators in protect worksheet by @JanMarvin in #662
• [styles] add wb_add_dxfs_style() wrapper by @JanMarvin in #665
• attempt to escape conditional formatting by @JanMarvin in #666
• [experimental] Pivot table improvements by @JanMarvin in #669
• [experimental] cleanup pivot sorting by @JanMarvin in #670
• Release 0.7.1 by @JanMarvin in #671

Full Changelog: v0.7...v0.7.1