Collapsed rows / columns are lost

[kainhofer]

Expected Behavior

The attached file contains some grouped and collapsed rows and columns. When loading and saving this file with openxlsx these grouped and collapsed rows and columns should be retained.
2018-05-07_openxlsx_grouped_rows_cols_lost.xlsx

Actual Behavior

All row and column grouping is lost. Collapsed columns are converted to hidden columns, collapsed rows are visible.

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

1. 2018-05-07_openxlsx_grouped_rows_cols_lost.xlsx

2. Load the excel file and save it to see that row/col groupings are lost:

wb = loadWorkbook("2018-05-07_openxlsx_grouped_rows_cols_lost.xlsx")
saveWorkbook(wb, "2018-05-07_openxlsx_grouped_rows_cols_lost_OUT.xlsx", overwrite = TRUE)

sessionInfo()

• Version of openxlsx: Current git master
• Version of R: R version 3.4.3 (2017-11-30

[Jannickz]

I am also experiencing the same problem : (
All the grouping format are lost : (