To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85000 Issue #|85000 Summary|ODFF: SUMIF's 3rd parameter is handled differently fro |m Excel Component|Spreadsheet Version|680m241 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|er Reported by|kohei
------- Additional comments from [EMAIL PROTECTED] Fri Jan 4 19:06:31 +0000 2008 ------- In Calc, SUMIF's 3rd parameter expects a cell range, and Calc expects the geometry of that cell range to match that of the 1st parameter. In Excel, however, the 3rd parameter's range geometry does not have to match the 1st parameter's; Excel takes the upperleft cell address and use the geometry of the 1st parameter to turn that into a cell range. --------------------------------------------------------------------- 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]
