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

Drag copy should ignore disabled cells

1 Answer 142 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Michelle
Top achievements
Rank 1
Michelle asked on 28 Jul 2017, 02:02 AM

When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into.  It is possible to reproduce this with this demo:

https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells

1.  Set the quantity column to disabled.

2. Select B3.

3.  Drag the bottom right corner of B3 to D3.

4.  See error: "Destination range contains disabled cells."

There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.

 

Second problem is that if I now do the following:

5. Click OK to dismiss the error.

6.  Click on the bottom right corner of D3 and drag to B3.

7.  Notice that C3 and D3 are both blanked out, even though C3 is supposed to be disabled.

 

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 31 Jul 2017, 11:12 AM
Hi Michelle,

Concerning the disabled cells error alert, the described behaviour of the Spreadsheet in this case is the intended. If you think that the widget could be improved by altering its current behaviour, I would suggest you to log your idea in our Feedback portal. Based on the support it receives from the community, we will decide on whether to alter the current behaviour of the Spreadsheet.

Concerning the emptied cells issue, I was able to reproduce the problem based on the provided description. This should be considered a bug in the Spreadsheet functionality. Therefore, we have included this bug in our backlog for fixing. Also, I have created a GitHub item, where you could track the bug status.

As a small token of gratitude for the reported bug, I have updated your Telerik points.

Please, note, that at the current moment, I won't be able to provide you a viable workaround for the discussed.

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.
Tags
Spreadsheet
Asked by
Michelle
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or