Jul 25 2017 04:44 PM
As seen in the screenshot, I selected the blocks on the left using ctrl and shift. If pasted in excel, it is all going well, but when copied to another textfile (or the sent to box of my email), it goes wrong. How can this be solved? And will this bug be removed in an update?
Jul 26 2017 05:01 AM
Hi Friso,
I guess that's not a bug, that's by design. If you open clipboard you'll see what Excel saves in it the entire continuous range.
If you paste back to Excel it somehow recognizes what the selection is not adjacent, i don't know how it works exactly. But Windows clipboard has no such information and paste everything.
From my memory there were some VBA scripts to solve the issue, google may help.