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] Created: (OFFICE-2370) 3.7 Reference -reference to cell with no value = number 0?

3.7 Reference - reference to cell with no value = number 0?

                 Key: OFFICE-2370
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2370
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: OpenFormula
    Affects Versions: ODF 1.2 Part 2 CD 1
            Reporter: Patrick Durusau

The reference paragraph that I moved to 3.7 Reference reads:

"A reference may refer to a cell that does not contain a value; such a reference refers to an empty (aka blank) cell.  An empty cell is neither zero nor the empty string, and an empty cell can be distinguished from cells containing values (including zero and the empty string) by some functions (such as ISBLANK and COUNTBLANK).  An empty cell is not the same as an Error, in particular, it is distinguishable from the Error #N/A (not available).  As discussed below, in many scalar contexts a reference to an empty cell is converted into 0 or the empty string, and in most sequences empty cells are automatically omitted.  If the outermost expression is a reference to an empty cell, it shall be converted to the number 0."

Is the purpose of this paragraph to say:

"A reference to an empty cell returns the number 0."

Reasoning that the concept of an empty cell should be defined elsewhere. 

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]