[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-4001) CLONE - Public Comment: [ODF 1.2] Comment missing, whether error values are propagated
[ https://issues.oasis-open.org/browse/OFFICE-4001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis Cave updated OFFICE-4001:
---------------------------------
Proposal:
Summary of changes to the final sentence of the Semantics description field in 6.13.14 ISBLANK, 6.13.18 ISFORMULA, 6.13.19 ISLOGICAL, 6.13.21 ISNONTEXT, 6.13.22 ISNUMBER, 6.13.24 ISREF, 6.13.25 ISTEXT:
# -Ensured that sentence starts consistently with the words "Note that...".- \[Dropped this change for consistency with resolution of OFFICE-4113\]
# Added the words "..., but returns FALSE in such cases" at the end of the sentence in functions ISBLANK, ISLOGICAL, ISNUMBER and ISTEXT.
# Added the words "..., but returns TRUE in such cases" at the end of the sentence in function ISNONTEXT.
h3. 6.13.14 ISBLANK
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Number, Text, or Logical, return FALSE. If {color:#610506}_*X*_{color} is a reference to a cell, examine the cell; if it is blank (has no value), return TRUE, but if it has a value, return FALSE. A cell with the empty string is _not_ considered blank. This function does _not_ propagate Error values, but returns FALSE in such cases.
h3. 6.13.18 ISFORMULA
...
*Semantics:* If {color:#610506}_*X*_{color} refers to a cell whose value is computed by a formula, return TRUE, else return FALSE. A formula itself may compute a constant; in that case it will still return TRUE since it is still a formula. Passing a non-reference, or a reference to more than one cell, is implementation-defined. This function does _not_ propagate Error values.
h3. 6.13.19 ISLOGICAL
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Logical, returns TRUE, else FALSE. Evaluators that do not have a distinct Logical type will return the same value ISNUMBER({color:#610506}_*X*_{color}) would return. This function does _not_ propagate Error values, but returns FALSE in such cases.
h3. 6.13.21 ISNONTEXT
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Text, ISNONTEXT returns FALSE, else TRUE. If {color:#610506}_*X*_{color} is a reference, it examines what {color:#610506}_*X*_{color} references. References to empty cells are not considered text, so for reference to an empty cell ISNONTEXT will return TRUE. Empty Cell 4.7. This function does _not_ propagate Error values, but returns TRUE in such cases.
h3. 6.13.22 ISNUMBER
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Number, returns TRUE, else FALSE. {color:#000000}Evaluators{color} need not have a distinguished Logical type; in such evaluators, ISNUMBER(TRUE()) is TRUE. This function does _not_ propagate Error values, but returns FALSE in such cases.
h3. 6.13.24 ISREF
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Reference or ReferenceList, return TRUE, else return FALSE. Note that unlike nearly all other functions, when given a reference this function does _not_ then examine the value being referenced. Some functions and operators return references, and thus ISREF will return TRUE when given their results. {color:#610506}_*X*_{color} may be a ReferenceList, in which case ISREF returns TRUE. This function does _not_ propagate Error values.
h3. 6.13.25 ISTEXT
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Text, returns TRUE, else FALSE. References to empty cells are NOT considered Text. If {color:#610506}_*X*_{color} is a reference, examines what {color:#610506}_*X*_{color} references. References to empty cells are NOT considered Text, so a reference to an empty cell will return FALSE. Empty Cell 4.7 This function does _not_ propagate Error values, but returns FALSE in such cases.
Resolution: (was: Summary of changes to the final sentence of the Semantics description field in 6.13.14 ISBLANK, 6.13.18 ISFORMULA, 6.13.19 ISLOGICAL, 6.13.21 ISNONTEXT, 6.13.22 ISNUMBER, 6.13.24 ISREF, 6.13.25 ISTEXT:
# Ensured that sentence starts consistently with the words "Note that...".
# Added the words "..., but returns FALSE in such cases" at the end of the sentence in functions ISBLANK, ISLOGICAL, ISNUMBER and ISTEXT.
# Added the words "..., but returns TRUE in such cases" at the end of the sentence in function ISNONTEXT.
h3. 6.13.14 ISBLANK
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Number, Text, or Logical, return FALSE. If {color:#610506}_*X*_{color} is a reference to a cell, examine the cell; if it is blank (has no value), return TRUE, but if it has a value, return FALSE. A cell with the empty string is _not_ considered blank. Note that this function does _not_ propagate Error values, but returns FALSE in such cases.
h3. 6.13.18 ISFORMULA
...
*Semantics:* If {color:#610506}_*X*_{color} refers to a cell whose value is computed by a formula, return TRUE, else return FALSE. A formula itself may compute a constant; in that case it will still return TRUE since it is still a formula. Passing a non-reference, or a reference to more than one cell, is implementation-defined. Note that this function does _not_ propagate Error values.
h3. 6.13.19 ISLOGICAL
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Logical, returns TRUE, else FALSE. Evaluators that do not have a distinct Logical type will return the same value ISNUMBER({color:#610506}_*X*_{color}) would return. Note that this function does _not_ propagate Error values, but returns FALSE in such cases.
h3. 6.13.21 ISNONTEXT
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Text, ISNONTEXT returns FALSE, else TRUE. If {color:#610506}_*X*_{color} is a reference, it examines what {color:#610506}_*X*_{color} references. References to empty cells are not considered text, so for reference to an empty cell ISNONTEXT will return TRUE. Empty Cell 4.7 Note that this function does _not_ propagate Error values, but returns TRUE in such cases.
h3. 6.13.22 ISNUMBER
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Number, returns TRUE, else FALSE. {color:#000000}Evaluators{color} need not have a distinguished Logical type; in such evaluators, ISNUMBER(TRUE()) is TRUE. Note that this function does _not_ propagate Error values, but returns FALSE in such cases.
h3. 6.13.24 ISREF
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Reference or ReferenceList, return TRUE, else return FALSE. Note that unlike nearly all other functions, when given a reference this function does _not_ then examine the value being referenced. Some functions and operators return references, and thus ISREF will return TRUE when given their results. {color:#610506}_*X*_{color} may be a ReferenceList, in which case ISREF returns TRUE. Note that this function does _not_ propagate Error values.
h3. 6.13.25 ISTEXT
...
*Semantics:* If {color:#610506}_*X*_{color} is of type Text, returns TRUE, else FALSE. References to empty cells are NOT considered Text. If {color:#610506}_*X*_{color} is a reference, examines what {color:#610506}_*X*_{color} references. References to empty cells are NOT considered Text, so a reference to an empty cell will return FALSE. Empty Cell 4.7 Note that this function does _not_ propagate Error values, but returns FALSE in such cases.)
> CLONE - Public Comment: [ODF 1.2] Comment missing, whether error values are propagated
> --------------------------------------------------------------------------------------
>
> Key: OFFICE-4001
> URL: https://issues.oasis-open.org/browse/OFFICE-4001
> 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]