qol 1.1.1 - DEVELOPMENT
New functions
multi_join(): Join two or more data frames together in
one operation. (30.11.2025)libname(): Check if path exists and retrieve files.
(04.12.2025)
Fixed
any_table(): Fixed multi layered column header labels
where not applied correct. (28.11.2025)any_table(): Fixed incorrect column order when using
order_by “values” while variable names have underscores.
(04.12.2025)any_table(): Using pre summed data now also works, if
variable names carry underscores. (04.12.2025)
- Added article comparing this package with SAS even further.
(02.12.2025)
qol 1.1.0 - CRAN release
on 20.11.2025
New functions
build_master(): Reads a given folder structure, which
contains scripts, and builds a master script as a markdown file.
(18.10.2025)build_rstheme(): Build a complete theme file, which can
be used to change the visual appearance of RStudio. (23.10.2025)combine_into_workbook(): Combines any number of tables
created with any_table() into one workbook and styles them
according to their meta information. (26.10.2025)replace_except(): Replaces a provided pattern with
another, while protecting exceptions. (29.10.2025)mark_case(): Marks first or last cases within a
provided group. (31.10.2025)retain_value(): Retains the first value for all cases
of the same group. (31.10.2025)retain_sum(): Retains the summarised values for all
cases of the same group. (31.10.2025)
New functionality
interval_format(): Implemented keywords “low”and “high”
with which one can define pseudo low or high values, if one doesn’t
know, what the minimum or maximum value of a variable is.
(20.10.2025)discrete_format(): Implemented keyword “other” with
which one can catch any other value not covered by the explicitly
specified values. (27.10.2025)any_table(): Now returns styling meta information as a
third list element. This meta information can be used by
combine_into_workbook(). (26.10.2025)any_table(): Now supports underscores in variable
names. (29.10.2025)any_table(): Added new column ordering possibilities by
“columns” or “values_stats”. (03.11.2025)any_table(): Can now output tables even though no
column variables are specified. (05.11.2025)
Fixed
- In
any_table() the header and table row heights as well
as the column widths set by the style option where 1 row/column to
short. (14.10.2025)
- In
any_table() the row heights didn’t catch the whole
table. (14.10.2025)
any_table() ran into an error, if a variable was
provided as pct_group, which was not part of the row and column
variables. (14.10.2025)- Fixed typos in frequencies examples, where it said “frequency”
instead of “frequencies”. (18.10.2025)
- In Excel outputs the number stored as text error is now ignored.
(19.10.2025, thanks to @JanMarvin)
- Fixed table length captured with too many rows. (19.10.2025)
any_table(): Fixed order_by stats not working as
intended in some cases. (03.11.2025)any_table(): Fixed table rows not ordered correctly in
some cases. (03.11.2025)any_table(): Depending on variable constellation and
ordering of the column header it could happen, that the header wasn’t
merged correct in the Excel workbook. This was fixed. (04.11.2025)any_table(): Doesn’t run into an error, if the table
only consists of one value column. (05.11.2025)
Changed functionality
- In
excel_output_style() the options
column_widths and row_heights now start at the
first column/row instead of the beginning of the table.
(19.10.2025)
- In
summarise_plus(), if summarised values should be
merged back, the variables TYPE, TYPE_NR and DEPTHS are now not merged
back anymore. (31.10.2025)
Additionally
- Added missing functions
export_with_style() and
get_excel_range() to the ?qol overview page.
(14.10.2025)
- Added information to the startup message to use ?qol to get an
overview. (14.10.2025)
- Now using openxlsx2 helper to convert row and column numbers to
Excel ranges. (19.10.2025, thanks to @JanMarvin)
- All Excel tables now have named ranges for the table and the values.
(19.10.2025, thanks to @JanMarvin)
- Added an example to the README showing how to save an Excel workbook
to the filesystem. (19.10.2025)
- Used lintr package for some code cleanup. (20.10.2025, thanks to
@JanMarvin for the
advise)
- Added custom theme section to the README. (23.10.2025)
- Added message, if a format is applied to a factor variable.
(27.10.2025)
- Excel workbooks will now only be opened in interactive sessions.
(29.10.2025, thanks to @JanMarvin)
- Corrected typos in snippets. (03.11.2025)
- Added article comparing this package with SAS. (14.10.2025)
- Changed GitHub Page style. (14.10.2025)
- Added example themes with corresponding code. (23.10.2025)
qol 1.0.2 - CRAN release
on 14.10.2025
DESCRIPTION file
- Fixed brackets in DESCRIPTION so that auto linking works.
- Added another URL.
Fixed
- There could be an error in
summarise_plus(),
any_table() and args_to_char(), if there where
to many variables provided.
summarise_plus() ran into an error, if a value label
from a format contained a “.”.any_table() could lead to wrong results if the
pre_summed option was used and a variable was part of multiple
combinations in the summarised data.
Changed functionality
- In
summarise_plus(), when types are defined, the total
row is now removed if not explicitly defined as type.
- In
summarise_plus(), when the nesting option “deepest”
is used, the variables TYPE, TYPE_NR and DEPTHS are now also
generated.
Unit tests
- Adjusted tests according to changed functionalities
Additionally
- Added openxlsx2 as import in the qol main help file
- Corrected a typo in a warning message in
any_table()
concerning variable order.
qol 1.0.1
- Added references to specific SAS functions in the description field
of the Description file where they are mentioned.
- Removed specific seed in R/dummy_data.R
- Fixed a bug in dummy_data where it could happen that not enough
observations where generated.
qol 1.0.0