Bug#519828: openoffice.org-calc: The program reports error on the "IF" function, copied verbatim from documentation
René, thanks for the speedy answer. OK, not everything is crystal-clear to
me - after all, I need neither a column separator nor a row separator - I
need a parameter separator in a function call!
But, yes, using the ',' where the current documentation says to use ';' in
English-locale oocalc works, so I have a functional work-around, and you
maintainers can fix the documentation at your leisure. It is going to be
quite a task to fix all the examples, I believe.
It also works to switch to Danish locale and use ';'. And then when I save
the file and switch back to English locale, the ',' pops up.
English in Denmark? Well, I do write an occasional English sentence :-) But
I still have a Danish keyboard, just to be able to write my own name. I
have, however, to cheat in order to write
Mange tak og venlig hilsen
Vielen Dank und freundliche Grüße
^
Peder Chr.
On Sunday 15 March 2009, Rene Engelhard wrote:
> retitle 519828 doesn't document ; vs , change in calc formulas
> reassign 519828 openoffice.org-help-en-us
> tag 519828 + pending
> thanks
>
> Hi,
>
> Peder Chr. Nørgaard wrote:
> > The function "IF", whenever I try to enter it in a cell, consistently
> > report "Err:508", claiming a problem with bracketing. In despair I
> > finally created a very little spreadsheet and copied the expression
> >
> > =IF(A1>5;100;"too small")
> >
> > verbatim from the Openoffice Help example. Same problem.
> >
> > I suspect that the problem may be related to the fact that I work in a
> > not- quite English environment; my locale is en_DK.UTF-8. The separator
> > ";" may be a different one? If that is the case, and I have missed to
> > locate such info in documentation, I apologize; still, the exact error
> > message would be quite confusing.
>
> No, it actually wasn't in the hekp until now, the 3.1 ooo-build contains
> this, though.
>
> -<paragraph role="paragraph" id="par_id936613" xml-lang="en-US"
> l10n="NEW">The column separator (separating elements in one row) is the ';'
> semicolon. The row separator is a '|' pipe symbol. The separators are not
> language and locale dependent. </paragraph> +<paragraph role="paragraph"
> id="par_id936613" xml-lang="en-US" l10n="NEW">The column separator
> (separating elements in one row) and the row separator are language and
> locale dependent. But in this help content, the ';' semicolon and '|' pipe
> symbol are used to indicate the column and row separators, respectively.
> For example, in the English locale, the ',' comma is used as the column
> separator, while the ';' semicolon is used as the row
> separator.</paragraph>
>
> > Locale: LANG=en_DK.UTF-8, LC_CTYPE=en_DK.UTF-8 (charmap=UTF-8)
>
> There's english spoken in Denmark? ;)
>
> Grüße/Regards,
>
> René
--
Peder Chr. Nørgaard e-mail: pcn@pogt.dk
Gefionsvej 19
DK-8230 Åbyhøj tel: +45 87 44 11 99
Denmark mob: +45 30 91 84 31
Reply to: