Export Format Issue

[Former Member]

I exported some data from a information space to .csv and the same to excel.

I notice for one of the columns where the data is stored with 4 decimal places, the one in .csv shows only 3 decimal places when i open it in notepad or excel.

The same data which i exported in excel shows 4 decimal places as stored in the database.

In the universe the object is formatted to show 4 decimal places.

I appreciate any reply for the mismatch of this behaviour.  My environment is BO 4.1 SP6 Patch 4.

[CdnConnection]

Tagu,

     When you Export to CSV it exports RAW data with NO Format (see note from Explorer Users Guide).  If you want the format to retain then you MUST export as XLSX.

Regards,

Ajay

[former_member376301]

Hi Tagu Tagu,

It seems that when you export decimal numbers to csv format, 'export engine' formats these numbers into "-#,##0.###" format (you should see these 3 decimals : .### ). This format is fixed.

Arnaud