Export to Excel Data Types Fixed

Who: All users

What: Issues reported with the export to Excel not retaining the correct data types have been fixed in Version 10.

Why: Not all data types were converting correctly when exporting to Excel.

Known issues: Monetary fields from the report wizard that have been marked to include a dollar sign ($) will be exported into excel as text instead of money due to an unresolvable issue with Jaspersoft reporting libraries. Remove the dollar sign formatting in the report wizard to export monetary data as numbers. Also not all date formats are supported. Format date columns in the layouts tab of the report wizard and use something supported by Excel.


Add your comment

E-Mail me when someone replies to this comment