how it is possible to have different decimal seperator (both “.” and “,” in the same document?)
The same formula is applied and the formula works perfectely, but in some cells “.” is used as decimal seperator while in some “,”
Any idea what I can do to fix this problem?
I am using Calc 4.0.3.3. on Ubuntu 13.04
Yes, it is possible. Check that the cells are formatted to the same Language (under Format, Cells, tab Numbers, Language)
However when all cells are set to the same Language, if there are two separators they have different meanings. e.g if the Cell Language is set to English US 1,200 is one thousand two hundred units while 1.200 is one point two units (with three decimal cases).
thanks for clarifying this for me… I was working at home (where local language settings were set) and then edited document at work (where English language settins were set)… I guess this is the reason cell language is changed…