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=22545#action_22545 ] 

Andreas Guelzow  commented on OFFICE-3468:


In OOo =LEN(IF(ISNA(A4); A5; A4)) results in 0 (assuming A4 and A5 are empty). On the other hand =LEN(0) results in 1. 
So what does IF(ISNA(A4); A5; A4) return (in your opinion)?

If your answer is "empty cell", then my question becomes, where is that type defined in the OpenFormula draft? Every OpenFormula function has to return a value of some type.

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