Home

copying from excel to text goes wrong, how to solve

%3CLINGO-SUB%20id%3D%22lingo-sub-90274%22%20slang%3D%22en-US%22%3Ecopying%20from%20excel%20to%20text%20goes%20wrong%2C%20how%20to%20solve%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-90274%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20seen%20in%20the%20screenshot%2C%20I%20selected%20the%20blocks%20on%20the%20left%20using%20ctrl%20and%20shift.%20If%20pasted%20in%20excel%2C%20it%20is%20all%20going%20well%2C%20but%20when%20copied%20to%20another%20textfile%20(or%20the%20sent%20to%20box%20of%20my%20email)%2C%20it%20goes%20wrong.%20How%20can%20this%20be%20solved%3F%20And%20will%20this%20bug%20be%20removed%20in%20an%20update%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-90274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecopying%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-90417%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20from%20excel%20to%20text%20goes%20wrong%2C%20how%20to%20solve%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-90417%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Friso%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20that's%20not%20a%20bug%2C%20that's%20by%20design.%20If%20you%20open%20clipboard%20you'll%20see%20what%20Excel%20saves%20in%20it%20the%20entire%20continuous%26nbsp%3Brange.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20395px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F17737iB9F3A95D0E013BBE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Clipboard.JPG%22%20title%3D%22Clipboard.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20you%20paste%20back%20to%20Excel%20it%20somehow%26nbsp%3Brecognizes%20what%20the%20selection%20is%20not%20adjacent%2C%20i%20don't%20know%20how%20it%20works%20exactly.%20But%20Windows%20clipboard%20has%20no%20such%20information%20and%20paste%20everything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20my%20memory%20there%20were%20some%20VBA%20scripts%20to%20solve%20the%20issue%2C%20google%20may%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Friso de Boer
Occasional Visitor

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?

1 Reply

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.

 

Clipboard.JPG

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.