Oracle column Number (22,3) is exporting to Excel as a text field instead of a number.
e.g. 123456789012.973 ends up as 123456789012.9730 and the cell format is 'Text'
A smaller number e.g. 1234567.757 gets exported correctly (as Accounting with 3 decimal places)
This issue occurs in both 'select to file' automation activity, and data grid | quick export | To file | Excel
WORKAROUND
Export to comma separated value 'csv' file instead of .xls or xlsx
STATUS
Fixed in version 4.3. The latest release can be downloaded here.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center