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