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] Commented: (OFFICE-3468) Changes needed forIFNA & IFERROR function definitions for empty cells

    [ http://tools.oasis-open.org/issues/browse/OFFICE-3468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=22108#action_22108 ] 

Dennis Hamilton commented on OFFICE-3468:

The problem with IFNA and IFERROR is that you need a consistent result for whichever alternative is taken, just like for IF(c, x, y), there is an issue about what one can know about the result when it is based on either x or y (of not an Error-type value).

So IFERROR(1/C5, "xyz") is a problem if C5 is a number not zero versus it being zero.  One could say that the result is either 1/C5 or "xyz" but it is messy to do that.

Maybe we already have to provide for that in OpenFormula.  Or are we creating more problems about dynamically carrying the types on results in intermediates of calculations?

> Changes needed for IFNA & IFERROR function definitions 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
>            Assignee: Eric Patterson
>             Fix For: ODF 1.2 CD 06
> For both IFNA & IFERROR, The function definitions currently state:
> 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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]