pasting clipboard from Excel

[Keith Clarke]

As you can control the source, is it worth (at least to test) saving the range into a CSV format to force everything to plain text. That way non-text elements shouldn't get into the clipboard?

I often wish for an Office 'Copy Special' function to mirror 'Paste Special', so I can grab just content values from Office documents without the accompanying proprietary detritus - sorry, I of course meant 'added value'!! ;-)   
Best,
Keith..

On 13 Sep 2011, at 17:24, Colin Holgate wrote:

> I can select exactly the same range of cells, and one time a copy/paste will work, and another time it won't. There are no formulas in the spreadsheet I'm using, but the contents of many of the cells are derived from popup lists.
> 
> I think it's just a clipboard conversion issue, that sometimes Excel makes it be compatible, and other times it doesn't. Right this second I can't make it fail.