Copy/Paste of Disabled Cells

2 posts, 0 answers
  1. Jeffrey
    Jeffrey avatar
    14 posts
    Member since:
    Sep 2016

    Posted 07 Sep 2016 Link to this post

    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.





  2. Alex Hajigeorgieva
    Alex Hajigeorgieva avatar
    1041 posts

    Posted 08 Sep 2016 Link to this post

    Hi Jeffrey,

    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:

    As a token of gratitude, I have updated your Telerik points.

    Telerik by Progress
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top