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 [email protected] 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
