But something wents wrong when I opened one of the downloaded ODS files with LibreOffice, edited some of the values and saved it again before procesing it with my script. The modified ODS file now gives floats with my localization standard
That's not really surprising isn't it? It has already been pointed out by roboticus
that the "real value" is in the office:value
attribute. What's in text:p
is just a representation of it. So if you open a file and save it, then that representation will match whatever LibreOffice is currently set to.
You can change settings like decimal point, thousands separator, currency symbols etc in the LibreOffice options under "Language settings -> Language".
You can lead your users to water, but alas, you cannot drown them.