[OASIS Issue Tracker] Created: (OFFICE-3468) Changes needed forIFNA function definition for empty cells

Changes needed for IFNA function definition for empty cells
-----------------------------------------------------------

                 Key: OFFICE-3468
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3468
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: Needs Discussion, OpenFormula
    Affects Versions: ODF 1.2 CD 05
            Reporter: Eric Patterson
             Fix For: ODF 1.2 CD 06


The function definition currently states:

Semantics: Computes X. If ISNA(X) is true, return Alternative, else return X. Thus this is semantically equivalent to IF(ISNA(X); Alternative; X), except that X is only computed once. If X or Alternative is a cell reference to an empty cell, it is treated as the empty string "".

In both Open Office & Excel, the semantic equialent listed above, returns a zero, not an empty string.  The function definition needs to be updated to allow for this.

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