Trimming spaces with Copy to Excel -> Copy as xlsx...

[Drillnot]

When copying grid results to Excel as xlsx, leading and trailing spaces for VARCHAR2 columns are trimmed. If copying to Excel as xls, these spaces are not trimmed.

Is this a preference to be set? The Copy to Excel function should not automatically trim spaces in any format, but a preference configuration might be useful.

 

[Maxmix]

Also during exporting strings with non-printable characters within, XLSX export fails. Maybe, it's not a bug, but tracking down was difficult. It was chr(8) character in my case ;-)

 

[Marco Kalter]

We'll fix it.