I'm experiencing some problem with copy/paste: my rows don't always have same columns count, because I'm using spanning.
So it sometimes makes "funny" things when pasting data with ClipboardUseOnlyActivePosition = false, when the paste selection is automatically extended.
And with ClipboardUseOnlyActivePosition= true it only pastes one cell ? Is there a way to paste only in active selection (cells, rows, ...) ? So if the users selects a spanned cell a pastes data, it's "his problem" if this isn't really meaningful
/ or shouldn't be done.
But auto-extension on spanned rows (or other rows of another type, or...) can be dangerous, I think.
And there is also a problem if there is a row header in the middle. Perhaps would like to automatically "jump" such a row when pasting data. I understand that it is not a really standard feature an that it should be manually developped, but a "ClipboardUseOnlyActiveSelection"
option could perhaps be a useful intermediate solution.