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

[spreadsheet] Proposal: extended conditional formatting

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: ODF-Next
    • Labels:
      None
    • Environment:

      This is an enhancement, described in terms of changes to OpenDocument-v1.2

    • Proposal:
      Hide

      1. RATIONALE
      1.1 Use cases:
      Users want to use more powerful conditional formatting, that is also global to a certain cell range
      1.2 Alternatives considered:
      None.

      2. REQUESTED CHANGES TO THE ODF STANDARD

      Add a new concept to ODF that stores conditional formats inside the table:table element and deprecate the old way to store conditional formats.

      Show
      1. RATIONALE 1.1 Use cases: Users want to use more powerful conditional formatting, that is also global to a certain cell range 1.2 Alternatives considered: None. 2. REQUESTED CHANGES TO THE ODF STANDARD Add a new concept to ODF that stores conditional formats inside the table:table element and deprecate the old way to store conditional formats.

      Description

      Extend ODF in such a way, that other spreadsheet formats' support for color scales, data bars and a bigger set of conditional formats like "Duplicate", "Unique", etc. becomes possible.

      The current storage of conditional formats as part of cell styles in ODF does not easily allow to extend the existing elements to support these concepts. ODF can't deal with conditional formats that are not only local to the assigned cell but depend on the values of the whole cell range. This makes it difficult or impossible to support the above mentioned conditional formats within the existing style information.

      The new proposal has the following additional features:

      • color scales
      • data bars
      • a way to express the range of a conditional format
      • a simple and easy way to add new conditional formats types without changing the representation in the file format again

        Attachments

          Activity

            People

            • Assignee:
              timar Andras Timar (Inactive)
              Reporter:
              tbehrens Thorsten Behrens (Inactive)
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: