Copy/Paste of Validation Cells

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

    Posted 27 Sep 2016 Link to this post

    Hello KendoUI Team,

    One issue we've encountered that we were hoping you could shed some light on is the behavior that occurs when copy/pasting cells with attached validation, similar to the issue seen with disabled cells here: http://www.telerik.com/forums/copy-paste-of-disabled-cells .

    We have our spreadsheet set so that we define the validation for each of the spreadsheet's columns.  However we've noticed that when a user copy/pastes between cells of different columns, it also copies the validation over which is less than ideal for what we are trying to accomplish.

    You can replicate the behavior I'm seeing on the kendo demo page: https://demos.telerik.com/kendo-ui/spreadsheet/validation

    -> on the demo page, copy cell B7 (christina.toms) into an empty cell like H7 or a cell with existing validation like D7.  You will notice that the red flag as well as the cell's associated data validation is copied as well and will end up overriding any of the other cell's initial validation rules.  Any suggestions so that we can work around this and have it copy only the cell value?

    Best,
    Jeff

  2. Stefan
    Admin
    Stefan avatar
    2880 posts

    Posted 30 Sep 2016 Link to this post

    Hello Jeffrey,

    Apologies for the delayed response.

    I can confirm that this behaviour is expected. The same behaviour can be observed in both MS Excel and Google Spreadsheet. 

    I can suggest submitting a feature request in our UserVoice portal, and based on its popularity we may implement it in a future release. We are closely monitoring the UserVoice portal to help us decide which is more wanted from our customers:

    http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback

    Regards,
    Stefan
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  3. Brian
    Brian avatar
    5 posts
    Member since:
    Feb 2018

    Posted 22 Feb 2018 in reply to Stefan Link to this post

    I am looking to purchase Kendo UI for my organization, but lack of a workaround for this intended functionality might be a deal-breaker.  We were hoping to use Kendo Spreadsheet as an input for an API, but in order to do that, we need confidence that the validation rules will apply.
  4. Brian
    Brian avatar
    5 posts
    Member since:
    Feb 2018

    Posted 22 Feb 2018 in reply to Brian Link to this post

    It looks like there might be some reasonable workarounds (see links below), although I agree that having a context menu would be helpful.

    * http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/18240025-configure-kendo-spreadsheet-to-paste-values-only

    * https://docs.telerik.com/kendo-ui/knowledge-base/spreadsheet-open-kendo-progress-on-paste

  5. Ivan Danchev
    Admin
    Ivan Danchev avatar
    2053 posts

    Posted 26 Feb 2018 Link to this post

    Hello Brian,

    The feature request you linked is among the highest voted Spreadsheet features and will be considered for future implementation. There is room for improvement in this area and we have also logged this in our Github repo as a potential enhancement.

    Regards,
    Ivan Danchev
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top