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

ODF 1.2 CD05 Part 2 - Syntax for Named Range not Identified

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      From section 4.11.8 Database, remove the two paragraphs
      "
      Evaluators supporting databases and named ranges shall support the use of named ranges as a range, and the use of a Text value as a database (which, if it matches the name of a named range, will be considered the named range).
      Note: It is considered good practice to define a named range for a database because it eases maintenance (the range can be changed for all functions by changing just one definition). However, the use of named ranges for a database is not required by this specification.
      "

      Show
      From section 4.11.8 Database, remove the two paragraphs " Evaluators supporting databases and named ranges shall support the use of named ranges as a range, and the use of a Text value as a database (which, if it matches the name of a named range, will be considered the named range). Note: It is considered good practice to define a named range for a database because it eases maintenance (the range can be changed for all functions by changing just one definition). However, the use of named ranges for a database is not required by this specification. "
    • Resolution:
      Hide

      From section 4.11.8 Database, remove the two paragraphs
      "
      Evaluators supporting databases and named ranges shall support the use of named ranges as a range, and the use of a Text value as a database (which, if it matches the name of a named range, will be considered the named range).
      Note: It is considered good practice to define a named range for a database because it eases maintenance (the range can be changed for all functions by changing just one definition). However, the use of named ranges for a database is not required by this specification.
      "

      Show
      From section 4.11.8 Database, remove the two paragraphs " Evaluators supporting databases and named ranges shall support the use of named ranges as a range, and the use of a Text value as a database (which, if it matches the name of a named range, will be considered the named range). Note: It is considered good practice to define a named range for a database because it eases maintenance (the range can be changed for all functions by changing just one definition). However, the use of named ranges for a database is not required by this specification. "

      Description

      In ODF 1.2 CD05 Part 2, the term "named range" is used in many places.

      We believe, in conjunction with OFFICE-3446, that this is a job for HOST-REFERENCE-RESOLVER.

      However, there is nowhere in the description of OpenFormula expressions where any construct is identified as being a mention of a named range.

      Is this intended to be a case of named-expression? This may create limitations on where a named range can be referenced. It would seem that a named-range reference could be anywhere that a Reference can be.

      This needs to be resolved explicitly.

        Attachments

          Activity

            People

            • Assignee:
              orcmid Dennis Hamilton (Inactive)
              Reporter:
              orcmid Dennis Hamilton (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: