Error when accessing default styles about xltabr HOT 3 CLOSED

Thanks - ok we'll look into this properly, but for the moment a temporary fix might be to use the following code:

xltabr::set_cell_format_path("style_to_excel_number_format.csv")
xltabr::set_num_format_path("number_format_defaults.csv")
xltabr::set_style_path("styles.xlsx")

Where you download the corresponding files from here and store them in your project directory (or anywhere else, if you want to give the full path to them)

from xltabr.

Thanks RobinL!
This is universal workaround for the problem:

xltabr_path <- system.file("extdata", package="xltabr")
xltabr::set_style_path(file.path(xltabr_path,"styles.xlsx"))
xltabr::set_cell_format_path(file.path(xltabr_path,"style_to_excel_number_format.csv"))
xltabr::set_num_format_path(file.path(xltabr_path,"number_format_defaults.csv"))

from xltabr.

I think I figured out why this is breaking...

In the zzz.R the xltabr_default_options list is created outside of the scope of the .onload function. Because of this it's value at the time of being compiled is stored in xltabr.rdb file.

When the package is installed from CRAN rather than github xltabr_default_options is loaded from xltabr.rdb instead of being rerun in the zzz.R file. Hence you get file paths pointing to someone else's machine (whoever compiles the package).

Moving xltabr_default_options into the scope of .onload should (hopefully fix this).

from xltabr.