To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95144
User er changed the following:
What |Old value |New value
================================================================================
Assigned to|spreadsheet |er
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Issue type|ENHANCEMENT |FEATURE
--------------------------------------------------------------------------------
Summary|ODF specification - adding|ODFF: implement SUMIFS()
| the SUMIFS function |
--------------------------------------------------------------------------------
Subcomponent|open-import |programming
--------------------------------------------------------------------------------
Target milestone|--- |OOo 3.x
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Oct 23 14:50:58 +0000
2008 -------
Both, the assumption that in Excel SUMIF(SearchRange,Criteria,SumRange) would
need a sorted SearchRange and a SUMIFS(SumRange,SearchRange,Criteria) function
would had been added that would SearchRange not need to be sorted are not
correct.
Correct is, that SUMIF() does not need the SearchRange to be sorted.
Correct is, that Excel 2007 added a function
SUMIFS(SumRange,CriteriaRange1,Criteria1,CriteriaRange2,Criteria2,...) that sums
a range if it matches multiple criteria.
Correct is also, that SUMIFS() should be specified in ODFF, and implemented in
OOo.
---------------------------------------------------------------------
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]
