Drag values with Hidden Rows

9 posts, 0 answers
  1. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 19 Apr 2017 Link to this post

    When dragging a cell value downwards, if a row is hidden, the value inside that row is also changed. Is there any way to disable this so that it acts more like Excel (Which ignores hidden rows when dragging values)

    Thanks
    Marc

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 21 Apr 2017 Link to this post

    Hello Marc,

    I am afraid, that the required change of the default behaviour of the Spreadsheet on dragging values could not be achieved. Additionally, here you will find a short video of running MS Excel, which also assigns the dragged values to hidden rows (as the Kendo Spreadsheet does).

    Regards,
    Veselin Tsvetanov
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 21 Apr 2017 in reply to Veselin Tsvetanov Link to this post

    Hi Veselin,

    Sorry - I was led to believe that in Excel this worked differently. Thank you for your help and demonstration!

    Marc

  4. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 21 Apr 2017 in reply to Veselin Tsvetanov Link to this post

    Hi Veselin,

    Is there a property in the spreadsheet/sheet component to work out if a row is currently hidden?

    Marc

  5. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 25 Apr 2017 Link to this post

    Hi Marc,

    The Spreadsheet widget does not expose configuration property, that would allow you to alter the discussed behaviour of dragging values over hidden rows / columns.

    Regards,
    Veselin Tsvetanov
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  6. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 26 Aug 2017 Link to this post

    Hi Veselin, 

    How do I raise a request for the spreadsheet to expose the "hidden" status of a field. Something like activeSheet().range("A1:A1").hidden() which returns true or false.

    I think this would be very helpful. You are correct, the spreadsheet mimics the behaviour of Excel, but Excel does have a way to copy only to visible rows.

    Thanks,

    Marc

  7. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 29 Aug 2017 Link to this post

    Hi Marc,

    You could log your request in our Feedback portal. Based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  8. Sandeep
    Sandeep avatar
    13 posts
    Member since:
    Aug 2013

    Posted 08 Aug 2018 Link to this post

    Hi,

    Can we disable the drag copy horizontally? Drag copy vertically downwards is fine but we want to restrict user to drag horizontally. Dragging horizontally is causing issues since the columns would be of different type and it will involve too much of validations applied. Instead if we could disable horizontal drag that would be more helpful and quick.

    Thanks,

    Sandeep

  9. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 09 Aug 2018 Link to this post

    Hello Sandeep,

    Disabling only the horizontal drag-copy of the Spreadsheet cells would not be possible. Nevertheless, I would suggest you to review the workaround from the following GitHub item. If that fits into your scenario, it will prevent the possibility of copying anything different from the value to the other cells.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top