error in createNamedRegion

[tdp-datsci]

R version: 4.4.0
Openxlsx version: 4.2.7.1
Platform: Windows

Trying to create a named region that where the cells are cross hatched but have data (see file) causes an error when saving the workbook. If the cells are not cross hatched (no fill or color), the regions are saved. I know that typically cells that are cross hatched indicate that no data should not be in the cell. The named regions are created and saved if the cells are not filled or are filled with a color.

I found this in using some client data (unable to provide); hence the test file.

A second issue that I found that might be related is that data must be in the cells in order for the regions to be created. If the cells are empty, the file saves the file but Excel indicates that there is an error. After fixing the error, Excel indicates that the named regions were removed. I am not certain if this is a related error or not, but thought I would bring it up.

testfile.xlsx

[JanMarvin]

Thanks for the report @tdp-datsci , but it’s unlikely to get fixed here. You can have a look if this works with openxlsx2 and otherwise open an issue over there.