[ http://tools.oasis-open.org/issues/browse/OFFICE-3468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Patterson updated OFFICE-3468:
-----------------------------------
Proposal:
Update as follows:
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.
was:
Update as follows:
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 zero.
Component/s: Needs Discussion
Updated proposal to remove last sentence. treatment of empty cells is covered elsewhere and not necessary for this function definition.
> 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
