[OASIS Issue Tracker] Updated: (OFFICE-2381) 4.10.5 Automatic Range- corresponding/respectively?

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ http://tools.oasis-open.org/issues/browse/OFFICE-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-2381:
--------------------------------

             Proposal: 
In 4.10.5 Automatic Range
Replace
"
The range is generated from the corresponding column respectively row intersecting an area directly below respectively right of the label cell that is constructed by encompassing contiguous cells. A blank cell interrupts contiguousness, one blank cell directly below respectively right of the label cell is ignored.
"
with
"
The range is generated from the column below a column label, or the row right of a row label, constructed by encompassing contiguous non-empty cells. An empty cell interrupts contiguousness, one empty cell directly below a column label cell or right of a row label cell is ignored.
"

In the Comments column of the examples replace all "blank cell" with "empty cell".

        Fix Version/s: ODF 1.2
    Affects Version/s: ODF 1.2 Part 2 CD 3
             Assignee: Eike Rathke

Trying to answer Patrick's questions:

1) I don't understand the question.. a column label is a label for a column of data, a row label is a label for a row of data. Labels don't "attach to cells in line".

2) The dynamic range (cell rectangle) stops at the blank cell, further data in a column (for column labels) or row (for row labels) after a blank cell is not part of the range.

3) The intersection language is confusing. How about "The range is generated from the column below a column label, or the row right of a row label, constructed by encompassing contiguous non-empty cells. An empty cell interrupts contiguousness, one empty cell directly below a column label cell or right of a row label cell is ignored." Note to talk of empty cells instead of blank cells, also in the example comments.

4) Yes, row 1, column Data is the label cell. I hope how the cell in row 2 qualifies as empty cell is clarified with the reformulation given in #3.

Yes, I think we need the examples to illustrate this.


> 4.10.5 Automatic Range - corresponding/respectively? 
> -----------------------------------------------------
>
>                 Key: OFFICE-2381
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2381
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 3
>            Reporter: Patrick Durusau
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2
>
>
> Under 4.10.5 we say:
> "The range is generated from the corresponding column respectively row intersecting an area directly below respectively right of the label cell that is constructed by encompassing contiguous cells. A blank cell interrupts contiguousness, one blank cell directly below respectively right of the label cell is ignored."
> Four questions:
> 1) Is the intent of this statement that a contiguous range of cells is selected and as each value for a column/row is passed, the column/row label attaches to the next cell in line. Yes?
> 2) What happens if there is a blank cell that interrupts contiguousness? 
> 3) Can anyone suggest a re-writing of this that doesn't use "corresponding" and "respectively"? 
> 4) Looking at the examples, how does the blank cell in row 2 qualify as "one black cell below respectively right of the label cell"? I am assuming that row 1, column Data is the label cell. 
> Do we need these examples? For that matter are they consistent with the text? 

-- 
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