deschen1

`rows_*()` functions should be able to use different joins keys in `x` and `y`

2

Currently, rows_* functions like `rows_update` require an unnamed character string for the `by` parameter, which makes it impossible to dynamically pass id column names. *_join functions, however, allow for a...

How to prevent "NA" strings when saving workbooks

11

Disclaimer: I yet have to figure out how to make a reproducible example (because as of now I can't, well, reproduce with a small toy example the issue in one...

Note, the below does not return an error when the WB is created through `createWorkbook`, but in the follwoing way: 1. Open Excel and add some data to it manually....

deleteData doesn't delete styles even though help function says so

1

Using `?deleteData` says "Delete contents **and styling** from a cell." However, this doesn't seem to be the case: ``` wb

``` df

feature request: allow "format painter" functionality

3

I often have use cases where I write data to an existing workbook/worksheet in new columns (e.g. assume a new month of data when I already have Jan-Aug or sth....

Reading in file with formula shows values as 0 (unless the original file is opened in Excel and saved)

8

I have an Excel file thta contains formulas. This file comes from a website. If I download the file and try to read in into R, it leads to a...

xlsx file created with openxlsx can't be opened in SPSS

26

I saved some R data as an xlsx file with openxlsx in R. However, when trying to open this file in SPSS I get an error:  When exporting the...

Setting value labels for several variables at once (preferably using dplyr::across)

5

Inspired by this question (https://stackoverflow.com/questions/73818355/how-to-recode-values-in-haven-labelled-vectors-in-r) I'm wondering, how one could set value labels for several variables at once. Apparently, dplyr::across doesn't work, but since labelled vectors are kind of a...

When using one of the match functions (i.e. `prefix_match` in my case) it returns weird character symbols for many "foreign" characters, e.g. German ä, ö, ü or ß or basically...