At 12:25 24/09/2007 +0200, Jarl Fransson wrote:
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! Note 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...
The "strange integer" is simply the internal storage of the date:
it's the number of days since the reference date.
I don't use NeoOffice or the Swedish locale, so I cannot test my
suggestion, but leading zeroes may be a workaround. I guess that
05.6 would still be interpreted as 5 June, but I hope that 005.6 or
even 011.6 would be interpreted as numbers - as you need. Another
thing to try would be 5.60.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
