Posted: Sun Feb 06, 2005 7:09 pm Post subject: comma (,) and dot (.) problems in Calc formulas
Just noticed a very strange behaviour of Calc (which I did not notice the last time I used it a couple of weeks ago). When I enter formula with dot to separate decimals e.g. =2.5+2.5 Calc transformates the numbers to some other large non-decimal ones. So the result of the above is 76948. The formula works fine though when I use comma g.g =2,5+2,5 as is the standard in Latvian. I guess NeoOffice somehow interacts with my International settings, but still the interaction is strange since the results never show up with comma. E.g. =2,5+1 would give result 3.5 (with dot). But =1.0 returns as 36526. =10.0 returns as 36800 but =100.0 is not accepted as formula at all, i.e., I get #NAME?
Has anybody had similar problem and can explain what it is about? I was trying to find if there is anything in Options that I had accidentally changed but could not find.
There are no strange formats in cell settings. But it must be some kind of strange interaction with language settings. My default language is Latvian. But in the spreadsheet that I was talking about the language is set to English US.
another thing is that it calculates ok when I have decimals with 'dot' in two different cells and result formula in the third. However, if you put them in one, the results get weird.
I checked some other languages that also use comma for decimal numbers, e.g., Lithuanian and German and they work fine. Of course there is no Latvian localisation of NeoOffice, but that should not mean the numbers also should not work fine, right? I guess that is a bug...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum