Hi On Sun, 2011-05-22 at 11:47 -0700, 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. > Check under Tools>>Options>>Language Settings>>Languages to is the check box "Decimal Separator Key" is selected. Also, check your default language settings, if US is checked the default separated is the period not comma. Typically this is localization setting and if the wrong location is selected, it will use the default settings. -- Jay Lozier [email protected] -- 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
