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

ODF 1.2 CD05 Part 2 6.13.3 CELL Assumptions Too Host-Dependent

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      1. Determine what the overall policy is for the way host-dependent provisions are to be handled interoperably for this function (and perhaps for this section).

      2. Break this issue into subtasks for resolving the individual cases that arise for this particular composite function.

      Show
      1. Determine what the overall policy is for the way host-dependent provisions are to be handled interoperably for this function (and perhaps for this section). 2. Break this issue into subtasks for resolving the individual cases that arise for this particular composite function.

      Description

      The CELL function is currently defined with far too man host-dependent characteristics.

      1. CELL("SHEET") It assumes that sheets are numbered, without further explanation. (This applies for a great variety of the functions in secction 6.13.)

      2. The determination of CELL("ADDRESS") is underspecified with regard to sheet and if the current cell is being referenced externally.

      3. The determination of CELL("FILENAME") is unclear, especially in the context of packages. This result is apparently always a host-dependent behavior, but it is not clear what is the desired interoperable case were the CELL("FILENAME") used as an IRI Reference, and in what context. What guidance is there for what value should be provided here and what an user could rely on it for. Is an IRI always returned, rather than an IRI Reference, for example.

      4. Does the result of CELL("CONTENT") provide a value of the type of the cell, or does it always provide text that can be interpreted as the appropriate type?

      5. Is CELL("FORMAT") intended to be comprehensive? Does "-" mean that the color is in lieu of a minus sign in the formatted value? For the (), see

      6. Is CELL("TYPE") meant to be comprehensive? What about date-type values, currency-type values, and other distinct cell value types that may happen to be supported (Logical, Complex, ... )?

      7. Is CELL("PARENTHESES") related to the use of parentheses to signify NEGATIVE values in accounting information? Why does it say POSITIVE here and under CELL("FORMAT")?

      The note at the bottom does not comprehend all forms of references. There are cuboids and cells whose values are arrays/matrices, yes?

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: