Re: [libreoffice-users] Err:509 and decimal separator key

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
jslozier@gmail.com

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
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