Skip to content

loadWorkbook removing formatting #207

@mdorchuckuva

Description

@mdorchuckuva

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

No one assigned

    Labels

    Style issuebugSomething isn't workingwaiting for answerIf not answered, the issue will be closed in 7 days.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions