Drag values with Hidden Rows

7 posts, 0 answers
  1. Marc
    Marc avatar
    161 posts
    Member since:
    Sep 2016

    Posted 19 Apr 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
    561 posts

    Posted 21 Apr 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
    161 posts
    Member since:
    Sep 2016

    Posted 21 Apr 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
    161 posts
    Member since:
    Sep 2016

    Posted 21 Apr 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
    561 posts

    Posted 25 Apr 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
    161 posts
    Member since:
    Sep 2016

    Posted 26 Aug 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
    561 posts

    Posted 29 Aug 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.
Back to Top