export as Excel - numbers show up as text

[Ferdinand]

see attachment

[Ferdinand (office-chricar)]

my server LANG settings
set |grep LANG
LANG=en_US.UTF-8

fresh db with English only installed

[Olivier Dony (Odoo) (odo-openerp)]

This is indeed a web client error, as the server only returns the raw data to the clients, and the GTK handles this more correctly I think: re-assigned to correct project.
See in web, in file addons/openerp/controllers/impex.py in Impex.export_data method.

[Ferdinand (office-chricar)]

@Olivier
in GTK/Linux there is no "Open in Excel"
As this seems to be implemented in WEB could that feature go into GTK too ?
it should open the export in OpenOffice or LibreOffice

[Navrang Oza (noz-tiny)]

Hello Ferdinand,

Not getting your exact problem.
GTK dont have the problem because GTK doesn't support Excel.

So please describe in detail.

Thanks.

[t.o (emailbox4oerp)]

Hello,

Please Check Bug #534309 it's probably the same

[Ferdinand (office-chricar)]

http://pypi.python.org/pypi/xlwt is your friend - it works well with web client, so it should do also with any other client

this is a generic server side solution and xls can be open with whatever program is capable o the client side.

[Navrang Oza (noz-tiny)]

Hello Ferdinand,

I checked with CSV, Excel mode of export.
Both are displaying same result.

So can you provide more detail to reproduce this bug please ?
Thanks.

[Ferdinand (office-chricar)]

r 3950
No more options to produce a xls file
see attachment
Hope you check for xlwt on the server

needless to say that opening a csv file is a pain
neither date fields (sometimes) nor numbers (all decimals) are opened correctly in OO without modifying the settings for each column

[Ferdinand (office-chricar)]

sorrry, found the option at the bottom of the window ( not visible on my laptop)
that's why I pledged for a control panel grouping all elemetns for export together

 shouldn't execl be default if available ?

[xrg (xrg)]

On Thursday 25 November 2010, you wrote:
> sorrry, found the option at the bottom of the window ( not visible on my
> laptop) that's why I pledged for a control panel grouping all elemetns for
> export together
>
> shouldn't execl be default if available ?
>
My humble vote against.

I prefer to have csv, it's all about open standards. At the end of the day, it
is all a personal opinion.

About the first part of the question: can you check if the numbers formatting
could have to do with the decimal separator? (but I think your locale wouldn't
trigger that, does it?)

[Ferdinand (office-chricar)]

it seems to be possible to create open standards too (using python 3.x)
http://pypi.python.org/pypi/ezodf

until then I would prefer to have xls expport available - users can usually not handle csv files.

and it works nicely in Koo (v5 and v6)

[Ferdinand (office-chricar)]

in 7.0 numeric cells are still exported as strings - what a shame

class ExcelExport(Export):

the cell_value is a string and should be a number for integers,float to allow calculations in Excel

a brute force solution is attached