Excel - export numbers as float instead of unicode

[Ferdinand]

the attached diff produces the following output

FGF cell_val unicode Price / Unit
FGF cell_val unicode 0.08

indicating that number values are classified as unicode, hence show up in Excel as strings instead of numbers

trying to convert any unicode to float (which is only for demo purpose) creates correct excel number cells

the correct way would be to check the data type of the column (which must be available somewhere to right adjust numeric columns in the web client) and apply float(cell_value) only for these columns.

unfortunately my knowledge of the web client is to limited to find out the column format

[Ferdinand (office-chricar)]

please also make sure that the decimal precision of the column is set correctly

[Xavier (Open ERP) (xmo-deactivatedaccount)]

You already reported this last September and I already told you back then that this was a server issue of the export API, the web client will not do anything about it and we will not add random shit to the export code to fix server issues.

[Carlos Liebana (carlos-liebana)]

BTW, for one of our customers we have implemented exporting (customs reports) using this python libraries [1] instead of the csv one coming by default in OpenERP.

Here in Spain, CSV exports are not as useful as they should be because number formats (by default with . instead of our standar ,)

[1] http://www.python-excel.org/