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

# office message

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

Subject: [OASIS Issue Tracker] Issue Comment Edited: (OFFICE-3468) Changesneeded for IFNA & IFERROR function definitions for empty cells

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Tue, 12 Oct 2010 12:14:25 -0400 (EDT)

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

Dennis Hamilton edited comment on OFFICE-3468 at 10/12/10 12:13 PM:
--------------------------------------------------------------------

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 (if 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?

was (Author: orcmid):
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
-