Leading/Trailing spaces are trimmed when exporting to Excel

[jking]

Marco,

Whenever I export the results to Excel, any records that have a leading/trailing spaces are trimmed.

Query:

select rpad(' ', level * 5) || 'Indent ' || (level * 5) example
  from dual
connect by level <= 5;

Results from Query:

EXAMPLE
     Indent 5
          Indent 10
               Indent 15
                    Indent 20
                         Indent 25

What it looks like in Excel:

EXAMPLE
Indent 5
Indent 10
Indent 15
Indent 20
Indent 25

Thanks.

 

[Marco Kalter]

It works correctly when exporting in XLS format, but XLSX format does indeed show this behavior. We'll fix it.