Issue 106959 - Err 509 when I add "=3,4+19"
Summary: Err 509 when I add "=3,4+19"
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOO310m19
Hardware: Other Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks: 92056
  Show dependency tree
Reported: 2009-11-16 22:31 UTC by latelilla
Modified: 2013-07-30 02:43 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description latelilla 2009-11-16 22:31:26 UTC
When I try to add in a cell "=3,4+19" I received "Err:509", but if I add "=3+7"
I received 10.

My OOO Language Setting are:
User interface: English (USA)
Locate settings: Spanish (Spain)
Decimal separator key: [check] Same as locale settings (,)
Default currency: EUR

Mi OS is Ubuntu 9.10 and language locale EN(USA)
Comment 1 Rainer Bielefeld 2009-11-17 05:02:08 UTC
NOT reproducible with "Ooo 3.1.1 WIN XP DE-multilingual version German UI
activated [OOO310m19 (Build 9420)]"!

Please attach a sample file
Comment 2 Joost Andrae 2009-11-17 09:22:38 UTC
Error 509 means

missing operator
Comment 3 Joost Andrae 2009-11-17 09:23:02 UTC
closing as "worksforme"
Comment 4 ooo 2009-11-17 12:33:28 UTC
@latelilla: Apparently the problem you encountered is caused by a modification
in go-oo based builds, fiddling with separators depending on the locale used. I
can reproduce the error in an upstream build using the expression
note the semicolon instead of comma. I presume the parameter separator in your
environment is comma instead of semicolon and clashes with the decimal separator.

@kohei: you may want to file a bug against the Novell bug tracker.
Comment 5 kyoshida 2009-11-17 12:41:37 UTC
@er: thanks.  Let me re-open this since the separator code itself is in the
upstream code too.  It will eventually be fixed here as well.
Comment 6 kyoshida 2009-11-17 12:41:56 UTC
Taking over.
Comment 7 kyoshida 2009-11-17 12:42:29 UTC
confirming, only happens when the separator is comma.
Comment 8 kyoshida 2009-11-17 12:42:43 UTC
Comment 9 kyoshida 2009-11-17 12:58:46 UTC
The question is, how did the separator end up with ','?  When the decimal
separator is ',', Calc shouldn't have picked ',' as the separator in the first

@latelilla: As a workaround, please go to Tools - Options - Calc
- Formula, and change the function separator and the array column separator to
';'.  Or you may be able to simply click 'Reset' to reset the separators.  Let
me know if that doesn't work.
Comment 10 kyoshida 2009-11-17 13:08:43 UTC
Yup, for me hitting the reset button brings the separators back to ';'.  So,
it's indeed the issue of the decimal and function separators being identical,
causing a separator clash.
Comment 11 kyoshida 2009-11-17 15:11:19 UTC
More on the variable separators please refer to Issue 92056.
Comment 12 latelilla 2009-11-30 22:20:41 UTC
sorry for my delay in replying, and thanks to @er, @kohei and the other people
to test my problem.

I have followed the workarround and I have click  'Tools - Options - Calc - Formula - Reset' to reset the separators, and I have no
problems, I add "=3,4+19", and "calc" shows the correct value: 22,4.

Thanks a lot

Comment 13 Rob Weir 2013-07-30 02:43:23 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.