2007/9/24, Jarl Fransson <[EMAIL PROTECTED]>: > I use Neooffice 2.0 based on OpenOffice.org 2.0.3. > I use Swedish locale and I want to do that of natural reasons. > > My problem is if I type 5.6 oocalc thinks this is a date! The worst > thing is that it destroys the data! > Not that 5.6 is not typically a date in Swedish language, > > I cannot even reverse the formatting to number (it then is a strange > integer number I > never wrote)! I have spent a number of hours to get this program > understand 5.6 is a > number! The settings are hopelessly to complex and still I cannot > switch off this stupid > autoformatting. > > I really hate computers that guess wrong about my intentions. Stop > guessing! > (or at least let me switch off all this) This is even worse than MS > Excel... > > Regards, > Jarl Fransson
OK Jarl, my first reaction was: why don't you go back to MS Excel?? Don't yell at us, we are volunteers. We are users that try and help out other users. my second reaction: first define the number type of a cell/column/row before putting in data (Format > Cells > ...). my third reaction: what is the decimal separator in Sweden? In Dutch it is <,>, so if I type a comma, Calc knows it's a number with decimals. If I use <.>, Calc supposes it's a date and puts 05-06-07 in the cell (otherwise 39238 after the start date). So define th decmal separator in Tools > Extra > Linguistics > Language > Decimal separator (same as in ln country setting)) HTH -- Guy using dutch OOo 2.3 m221 on a iMac Intel DualCore Tiger and brazilian OOo 2.3 RC 3 on a G4 PPC Powerbook Tiger -- please reply only to [email protected] -- Dodoes can't afford to have headaches --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
