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.