[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 AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF and SUMIFS:
Change the parameter from "Any C" to "Criterion C", respectively "Any C1" to "Criterion C1", ...
Delete "The criteria C may be ..." paragraphs (already change-tracked, accept change).
was:
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).
> 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]