OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[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:

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.


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]