This is a migrated thread and some comments may be shown as answers.

Drag values with Hidden Rows

8 Answers 119 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marc
Top achievements
Rank 1
Marc asked on 19 Apr 2017, 07:37 PM

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

8 Answers, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 21 Apr 2017, 12:28 PM
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.
0
Marc
Top achievements
Rank 1
answered on 21 Apr 2017, 12:43 PM

Hi Veselin,

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

Marc

0
Marc
Top achievements
Rank 1
answered on 21 Apr 2017, 12:46 PM

Hi Veselin,

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

Marc

0
Veselin Tsvetanov
Telerik team
answered on 25 Apr 2017, 10:24 AM
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.
0
Marc
Top achievements
Rank 1
answered on 26 Aug 2017, 04:38 PM

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

0
Veselin Tsvetanov
Telerik team
answered on 29 Aug 2017, 01:09 PM
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.
0
Sandeep
Top achievements
Rank 1
answered on 08 Aug 2018, 06:21 AM

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

0
Veselin Tsvetanov
Telerik team
answered on 09 Aug 2018, 03:19 PM
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.
Tags
Spreadsheet
Asked by
Marc
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Marc
Top achievements
Rank 1
Sandeep
Top achievements
Rank 1
Share this question
or