Export to Excel

[fredp1]

Hi,

CE 8.5, SQL 2000
When I export to Excel, (CE), the column is formated to 4 decimals (as per CR format), but when looking at the Excel cell data, the data contains more decimals, say 6 decimals. In CR 8.5 exporting (data only) it truncates/rounds the cell data to 4 decimals.

Is this a typical behaviour of U2FXLS?

Is there any other solution than creating a formulae for every field and using a CR rounding/truncate function?

Thanks
(Pitty the search on the site is not working yet!)

 

[synapsevampire]

Have you applied the latest service pack? They often address exporting:

http://support.businessobjects.com/fix/hot/si75/default.asp

-k