Issues with "Allow Edits Ranges" on protected Sheets

Issues with "Allow Edits Ranges" on protected Sheets

Posted by: dansull on 12 March 2025, 11:22 am EST

• 

  dansull

  • Post Options:
  • Link
    Copy

  Posted 12 March 2025, 11:22 am EST

  Hi,

  We ran into a difference in behavior between Excel (2023) and SpreadJS. In the attached zip, the sheet has protection on it. However, the yellow highlighted cells have “Allow Edit Ranges” enabled, allowing the user to edit them from Excel. SpreadJS does not seem to know about this, and treats them as fully protected.

  Is this something that could be supported?

  Thanks,
  
  ~Dan

  locking test.zip

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 13 March 2025, 1:45 am EST

  Hi,

  We can reproduce the mentioned behavior on our end. However, this is currently not supported and is already in our product backlog. The internal tracking ID is SJS-9014. I will update you as soon as there are any updates.

  Regards,
  
  Priyam