8 Answers, 1 is accepted
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
Hi Veselin,
Sorry - I was led to believe that in Excel this worked differently. Thank you for your help and demonstration!
Marc
Hi Veselin,
Is there a property in the spreadsheet/sheet component to work out if a row is currently hidden?
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
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
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
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
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