Issue 106959

Summary: Err 509 when I add "=3,4+19"
Product: Calc Reporter: latelilla <latelilla>
Component: viewingAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida, rainerbielefeld_ooo_qa
Version: OOO310m19Keywords: 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
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)]"!

@latelilla:
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
=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.
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
accepted.
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
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.
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 -
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

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