Bug#519828: openoffice.org-calc: The program reports error on the "IF" function, copied verbatim from documentation
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é
--
.''`. René Engelhard -- Debian GNU/Linux Developer
: :' : http://www.debian.org | http://people.debian.org/~rene/
`. `' rene@debian.org | GnuPG-Key ID: 248AEB73
`- Fingerprint: 41FA F208 28D4 7CA5 19BB 7AD9 F859 90B0 248A EB73
Reply to: