[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [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 ]
Francis Cave updated OFFICE-4113:
---------------------------------
Resolution:
DRAFT RESOLUTION:
h3. 6.13.6 COUNT
*Summary:* Count the number of Numbers provided.
*Syntax:* COUNT( { {color:#5c2d91}_NumberSequenceList_{color} {color:#610506}_*N*_{color} }^+^ )
*Returns:*{color:#5c2d91} _Number_{color}
*Constraints:* One or more parameters.
*Semantics:* Counts the numbers in the list {color:#610506}_*N*_{color}. Only numbers in references are counted; all other types are ignored. -Errors are *not* propagated.- This function does _not_ propagate Error values. It is implementation-defined what happens if 0 parameters are passed, but it should be an Error or 0.
*See also* COUNTA 6.13.7
h3. 6.13.7 COUNTA
*Summary:* Count the number of non-empty values.
*Syntax:* COUNTA( { {color:#5c2d91}_Any_{color} {color:#610506}_*AnyValue*_{color} }^+^ )
*Returns:*{color:#5c2d91} _Number_{color}
*Constraints:* None.
*Semantics:* Counts the number of non-blank values. A value is non-blank if it contains any content of any type, including an Error. In a reference, every cell that is not empty is included in the count. An empty string value ("") is _not_ considered blank. 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)- . This function does not propagate Error values. It is implementation-defined what happens if 0 parameters are passed, but it should be an Error or 0.
*See also* COUNT 6.13.6, ISBLANK 6.13.14
h3. 6.13.11 ERROR.TYPE
*Summary:* Returns Number representing the specific Error type.
*Syntax:* ERROR.TYPE( {color:#5c2d91}_Error_{color} {color:#610506}_*E*_{color} )
*Returns:*{color:#5c2d91} _Number_{color}
*Constraints:* None.
*Semantics:* Returns a number representing what kind of Error has occurred. -Note that unlike most functions,- This function does _not_ propagate Error values. Receiving a _non_-Error value returns an Error. In particular, ERROR.TYPE(NA()) returns 7, and ERROR.TYPE applied to a non-Error returns an Error.
*See also* NA 6.13.27
h3. 6.13.12 FORMULA
*Summary:* Returns formula at given reference as text.
*Syntax:* FORMULA( {color:#5c2d91}_Reference_{color} {color:#610506}_*X*_{color} )
*Returns:*{color:#5c2d91} _String_{color}
*Constraints:* Reference {color:#610506}_*X*_{color} shall contain a formula.
*Semantics:* Returns the formula in reference {color:#610506}_*X*_{color} as a string. The specific syntax of this returned string is implementation-defined. This function is intended to aid debugging by simplifying display of formulas in other cells. -Error results of the referred formula cell are not propagated.- This function does _not_ propagate Error values.
*See also* ISFORMULA 6.13.18
h3. 6.13.15 ISERR
*Summary:* Return TRUE if the parameter has type Error and is not #N/A, else return FALSE.
*Syntax:* ISERR( {color:#5c2d91}_Scalar_{color} {color:#610506}_*X*_{color} )
*Returns:*{color:#5c2d91} _Logical_{color}
*Constraints:* None
*Semantics:* If {color:#610506}_*X*_{color} is of type Error, and ISNA({color:#610506}_*X*_{color}) is not true, returns TRUE. Otherwise it returns FALSE. Note that this function returns FALSE if given #N/A; if this is not desired, use ISERROR 6.13.16. -Note that- This function does _not_ propagate Error values.
ISERR({color:#610506}_*X*_{color}) is the same as:
IF(ISNA({color:#610506}_*X*_{color}),FALSE(),ISERROR({color:#610506}_*X*_{color}))
*See also* ERROR.TYPE 6.13.11, ISERROR 6.13.16, ISNA 6.13.20, ISNUMBER 6.13.22, ISTEXT 6.13.25, NA 6.13.27
h3. 6.13.16 ISERROR
*Summary:* Return TRUE if the parameter has type Error, else return FALSE.
*Syntax:* ISERROR( {color:#5c2d91}_Scalar_{color} {color:#610506}_*X*_{color} )
*Returns:*{color:#5c2d91} _Logical_{color}
*Constraints:* None
*Semantics:* If {color:#610506}_*X*_{color} is of type Error, returns TRUE, else returns FALSE. Note that this function returns TRUE if given #N/A; if this is not desired, use ISERR 6.13.15. -Note that- This function does _not_ propagate Error values.
*See also* ERROR.TYPE 6.13.11, ISERR 6.13.15, ISNA 6.13.20, ISNUMBER 6.13.22, ISTEXT 6.13.25, NA 6.13.27
Â
> 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 <rb.henschel@t-online.de>
> 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)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]