Problem with Copy&Paste to Excel

[sladek]

I have a problem with copy & paste the result of a query to Excel if the content of a cell begins with double-quotes (like "hello). Everything of the result between the first double-quote and the next double-quote (even - and that's the problem - if the next appearance of a double-quote is in another cell) will be inserted in Excel in the same cell. Then the double-quote at the beginning is lost.
This problem still persists since v5 (earlier versions not tested).
Sometimes the "Copy to Excel"-Feature still works correctly for such a result, but sometimes it does nothing. But I can't figure out the difference between a working and a non-working result.
Regards
Jens

 

[Marco Kalter]

I cannot immediately reproduce this problem. If you have a reproducible case, please let me know.

 

[sladek]

Hi Marco,

could you please try this?

Create a table with two varchar columns and insert something like this:

ROW COLUMN1         COLUMN2
  1 aserkuef	    afdlkjewqlir
  2 sdfkhdl"kljfd   sdflkj"sfkj
  3 "afkjewk	    sdfkjsed
  4 sflkjwelk	    afdlkjel
  5 dsfk"aflkje	    sdreiufk
  6 sdflkjew	    dsflkfje

Then do a select * from this table,mark the two columns, click "Copy with header" and do an insert in Excel. There will only be 4 rows in Excel and one cell with the content of COLUMN1 in ROW 3 to COLUMN1 in ROW 5, with some special symbols in it.
I'm using PL/SQL Developer V7 (but like i mentioned it's the same in V5), Excel 2002, Windows XP with SP1 and german language configuration.

Hope you can reproduce it.

Thanks and greetings
Jens

PS: In this case, "Copy to Excel" works fine.

 

[Marco Kalter]

I see. When pasting in Excel, it interprets the leading quotes. Instead of this:

"abc

We would need to place this on the clipboard to make Excel happy:

"""abc"

We'll look into this.