I have a grid with what I think of as vanilla processing that allows copy and paste.
If I select cell A1 and use ctrl+c to copy and then select cells B1, B3, B5 and use ctrl+v to paste it then pastes in cells B1, B2 and B3 and changes the selection to these three cells.
Whatever I do, if I select n non-contiguous cells and paste the grid then it changes the selected block a n contiguous cells starting from the first of the selection.
Is this expected behaviour? Am I missing a setting somewhere?
Hi Gwyn,
The grid does not support non-contiguous pasting. So the past operation occurs on the first selected cell and fills down. This is the intended behavior.
Oh that's really disappointing and dare I say it, naff. First time I've needed to say that.
I can imagine problems with pasting cell blocks and source shape being different from target shape but not a single value.
The biggest issue in this default behaviour is that it fills non-selected cells with data therefore overwriting them and also changes the selected cells. My grid feels like it's been violated...
Any workarounds you can recommend? I can't be the first person to have a user spot this and complain.
Hello Gwyn,
So, what you could do in order to resolve your issue is to modify the grid's behavior using the BeforeMultiCellOperation event. When you try to paste some value this event will fire. By using a foreach cycle you could pass through all selected cells and set them the copied value one by one. This simple implementation of the paste operation could resolve your issue.
I’ve implemented this suggestion in a simple sample, and you could run and evaluate it, please see attached zip.
Please let me know if you have any further questions.
That's great info, thanks. I shall have to check it out but busy on another project aspect for the client at the moment so I will come back in the next week or so having tried it and looked at the sample.
As always, a pleasure dealing with you guys. Thanks
I am just checking about the progress of this issue. Let me know If you need my further assistance on this issue?
Thank you for using Infragistics Components.