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

table:name <table:operation> 18.675.11

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.0, ODF 1.0 (second edition), ODF 1.0 Errata 02, ODF 1.1, ODF 1.2
    • Fix Version/s: ODF 1.2
    • Component/s: Part 3 (Schema) [1.2: 1], Table
    • Labels:
      None
    • Proposal:
      Hide

      remove-dependents: removes highlighting from cells that use the value of the current cell in their formula.
      remove-precedents: removes highlighting from cells whose values are use in the formula of the current cell.
      trace-dependents: highlights cells that use the value of the current cell in their formula.
      trace-errors: highlights cells that cause an error while calculating the result of the current cell's formula.
      trace-precedents: highlights cells whose values are use in the formula of the current cell.

      The nature of the highlighting imposed or removed from cells as the result of detective operations is implementation defined.

      Show
      remove-dependents: removes highlighting from cells that use the value of the current cell in their formula. remove-precedents: removes highlighting from cells whose values are use in the formula of the current cell. trace-dependents: highlights cells that use the value of the current cell in their formula. trace-errors: highlights cells that cause an error while calculating the result of the current cell's formula. trace-precedents: highlights cells whose values are use in the formula of the current cell. The nature of the highlighting imposed or removed from cells as the result of detective operations is implementation defined.
    • Resolution:
      Hide

      remove-dependents: removes highlighting from cells that use the value of the current cell in their formula.
      remove-precedents: removes highlighting from cells whose values are use in the formula of the current cell.
      trace-dependents: highlights cells that use the value of the current cell in their formula.
      trace-errors: highlights cells that cause an error while calculating the result of the current cell's formula.
      trace-precedents: highlights cells whose values are use in the formula of the current cell.

      The nature of the highlighting imposed or removed from cells as the result of detective operations is implementation defined.

      Show
      remove-dependents: removes highlighting from cells that use the value of the current cell in their formula. remove-precedents: removes highlighting from cells whose values are use in the formula of the current cell. trace-dependents: highlights cells that use the value of the current cell in their formula. trace-errors: highlights cells that cause an error while calculating the result of the current cell's formula. trace-precedents: highlights cells whose values are use in the formula of the current cell. The nature of the highlighting imposed or removed from cells as the result of detective operations is implementation defined.

      Description

      In prior versions we speak of "hiding" or making "visible" cells as the result of detective operations.

      That is incorrect.

      A detective operation determines if the value of a cell, for example, is used in the calculation of the result displayed in another cell and "highlights" the cells involved to show that relationship.

      However, we never defined what was meant by "highlighting" and it certainly did not mean hiding or making cells visible.

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Durusau
              Reporter:
              patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: