Posted 20 February 2025, 12:42 pm EST
Hello SpreadJS Community,
I’m encountering an issue with importing sheet and cell protection settings after exporting a Google Sheet into SpreadJS. When I check the import options, I see that the sheet protection settings do not come through correctly.
Here’s what I’ve observed:
- When the sheet is protected in Google Sheets,
returnssheet.options.isProtected
after the import.false
- Additionally,
is an empty object, even though the sheet and cell protections are set in Google Sheets.sheet.options.protectionOptions
I’ve reviewed the documentation and tried the import process in the SpreadJS Designer, but I’m seeing the same behavior.
Can anyone shed light on whether there have been any changes to the handling of sheet and cell protection with the new import system in SpreadJS?
Thank you in advance for your help!