i try to configure openoffice in linux server to use comma as decimal separator,i search and i found that have a relation with regional parametre so i configure etc/locales.conf to use french as default language but i still have the same problem (the file i use is an xlsx 6 300,20£ is transformed on 6,300.20£):
[default]
date format = %b %e %Y %I:%M:%S:%z%p
LANG=fr_FR.UTF-8
LC_CTYPE="fr_FR.UTF-8"
LC_NUMERIC="fr_FR.UTF-8"
LC_TIME="fr_FR.UTF-8"
LC_COLLATE="fr_FR.UTF-8"
LC_MONETARY="fr_FR.UTF-8"
LC_MESSAGES="fr_FR.UTF-8"
LC_PAPER="fr_FR.UTF-8"
LC_NAME="fr_FR.UTF-8"
LC_ADDRESS="fr_FR.UTF-8"
LC_TELEPHONE="fr_FR.UTF-8"
LC_MEASUREMENT="fr_FR.UTF-8"
LC_IDENTIFICATION="fr_FR.UTF-8"
LC_ALL=fr_FR.UTF-8
[fr_FR]
date format = %b %e %Y %I:%M:%S:%z%p
language = fr_french
charset = UTF-8
is there an other solution to fix this problem