To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114293
Issue #|114293
Summary|DSUM error 504 due to second parameter (field number)
Component|Spreadsheet
Version|OOO320m9
Platform|PC
URL|
OS/Version|Windows 7
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|rgayoso
------- Additional comments from rgay...@openoffice.org Fri Sep 3 15:55:56
+0000 2010 -------
When COLUMN() function is used as the second parameter, DSUM() gives error 504.
If I cast the return value of COLUMN() to a number using N(), DSUM() works ok.
If I put a simpler argument to COLUMN() instead of a range, DSUM() works ok.
If that function is precalculated on another cell (F3), DSUM() works ok.
---A----------B--- -C-D-E- ---F----
1 Customer Total Customer Formula used on cell to the left
2 John 10 John
3 Peter 20 1 COLUMN(A1:B1)
4 Err:504 DSUM( A1:B3; COLUMN(A1:B1) +1; F1:F2 )
5 10 DSUM( A1:B3; N(COLUMN(A1:B1))+1; F1:F2 )
6 10 DSUM( A1:B3; COLUMN(A1) +1; F1:F2 )
7 10 DSUM( A1:B3; F3 )
Related issues
58183
77107
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
