[OASIS Issue Tracker] (OFFICE-4113) CLONE - Public Comment: [ODF 1.2] Comment missing, whether error values are propagated

From
OASIS Issues Tracker <>
Date
2022-07-18T18:30:02+00:00
ID
Thread
[OASIS Issue Tracker] (OFFICE-4113) CLONE - Public Comment: [ODF 1.2] Comment missing, whether error values are propagated
[ https://issues.oasis-open.org/browse/OFFICE-4113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Regina Henschel updated OFFICE-4113:
------------------------------------
    Proposal: 
In section 6.13.6 COUNT replace
 Errors are not propagated.
with
 This function does _not_ propagate Error values.

In section 6.13.7 COUNTA replace
 Errors contained in a range are considered a non-blank value for purposes of the count; errors do not propagate. Constant expressions or formulas are allowed; these are evaluated and if they produce an Error value the Error value is counted as one non-blank value (and not propagated as an Error).
with
 Errors contained in a range are considered a non-blank value for purposes of the count. Constant expressions or formulas are allowed; these are evaluated and if they produce an Error value the Error value is counted as one non-blank value. This function does _not_ propagate Error values.

In section 6.13.11 ERROR.TYPE replace
 Note that unlike most functions, this function does not propagate Error values.
with
 This function does _not_ propagate Error values.

In section 6.13.12 FORMULA replace
 Error results of the referred formula cell are not propagated.
with
 This function does _not_ propagate Error values.

In section 6.13.15 ISERR, section 6.13.16 ISERROR replace
 Note that this function does not propagate Error values.
with
 This function does _not_ propagate Error values.

> CLONE - Public Comment: [ODF 1.2] Comment missing, whether error values are propagated
> --------------------------------------------------------------------------------------
>
>                 Key: OFFICE-4113
>                 URL: https://issues.oasis-open.org/browse/OFFICE-4113
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Robert Weir 
>            Priority: Minor
>             Fix For: ODF 1.4
>
>
> Copied from office-comment list
> Original author: Regina Henschel <> 
> Original date: 2 Jul 2011 23:33:54 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/201107/msg00001.html



--
This message was sent by Atlassian Jira
(v8.3.3#803004)