Posted 18 September 2025, 3:47 am EST - Updated 18 September 2025, 3:49 am EST
Hi Team,
Try importing the attached .sjs file in the SpreadJS demo site (https://developer.mescius.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs), and then export it as .xlsx from there.
When I open the exported file in Microsoft Excel, after clicking Enable Editing, many options in the Data ribbon are greyed out. However, if I switch to a different sheet (using the sheet tabs at the bottom) and then return to the original sheet, all the ribbon options become enabled, and I can open/close grouped rows as expected.
Environment details:
- Excel version: Microsoft® Excel® 2021 MSO (Version 2508 Build 16.0.19127.20192) 64-bit
- SpreadJS version: 17.1.10
Is this a known issue with the export metadata? Do I need to set any specific options (e.g., active sheet or active cell) to prevent this behavior?
Thanks,
Kavan