Open msgoussi opened 5 years ago
ungroup worksheets
grouped first two worksheets
(please attach an example xlsx file if possible)
wb <- createWorkbook() addWorksheet(wb, "Sheet1") addWorksheet(wb, "Sheet2") worksheetOrder(wb) <- c(2, 1) saveWorkbook(wb, "x.xlsx", overwrite = TRUE)
When I reorder the worksheets, then you open the workbook, the first two worksheets are grouped together.
Expected Behavior
ungroup worksheets
Actual Behavior
grouped first two worksheets
Steps to Reproduce the Problem
(please attach an example xlsx file if possible)
wb <- createWorkbook() addWorksheet(wb, "Sheet1") addWorksheet(wb, "Sheet2") worksheetOrder(wb) <- c(2, 1) saveWorkbook(wb, "x.xlsx", overwrite = TRUE)
sessionInfo()
When I reorder the worksheets, then you open the workbook, the first two worksheets are grouped together.