Copy/Paste of Disabled Cells

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

    Posted 07 Sep 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.

     

    Best,

    Jeff

     

        
        
  2. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    115 posts

    Posted 08 Sep 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:

    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
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
  3. Kendo UI is VS 2017 Ready
Back to Top