- The store file for user configurations is no longer initialized as part of .onload() as this caused issues during package installation. Instead, the configuration is selected during calls to quickXLSX etc through the config argument.
- User configuration files are now stored at path pointed to by tools::R_user_dir. This eliminates the problem that configuration files would be lost on updates
- Deprecated and removed inputHelperSource, inputHelperMetadata, and associated global options. If multiple sources need to be shown in one row, users should create the string via paste() or similar functions.
- Fixed an issue where Excel Worksheets created using datasetsXLSX could become corrupted.
- When defining a second header (either by numeric index or variable name at the beginning of a block) are now properly merged and centered. Last block terminates at the final column of the dataset.
- splitXLSX is now based on datasetsXLSX.
- When including images with datasetsXLSX, users can now specify a title, source, and metadata.
- Users can now attach an additional metadata sheet in datasetsXLSX.
- insert_worksheet allows users to leave the source and metadata arguments at NULL. In these instances, the function no longer includes an empty row.
- Reworked datasetsXLSX to allow a tidyverse-like workflow where titles, sources, metadata, etc. are attached as attributes to objects (see examples).
- As part of this syntax, users can more easily control how sources and metadata are displayed. add_source() and add_metadata() both take prefix and collapse as input.
- insert_hyperlinks now (formally) allows users to point to external files.
- Found an issue where output .xlsx is considered corrupt by Excel when using sheetnames with special characters or spaces. The reason is that sheetnames are used to construct named regions. The resulting illegal names don't cause issues in R, but are detected and removed by Microsoft Excel. To ensure that warnings aren't accidentally shown,
- Fixed a problem where user configurations were not being applied properly
- Fixed a problem with user configurations on Windows systems
- Users can now create, load, and switch between configurations, allowing for more personalized output files.
- grouplines and second header functionality is now available in all functions which generate worksheets.
- base::histogram objects can now be passed to datasetsXLSX
- Prefixes for fields like auftrags_id are now customizable
- Positioning of content in worksheets is now relative to last inserted content
- Fixed undesired behavior where inserting an image by path resulted in the source file being deleted
- implemented new color palettes according to the ZH.CH Design System
- outdated not accessible palettes have been discarded ("zhextralight" and "zhultralight" among others)
- errors in the documentation have been corrected
- fix
datasetXLSX()
which generated broken Links in the index-sheet
- New function
aXLSX()
: exports data from R to a formatted excel file optimized for accessbility, separating contact info and additional metadata (other than the source and title) from the data - Updated
theme_stat()
:theme_stat(map = TRUE)
optimizes the theme for maps - Updated
theme_stat()
: additional function arguments to add or remove major and minor grid lines - Extended documentation, (e.g., added
flush_left()
to the vignette on visualizations, a function that allows one to align the title, subtitle, and caption with the y-axis of a plot) - New function
insert_metadata_sheet()
: adds formatted metadata to an existing .xlsx-workbook
- An R Markdown template
ZH report
for .html-reports is now available. - New function
datasetsXLSX()
: several datasets and/or figures can now be exported from R to a single .xlsx-file. The function creates an overview sheet and separate sheets for each dataset/figure. - Additional function arguments for
quickXLSX()
,splitXLSX()
, anddatasetsXLSX()
have been implemented, for example the author's initials and individual contact details can be specified and the logo of the canton of Zurich can be added. - The column widths in the output of
quickXLSX()
,splitXLSX()
, anddatasetsXLSX()
are set automatically and the first row no longer freezes. - The documentation has been extended.
theme_stat()
has been revised and a couple of theme arguments have been added for increased flexibility (e.g., axis ticks, position of axis labels)