[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-1194) Public Comment:[office-formula] SUMIF and behavior of empty cells in reference ranges
[ http://tools.oasis-open.org/issues/browse/OFFICE-1194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eike Rathke updated OFFICE-1194: -------------------------------- Proposal: Insert a section before 3.11.7 Database, named "Criterion". Move from 3.11.9 Criteria " A reference to an empty cell is interpreted as the numeric value 0. A matching expression can be: ... " to the new section. Add details: "<>" matches non-empty cells. "=" matches empty cells. "<>X" matches any value except X, including empty cells. Note: "=0" does not match empty cells. In then 3.11.10 Criteria add a reference to then 3.11.7 Criterion: Expressions are matched as per 3.11.7 Criterion. For COUNTIF, COUNTIFS, SUMIF and SUMIFS: Change the parameter from "Any C" to "Criterion C". Delete "The criteria C may be ..." paragraphs (already change-tracked, accept change). For functions (COUNTIF, COUNTIFS, SUMIF, SUMIFS) that accept a single criterion the matching expression follows the definitions given in 3.11.9 Criteria. In fact 3.11.9 Criteria allows a special syntax where "<>" matches non-empty cells and "=" matches empty cells, that isn't stated yet. Also, "<>x" matches any cell where the value is not x, including empty cells. Note: "=0" does *not* match empty cells. > Public Comment: [office-formula] SUMIF and behavior of empty cells in reference ranges > -------------------------------------------------------------------------------------- > > Key: OFFICE-1194 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-1194 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Reporter: Robert Weir > Assignee: Eike Rathke > Fix For: ODF 1.2 Part 2 CD 3 > > > Copied from office-comment list > Original author: Steven Powell <Steve.Powell@springsource.com> > Original date: 6 Jan 2009 16:27:51 -0000 > Original URL: http://lists.oasis-open.org/archives/office-comment/200901/msg00003.html > See also > http://lists.oasis-open.org/archives/office-comment/200901/msg00004.html > http://lists.oasis-open.org/archives/office-comment/200901/msg00005.html -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]