Backdoor to unlock a locked cell

Posted by: mhill on 23 January 2025, 5:39 am EST

  • Posted 23 January 2025, 5:39 am EST - Updated 23 January 2025, 5:44 am EST

    Hi. I am using SpreadJS 14 with the Designer Component.

    I have a protected sheet with protected cells on it. In the Protect Sheet dialog, I have unchecked every option other than being able to select cells.

    When I select a cell, most of the functions I can do on the cell are disabled as we would expect, including the “Cells Dropdowns” menu. However, there is a sub-menu under this and these options are NOT disabled. Thus I can choose the “Calculator” option - which opens the “Format Cells” dialog - which allows me not just format the cell (even though the option was deselected) but worse, it allows the cell to be Unlocked - which for my application in a regulated environment is a disaster since now the user can modify supposedly protected formulae.

    Unfortunately I’m not in a position to upgrade SpreadJS at the mo - we’re about to release a new version of our product - so I’m hoping you can offer me a magic work-around to disable the sub-menu if its parent menu item is disabled.

    Thanks,

    Mark

  • Posted 23 January 2025, 8:06 am EST - Updated 23 January 2025, 8:11 am EST

    Hi Mark,

    I’ve tested the issue with the last release of SpreadJS V14 (version 14.2.5) and was unable to reproduce it on my end.

    To help me investigate further, could you please:

    • Confirm the exact version of SpreadJS you are currently using.

    • If possible, provide a sample spreadsheet or code snippet that demonstrates the issue.

    • If you can, modify the attached sample spreadsheet to replicate the problem you’re encountering.

    If upgrading to V14.2.5 resolves the issue for you, I recommend doing so. You won’t require additional License Key for upgrading from any V14 version to V14.2.5.

    You can download V14.2.5 from the following link: http://cdn.grapecity.com/spreadjs/14.2.5/Files/SpreadJS.Release.14.2.5.zip

    Upgrading to the latest version is generally recommended as it includes performance enhancements, bug fixes, new features.

    Please note that bug fixes are typically only applied to the latest version of SpreadJS. Also, I was unable to replicate the issue with the latest version.

    Regards,

    Ankit

    purejs.zip

  • Posted 23 January 2025, 8:31 am EST - Updated 23 January 2025, 8:36 am EST

    Hi. Thanks for getting back. It’s version 14.2.5 of both SpreadJS and the Designer Component (toolbar) that I’m running.

    I think I can see where the disconnect it. The problem only seems to appear when the toolbar is collapsed such that the “Cells” menu group is in a cascading menu already under the “…” button. Then the sub menu under that is still accessible which it probably shouldn’t be.

    Hope that helps.

    Mark

  • Posted 24 January 2025, 6:00 am EST

    Hi,

    Apologies for the inconvenience caused.

    We too can replicate the issue you mentioned on our end. However, the issue has been resolved in SpreadJS Version 16.2.0. Therefore, we recommend you upgrade to Version 16.2.0 or higher to resolve this issue.

    In addition, there is no viable workaround to solve this issue in Version 14.2.5.

    If you choose to upgrade to the higher version of SpreadJS, we recommend you upgrade to the latest version 18.0.2 (https://developer.mescius.com/spreadjs/download) which comes with a lot of new features and various improvements from the previous builds. To get any license-related information on the latest version, you can connect with our sales team at us.sales@mescius.com

    Please feel free to reach out if you encounter any further issues or require additional guidance.

    Best Regards,

    Ankit

Need extra support?

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

Learn More

Forum Channels