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

COUNTBLANK - required to support references as parameters?

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Remove Constraints:
      Implementations shall support references as a parameter, though other types may be supported

      Add to Semantics::
      Evaluators shall support one reference as a parameter and may support a ReferenceList as a parameter.

      Show
      Remove Constraints: Implementations shall support references as a parameter, though other types may be supported Add to Semantics:: Evaluators shall support one reference as a parameter and may support a ReferenceList as a parameter.
    • Resolution:
      Hide

      Changed Constraints to None.

      Added to Semantics:
      Evaluators shall support one Reference as a parameter and may support a ReferenceList as a parameter.

      Show
      Changed Constraints to None. Added to Semantics: Evaluators shall support one Reference as a parameter and may support a ReferenceList as a parameter.

      Description

      Constraints on COUNTBLANK reports: "Implementations are only REQUIRED to support references as a parameter, though other types may be supported."

      Seems like an odd place for such an announcement, form (shall), etc.

      ReferenceList is may be a value for VARPA, VARA, STDEVPA, STDEVA, MINA, MAXA, AVERAGEA, SUMIF, INDEX, ISREF, COUNTIF, COUNTA, AREAS (to support AREAS at all it looks like ReferenceList has to be supported), infix concatenation operator, Conversion to NumberSequenceList.

      The reference under COUNTBLANK maybe a local constraint but it looks like ReferenceList needs to be defined and the meaning of "may be" under the various functions clarified, plus the usual conformance issues.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              Patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: