[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-2022) Section 5.8(References) doesn't explicitly state how 3D range references handle sheetspositioned between the worksheets named in the reference
[ http://tools.oasis-open.org/issues/browse/OFFICE-2022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eike Rathke updated OFFICE-2022:
--------------------------------
Resolution:
Change section 6.3.10 Infix Operator Reference Range (":") from
"Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right."
to
"Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right including the cells on sheets positioned between Left and Right."
Section 4.6 Reference says: "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."
Section 6.3.10 Infix Operator Reference Range (":") says: "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right."
A cuboid naturally includes the cells of the sheets between the sheets given by Left and Right. However, added clarification as lined out in the Resolution field.
Section 5.8 References defines the syntax, we should not add semantics there.
> Section 5.8 (References) doesn't explicitly state how 3D range references handle sheets positioned between the worksheets named in the reference
> ------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OFFICE-2022
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2022
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Affects Versions: ODF 1.2
> Reporter: Eric Patterson
> Assignee: Eike Rathke
> Fix For: ODF 1.2
>
>
> Given a reference of the form: =SUM(['Sheet1'.B4:'Sheet2'.C5]), the current draft doesn't state that sheets positioned in the workbook between Sheet1 and Sheet2 should also be included in the range.
> 6.3.10 Infix Operator Reference Range (":") says: "Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right."
--
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]