[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-2334) Reference -Rewording needed
[ http://tools.oasis-open.org/issues/browse/OFFICE-2334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18338#action_18338 ]
Dennis Hamilton commented on OFFICE-2334:
-----------------------------------------
I don't see anything in the commentary here that suggests there was alignment on a resolution. How could this be Fixed and Applied?
The cuboid is lost completely, but the syntax for references clearly allows cuboids.
To leave "range" as by definition without defining it is particularly strange.
It looks to me like there are the following cases based on the syntax. One could define them in conjunction with the syntax and then deal with what can be produced using the range operator.
Here are the cases from reference syntax alone:
When the reference has a single cell coordinate, the range consists of that individual cell.
When the reference has two column references, the range consists of those columns and the columns, if any, between them, on each sheet referenced and the sheets between them, if any. (Special cases include single columns and single sheets.)
When the reference has two row references, the range consists of those rows and the rows, if any between them, on each sheet reference and the sheets between them, if any. (Special cases include single rows and single sheets.)
When the reference provides two cell coordinates, the range consists of the smallest rectangle of cells that includes the cells with those coordinates as corners on each sheet referenced and the sheets between them, if any. (Special cases include single sheets, single cells, and single strips of cells in single columns or single rows.
We can now see how the range operator makes a new range. Each operand already determines a cuboid (sometimes involving complete rows or complete columns). Consider the two ranges together. If one cuboid is entirely contained in the other, the result is the containing cuboid. When that is not the case, find the smallest cuboid that contains both of the operand cuboids. This is a uniquelly-defined operation except when one or both of the operand cuboids contains complete rows or complete columns.
Although the complete rows and completed columns cases have not been singled out, there are consistent definitions of the consequences: If there are complete rows in either range, the result must have all complete rows. If there are complete columns in either range, the result must have all complete columns. (Special cases include when there are complete rows and complete columns, making it necessary for the cuboid to consist of the complete sheets that are included in the two ranges and the complete sheets, if any, that are between those.)
The rules above honor the requirement that the result is always a cuboid, that every cell in the range of either operand is included, and removal of any cells would violate one of the previous two conditions.
This needs to be worked out between CD01 sections 3.8, 4.8, and 5.4.11.
> Reference - Rewording needed
> ----------------------------
>
> Key: OFFICE-2334
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2334
> 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
> Assignee: Andreas Guelzow
> Fix For: ODF 1.2 Part 2 CD 1
>
>
> Reference currently reads:
> "A reference refers to a cuboid of cells called a range. A special case is a single cell reference, a reference to a single cell."
> Rather:
> "A reference specifies a contiguous set of one or more cells. Such as set of cells may be referred to as a range."
> I am assuming that "cuboid" was used to indicate that a reference can refer only to a contiguous range of cells.
--
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]