To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97789
Issue #|97789
Summary|Calc in dev300m37 cannot calculate array cells with ce
|ll names
Component|Spreadsheet
Version|1.0.0
Platform|Unknown
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|tboxmy
------- Additional comments from tbo...@openoffice.org Tue Jan 6 09:37:31
+0000 2009 -------
In Calc, When I use the array formula in sheet1;
{=SUM(IF(month=$A6;IF(category=D$4;pax);0))}
It detects the "month" cell name as in the same spreadsheet only. My cell name
have been set for sheet2 for "month", "category" and "pax".
However in Calc 2.4.1, the cell name like "month" applies to all sheets. Also,
now I have to move the cursor to end of the line before I can press the
Ctrl+Shift.
---------------------------------------------------------------------
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
