A week ago we upgrade to Apex 20.1 (from 19.2).
I get problem exporting to csv from Classic Report (may other type too...).
Using this example query:
select '="'||'0001'||'"' csv_x_execl from dual
Till to Apex 19.2, in excel I get a cell with usable value: 0001 ( in csv file: ="00001")
With Apex 20.1, in excel I get a cell with UNUSABLE value: =""00001"" ( in csv file: " =""00001""")
If I use:
select '0001' csv_x_execl from dual
In excel I get only "1", zeroes are lost!! (It works well only using importing from text wizard ...)
Someone have a "csv" solution?
(for complex excel file we use Birt, but for simple report we use normal csv download ...till now!)
Thanks
Stefano Corradi
PS:
documentations says:
CSV Enclosed By
Enter a delimiter character to delineate the starting and ending boundary of a data value. The default delimiter is double quotation marks.
That it's how NOW it works!!