In kendo spreadsheet, if you
1. select 2 un-adjacent cells,
2. ctrl-x to cut, and selected cell contents are cleared
(in the console, error "Unsupported for multiple ranges" is thrown)
3. but when you paste with ctrl + v, the content is lost.
If you do the same thing for copy (ctrl + c), an dialog pop-up with message "That action cannot be performed on multiple selection". I think this should also happen for cut operation.
7 Answers, 1 is accepted
Are there any additional steps that need to be followed in order for the issue to be reproduced? Here's a screencast showing:
1. Selection of non-adjacent cells by holding down Ctrl and left-mouse clicking them
2. Clearing the cells content by pressing Ctrl + X.
The dojo example used in the screencast.
At our end no js exception is thrown when following these steps, so let us know in case there is something we are missing.
Have you tried to paste the content? The important part isn't about clearing the cell; it's about the cut contents are lost. I mean this is the cut function, not clear. Right? The error message part , you won't find it in dojo. I think it's suppressed. I was able to see it through chrome debugger running non-minified kendo codes.
Thank you for the additional information provided. Based on that I was able to reproduce the issue described.
The observed should be considered a bug in the Spreadsheet functionality. Therefore, we have included this in our backlog. Here you could find the GitHub item, where you could track the bug status.
As a small token of gratitude for reporting this issue to us, I have updated your Telerik points.
Note, that at the moment, I won't be able to offer you a viable workaround for the discussed. Therefore, I would suggest you to track the GitHub issue and update your Kendo version as soon as the fix has been released.
I'd like to just follow up on the status of this bug. I notice the github issue has been closed. Does this mean this bug has been fixed? I tried it again on your demo, but still find the same bug.
Also, we are getting feedback from our user encountering similar problem when deleting un-adjacent cells. Our user expresses interest to delete a group of values separated by disabled cell (see attached image, the gray cells are disabled). If he select the whole area and hit delete, nothing happens because the disabled cells, if he select un-adjacent cells, the following bug occurs.
Steps to reproduce:
1. Setup a spreadsheet using datasource
2. select un-adjacent cells, A1, A3
3. hit delete
Expected: Cell values are deleted
Actual: Cell values look like they are deleted, however, on enter value in A4, the values in A1 and A3 come back again.
This delete bug cannot be reproduced on the simple demo on your website - I'm not sure why no error is logged in console for the demo. However, in our instance, the following error is reported: "Unsupported for multiple ranges". I can trace the problem back into the values function throwing error if ref is instanceof UnionRef. The problem for us is that our spreadsheet uses Datasource for binding, the throw cause values function abandon all execution below, which including lines that should notify datasource about value changes. This the why the values come back again.
Could Kendo support either
a. deleting values across un-adjacent cells, or
b. deleting values of editable cells when disabled cells are also in selection?
I'm also curious why avoiding UnionRef? What will be the consequence of removing that error check?
Yes, the bug has been already fixed. The fix will be available within our next official release (R1 2018), which is expected by the end of the next week.
Concerning the newly reported issue of deleting multiple cell values in a DataSource binding scenario, we have included this enhancement into our backlog. Here you could find the GitHub item, where you could track its status.
Currently the values() method iterates over the cells in the Range and assigns the values passed. When having multiple ranges selected, their values could not be properly assigned. Therefore, the values() method could not be executed on a UnionRef.
Again, as a token of gratitude for the reported, I have updated your Telerik points.
Meanwhile, do you have any advise how I can deal with this bug so:
1. no error will thrown or a proper error message is presented
2. numbers in selected range will be either deleted and never come back, or won't be delete.
I am afraid, that I won't be able to offer you a viable workaround for the bug in question. Therefore, I would suggest you to keep tracking the GitHub issue and update the Kendo version used in your project, as soon as the fix is available.