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] Updated: (OFFICE-2381) 4.10.5 Automatic Range- corresponding/respectively?



     [ 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
"
When passed as a non-scalar argument (e.g. Array or NumberSequence) to a function, a column or row label is converted to an automatic range reference that is adjusted each time the formula is interpreted. 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
"
When passed as a non-scalar argument (e.g. Array or NumberSequence) to a function, an automatically looked up column or row label  (not defined label range) is converted to an automatic range reference that is adjusted each time the formula is interpreted. 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".

To   4.10.3 Automatic Lookup of Labels   add
Note: Document authors should be aware that using automatically looked up column or row labels in expressions impairs interoperability.


  was:
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".



The dynamic range generation applies only to automatically looked up labels, not to defined label ranges. Also add a note that use of Automatic Lookup of Labels impairs interoperability.

> 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

        


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]