Hello KendoUI Team,
My team is currently exploring using Kendo's Spreadsheet capabilities in one of our applications. One issue we've encountered that we were hoping you could shed some light on is the behavior that occurs when copy/pasting disabled cells.
- Set A1 as Disabled. Copy B1 into A1. A1 does not change because it is disabled.
- Set A1 as Disabled. Copy A1 into B1. B1 is now also disabled with A1's value.
Both Scenarios "make sense" from a copy pasting sense, but Scenario 2 is certainly less than ideal for what we are trying to achieve. Our goal is to have a sheet contain certain read-only "ID" columns that are immutable and users cannot change cells from enabled/disabled states. However if a User were to copy one of these disabled read-only cells into another enabled cell, that change becomes permanent as the user cannot change the cell back to enabled nor can they undo their action as the cell is now read-only. Is this currently a bug that will be fixed in the near future or do you have any suggested work-arounds?
The only thing that comes to mind is hard-coding all the columns we want to keep enabled and to enable those ranges again whenever the change event is triggered, but this doesn't feel like an efficient solution once our spreadsheets scale large enough.