-
Notifications
You must be signed in to change notification settings - Fork 78
Closed
Labels
Style issuebugSomething isn't workingSomething isn't workingwaiting for answerIf not answered, the issue will be closed in 7 days.If not answered, the issue will be closed in 7 days.
Description
When using loadWorkbook, formatting that has been applied by a user in excel directly is being stripped.
With the attached excel file in my working directory, running the following code opens a file with cell C4 in black, unbolded text instead of the red, bold text as originally in the file. The formatting remains stripped if I save the wb object back out and then open from file explorer.
library(openxlsx)
wb = loadWorkbook("testopenxlsx.xlsx")
openXL(WB)
System information
Windows 10 Enterprise 10.0.19042
Have tested on R 4.0.3 and R 4.1.0, in both cases the issue persists
Openxlsx version 4.2.4
Office 365 version 2102
testopenxlsx.xlsx
Metadata
Metadata
Assignees
Labels
Style issuebugSomething isn't workingSomething isn't workingwaiting for answerIf not answered, the issue will be closed in 7 days.If not answered, the issue will be closed in 7 days.