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

Hi Afvalbrievenbus,

Afvalbrievenbus schrieb:
> 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?

You can make your own document template and set it as default template. 
In this template set the language of numbers to English(US) in tab 
"numbers" in style "Default".

Kind regards
Regina

--
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