On 23/05/11 06:47, Afvalbrievenbus wrote: > Dear mailinglistreaders, > > When I enter =11,36 + 5 in a cell, Libreoffice displays Err:509. I think > it's because of libreoffice doesn't recognise a comma as a decimal > separator. (I suspect this to be the problem, because when I enter a > period(.) instead of a comma(,), the errortext disappears.) I tried to fix > this by changing the preferences. I went to tools/options/languages. I have > the userinterface on English(UK), locale on English(UK), I unchecked the box > next to "decimal separator key" and I have Euro(Netherlands) as default > currency. However, with these settings I still get the errortext when I > enter =11,36 + 5 . What can I do to make Libreoffice accept a comma as a > decimal separator? > > Kind regards, > Afvalbrievenbus > > -- > View this message in context: > http://nabble.documentfoundation.org/Err-509-and-decimal-separator-key-tp2972484p2972484.html > Sent from the Users mailing list archive at Nabble.com. > > Hi. Yes it seems the decimal separator is undefined (unclear) when you uncheck "Same as Locale". I would have thought unchecking this would have given some options or the ability to enter a separator. steve
-- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
