Ubuntu 10.04 LTS (Lucid Lynx)
Also filed in Debian bug tracker August 8 2010: #594120 (openoffice.org-calc: Function Wizard omits sheet reference)
Much simpler way to reproduce this in Calc:
-Click Function Wizard
-Double-click ABS function
Function Wizard enters =ABS(A1:A1) and Calc returns Err:522
Function Wizard to enter =ABS(Sheet2.A1) and Calc to return 0.
For me the severity is critical because it stops me from working efficiently. I use the Function Wizard daily to build formulas on complex multi-sheet files. But, I can revert to Beta1 where this bug does not appear to exist.
Yes, this needs to be fixed. Thanks for reporting this. I'll look into this sooner rather than later.
Found the cause & fixed it on master. This will be fixed in the next release.
Verified in 10_10_28_Cedric.rpm build - Closing - Sophie
This is a Calc issue, therefore changed 'Component' field accordingly.
Set Version according to original description.