Ronja Twibright Labs

Dates instead of decimal numbers in Openoffice

When I load CSV into OpenOffice, I get dates instead of decimal numbers

This is problem of OpenOffice. Openoffice set for language where decimal places are separated by comma (e. g. Czech) is incompatible with OpenOffice set to English regarding saving and loading data in CSV. Set tool -> options -> language settings -> languages all to English before opening the document and it will work.

An expected information missing here?