export to ods with ',' instead of '.'

unknown

Hi,

With Birt 4.2.2
I'm french user and use this type of formatting for values : 63 992 284,08
When I export to ods The value in my spreadsheet are like 6.399228408E7 (text value : I cannot apply sum on this cells...)
When I export to excel format, there is no problems : 63992284,08

For instance I can use this last form of export and ask to user to transform .xls in .ods

But Is ther a way to have a good format in the ods export ?

thanks a lot for your help

Vincent

kclark

Are you opening the ODS file with excel or another program? I was able to change the number format in BIRT and it still exports as ###,###.## when opened in excel. If your trying to view the ODS file in excel I think there is a windows setting that will force the format change.