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. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies