when I export data to Excel using the “export to file” option, the decimal digits are not showing in Excel. The data itself is there, I can format the cell/column in Excel to standard and the digital digits are being displayed then.
Exporting to an Excel instance, everything is fine.
The data in the database however is in varchar, therefore I have to use to_number(data) in my query. In the result set everything looks o.k., copy and paste from there to Excel also is fine.
Unfortunately, automation scripts use the export to file functionality.
Playing around with the TDP options, i.e. grid numbers did not solve the problem.
Anyone else seeing this behaviour?