Export to Excel and Copy to Excel is different?

[SaKa]

Hi,
We normally execute a query and highlight lines and use Right mouse click to use Copy to Excel which creates a excel file , which creates a excel with data in a worksheet and second worksheet saves the SQL query used, which is perfect for us.

Recently we had to export large volume and PLSQLD ran out of memory, we used the Export to Excel button on the Query window header area, seems to produce the same output, without any memory issues and also very quick , which is great. However, we started noticing differences;
1. mainly it creates 2 worksheets , the second worksheet is blank, no SQL is saved.
2. numbers that dont have decimals it creates .00

Why is it behaving differently? Can we not make it work the same way please?

Thanks
Sanj
My Version 16.0.7.2172 (32 bit)

 

[Marco Kalter]

The Copy to Excel function takes the information from the result grid(s) and copies them to Excel.
The Export functions write the results directly to a file, without using the grid intermediate.

We'll see if we can address the differences for the Excel case.