x
ActiveReportsJS v5.2 is Here! Check out our newest update. ActiveReportsJS v5.2 is Here! ARJS 5.2 is Here!

Issues with "Allow Edits Ranges" on protected Sheets

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

  • 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

  • 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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels