openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #15925
[Bug 1001668] Re: Excel - export numbers as float instead of unicode
*** This bug is a duplicate of bug 844569 ***
https://bugs.launchpad.net/bugs/844569
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/
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1001668
Title:
Excel - export numbers as float instead of unicode
Status in OpenERP Web:
New
Status in OpenERP Server:
New
Bug description:
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/1001668/+subscriptions