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=22544#action_22544 ] 

Eike Rathke commented on OFFICE-3468:
-------------------------------------

@Andreas:
Yes, I meant so say "In OOo and Excel, IF(ISNA(A4); A5; A4) does not return an empty string" as I wrote. I fail to see how my argument would support the opposite.


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