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

ODF 1.2 CD05-1 19.598: table:condition semantics over-specific

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: Part 1 (Schema), Table
    • Labels:
      None
    • Proposal:
      Hide

      In the first paragraph of section 19.598 table:condition, remove the first two sentences:

      """
      The table:condition attribute specifies the condition that determines whether a cell content is valid in regard to a validation rule or not. A cell content is valid if the condition evaluates to "true".
      """

      Add the following paragraph before the adjusted first paragraph:

      """
      The table:condition attribute specifies a condition that applies to the value of a table cell that references the <table:content-validation> element having the table:condition attribute. When evaluation of the condition results in "false", any action taken is determine by the other attributes and child elements of the <table:content-validation> element. [Note: possible actions include presentation of a message, triggering an event, and performance of a script, with or without invalidating the value. Also, the table:allow-empty-cell attribute value influences whether the table:condition is applicable.]
      """

      At the end of the paragraph that is now the second paragraph, add the following sentence:

      """
      [Note: The value of the <table:content-validation> table:base-cell-address can influence how references are resolved in an *expression* anywhere within the defined conditions.].
      """

      Note: The "expression" means that "expression" should be in italics.

      Show
      In the first paragraph of section 19.598 table:condition, remove the first two sentences: """ The table:condition attribute specifies the condition that determines whether a cell content is valid in regard to a validation rule or not. A cell content is valid if the condition evaluates to "true". """ Add the following paragraph before the adjusted first paragraph: """ The table:condition attribute specifies a condition that applies to the value of a table cell that references the <table:content-validation> element having the table:condition attribute. When evaluation of the condition results in "false", any action taken is determine by the other attributes and child elements of the <table:content-validation> element. [Note: possible actions include presentation of a message, triggering an event, and performance of a script, with or without invalidating the value. Also, the table:allow-empty-cell attribute value influences whether the table:condition is applicable.] """ At the end of the paragraph that is now the second paragraph, add the following sentence: """ [Note: The value of the <table:content-validation> table:base-cell-address can influence how references are resolved in an *expression* anywhere within the defined conditions.] . """ Note: The " expression " means that "expression" should be in italics.
    • Resolution:
      Hide

      In the first paragraph of section 19.598 table:condition, remove the first two sentences:

      """
      The table:condition attribute specifies the condition that determines whether a cell content is valid in regard to a validation rule or not. A cell content is valid if the condition evaluates to "true".
      """

      Add the following paragraph before the adjusted first paragraph:

      """
      The table:condition attribute specifies a condition that applies to the value of a table cell that references the <table:content-validation> element having the table:condition attribute. When evaluation of the condition results in "false", any action taken is determine by the other attributes and child elements of the <table:content-validation> element. [Note: possible actions include presentation of a message, triggering an event, and performance of a script, with or without invalidating the value. Also, the table:allow-empty-cell attribute value influences whether the table:condition is applicable.]
      """

      At the end of the paragraph that is now the second paragraph, add the following sentence:

      """
      [Note: The value of the <table:content-validation> table:base-cell-address can influence how references are resolved in an *expression* anywhere within the defined conditions.].
      """

      Note: The "expression" means that "expression" should be in italics.

      Show
      In the first paragraph of section 19.598 table:condition, remove the first two sentences: """ The table:condition attribute specifies the condition that determines whether a cell content is valid in regard to a validation rule or not. A cell content is valid if the condition evaluates to "true". """ Add the following paragraph before the adjusted first paragraph: """ The table:condition attribute specifies a condition that applies to the value of a table cell that references the <table:content-validation> element having the table:condition attribute. When evaluation of the condition results in "false", any action taken is determine by the other attributes and child elements of the <table:content-validation> element. [Note: possible actions include presentation of a message, triggering an event, and performance of a script, with or without invalidating the value. Also, the table:allow-empty-cell attribute value influences whether the table:condition is applicable.] """ At the end of the paragraph that is now the second paragraph, add the following sentence: """ [Note: The value of the <table:content-validation> table:base-cell-address can influence how references are resolved in an *expression* anywhere within the defined conditions.] . """ Note: The " expression " means that "expression" should be in italics.

      Description

      In ODF 1.2 CD05-1 19.598, the first paragraph begins with these sentences:

      """
      The table:condition attribute specifies the condition that determines whether a cell content is valid in regard to a validation rule or not. A cell content is valid if the condition evaluates to "true".
      """

      This statement is inaccurate and too strict. The condtion can be used for other than the determination of the validity of a table cell's content. According to the definition of the <table:content-validation> there are a variety of ways that the table:condition can be used. In particular, the associated <table:error-message> element can specify that the table:condition produces a warning message or simply an information-only message. Although it is the default to take the table:condition satisfaction as causing an operation to stop, that is not the only case. (And stopping an operation is an odd way to say this, since the operation is the validation.) I suspect the more-correct interpretation of "stop" is to require a different value to be entered for the cell, although that won't always be possible. (E.g., consider a cell whose value is determined by a formula for which the table:condition applies and is satisfied.)

      The initial two sentences need to be softened to admit of other possibilities, including use for purposes other than determining that a value is invalid.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: