← Back to team overview

openerp-india team mailing list archive

[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