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/ `. `' r...@debian.org | GnuPG-Key ID: 248AEB73 `- Fingerprint: 41FA F208 28D4 7CA5 19BB 7AD9 F859 90B0 248A EB73 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org