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.
Scenario 1:
- Set A1 as Disabled. Copy B1 into A1. A1 does not change because it is disabled.
Scenario 2:
- 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.
Best,
Jeff
1 Answer, 1 is accepted
Thank you for bringing the behaviour described in the second scenario to our attention.
I have logged this as an issue of the Kendo UI Spreadsheet and assigned a developer to investigate and fix it. You can follow its progress at:
https://github.com/telerik/kendo-ui-core/issues/2139
As a token of gratitude, I have updated your Telerik points.
Regards,
Alex
Telerik by Progress