Request

[rwoeln]

I have right now installed ver. 5.1 of PL/SQL Developer, and was very pleased with the new functionality that makes it possible to copy to Excel from the result grid.
Earlier I have done this a lot, by using "Copy with header". But - I have often marked the sheet that I am working in and set the format of all Cells to text before pasting, as I have som data columns containg text starting with zeroes. If the cells are numeric then these zeroes are lost.
Is there any possibility to do something like this using the new "copy to Excel"-function, or do I have to use my old routine?

The program (PL/SQL Dev) knows the format of each column - would it be possible to set the cells of the column to text when a VARCHAR2-column is found?

 

[Marco Kalter]

The cell type of a varchar2 is indeed not defined. If Excel notices a numeric value, it will treat it as a number column.

We'll try to fix this.

 

[rwoeln]

I installed version 5.1.3 today - but this is not fixed in this version, is it? Do you have any plans on when this will be taken care of?

Best Regards,
Randi

 

[Marco Kalter]

We're looking in to this for 5.1.4.

------------------
Marco Kalter
Allround Automations

 

[Jean-Paul Finne]

Enhancement requests for "copy to Excel"

1) add the sql statement into a cell (with formatting like "wrap text", "Merge cells", "vertical:Top")
2) add the title of the sql window.

Jean-Paul

 

[Marco Kalter]

I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations