Apache OpenOffice (AOO) Bugzilla – Issue 106959
Err 509 when I add "=3,4+19"
Last modified: 2013-07-30 02:43:23 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)
NOT reproducible with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated [OOO310m19 (Build 9420)]"! @latelilla: Please attach a sample file
Error 509 means missing operator
closing as "worksforme"
@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 =3;4+19 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.
@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.
Taking over.
confirming, only happens when the separator is comma.
accepted.
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 place... @latelilla: As a workaround, please go to Tools - Options - OpenOffice.org 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.
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.
More on the variable separators please refer to Issue 92056.
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 - OpenOffice.org 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
Reset assignee on issues not touched by assignee in more than 1000 days.