Windows XP - open in excel - must respect decimal separator of locale

[Ferdinand]

open in excel apparently exports number values with decimal dot regardless if the locale settings require comma or dot rendering the export result useless.

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello,

This is not acceptable as this will confuse data to be separated from.

Example:

Name,amount
abc,48,55

On importing time, you may try something tricky, but while exporting, CSV is always Comma separated.

Thank you.

[Ferdinand (office-chricar)]

sorry must have been a misunderstanding
I am not talking about saving the file as CSV - I am talking about the option "Open in Excel"
LANG=en_US expects a dot
LANG=de_DE expects a comma (we have a comma not dot on the numeric keypad in Austria/Germany)
as decimal separator

while it is possible to set or find some tricks to convert CSV files "Open in Excel" can't and should not be influenced by the user, but should work out of the box.

IMHO the problem could be solved by setting the usual variables like Openoffice
charset:
field delimiter:
text delimiter:
use the LANG variable or ask user if dot or comma should be used for decimal separator
wheras field delimiter and decimal separator must be different.

this is both true for Open in Excel and CSV export / import round trip.

I can assure you that the not unified use of decimal separator is one of the most annoying import/export problems and most of the english speaking world is not aware of.

the only reliable way it "works" is to ask the user ....

for experience Linux users it's not a problem to start OO ok openerp-client with correct LANG settings, but on Windows + Excel it's not easy (or possible?) to change the LANG for Excel only

[Ferdinand (office-chricar)]

just want to point to Koo which exports date and number fields correctly in OpenOffice regardless if the computer/user is running English or German

BTW koo accepts dot and comma as decimal separators from the numeric keypad for numbers and replaces them with the the valid decimal separator (actually I do not know which settings are taken - but this is very user friendly.

[Ferdinand (office-chricar)]

koo also exports correctly to Excel on Windows

[Ferdinand (office-chricar)]

pls could this be addressed

[Christophe CHAUVET (christophe-chauvet)]

Hi

In french we have this problem, and another with UTF8 that cannot convert in the user locale

eg: é character appear as é

in France Windows use CP1252

Regards,
P.S i attach an example

[Ferdinand (office-chricar)]

similar to this !?
https://bugs.launchpad.net/openobject-client-web/+bug/675250