Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-1508

Named relative cell ranges

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Applied
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2
    • Fix Version/s: ODF 1.2
    • Component/s: Table
    • Labels:
      None
    • Proposal:
      Hide

      Andreas:
      I propose that the sentence:

      "If the expression contains a relative cell range address, a table:base-cell-address attribute must also appear on the <table:named-expression> element." is to be deleted from 17.638.

      Eike:
      Do not remove the sentence. Instead, add
      "Implementations shall determine the offsets of a relative cell range address relative to the table:base-cell-address."

      Show
      Andreas: I propose that the sentence: "If the expression contains a relative cell range address, a table:base-cell-address attribute must also appear on the <table:named-expression> element." is to be deleted from 17.638. Eike: Do not remove the sentence. Instead, add "Implementations shall determine the offsets of a relative cell range address relative to the table:base-cell-address."
    • Resolution:
      Hide

      18.638 table:expression

      Add: Relative cell range addresses that occur in the condition define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute.

      Added: Relative cell range addresses that occur in an expression define an offset which shall be interpreted relative to the cell where a named expression is used. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute.

      18.599 table:condition

      Add: Relative cell range addresses that occur in the condition define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute.

      Added: Relative cell range addresses that occur in a condition define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute.

      18.596.7 <table:named-range>

      Add: If the cell range address is relative, the table:base-cell-address attribute shall exist additionally. *A relative cell address define an offset which shall be interpreted relative to the cell where the named range is used. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute.

      Added: If the cell range address is relative, the table:base-cell-address attribute shall exist additionally. A relative cell address defines an offset which shall be interpreted relative to the cell where the named range is used. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute.

      18.471 style:condition

      Add: Relative cell range addresses that occur in the condition for a table cell style define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the style:base-cell-address attribute.

      Added: Relative cell range addresses that occur in a condition for a table cell style define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the style:base-cell-address attribute.

      Show
      18.638 table:expression Add: Relative cell range addresses that occur in the condition define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute. Added: Relative cell range addresses that occur in an expression define an offset which shall be interpreted relative to the cell where a named expression is used. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute. 18.599 table:condition Add: Relative cell range addresses that occur in the condition define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute. Added: Relative cell range addresses that occur in a condition define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute. 18.596.7 <table:named-range> Add: If the cell range address is relative, the table:base-cell-address attribute shall exist additionally. *A relative cell address define an offset which shall be interpreted relative to the cell where the named range is used. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute. Added: If the cell range address is relative, the table:base-cell-address attribute shall exist additionally. A relative cell address defines an offset which shall be interpreted relative to the cell where the named range is used. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the table:base-cell-address attribute. 18.471 style:condition Add: Relative cell range addresses that occur in the condition for a table cell style define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the style:base-cell-address attribute. Added: Relative cell range addresses that occur in a condition for a table cell style define an offset which shall be interpreted relative to the cell for which a condition is calculated. The offset equals the offsets between the table cell addressed by the relative cell range address and the table cell specified by the style:base-cell-address attribute.

      Description

      17.638 currently contains the paragraph:

      If the expression contains a relative cell range address, a table:base-cell-address attribute must also appear on the <table:named-expression> element.

      The spreadsheet program Gnumeric allows for named ranges that are interpreted relative. This is useful for situations were one wants to write many similar formulas that for example refer to a certain number of cells to the top right.

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Durusau
              Reporter:
              aguelzow Andreas Guelzow (Inactive)
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: