Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Err 509 when I add "=3,4+19" | ||
---|---|---|---|
Product: | Calc | Reporter: | latelilla <latelilla> |
Component: | viewing | Assignee: | AOO issues mailing list <issues> |
Status: | ACCEPTED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues, kyoshida, rainerbielefeld_ooo_qa |
Version: | OOO310m19 | Keywords: | needmoreinfo, oooqa |
Target Milestone: | --- | ||
Hardware: | Other | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- | ||
Issue Depends on: | |||
Issue Blocks: | 92056 |
Description
latelilla
2009-11-16 22:31:26 UTC
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. |