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

Part 2 uses "empty cell" and "cell is empty" - normalize on "empty cell"

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      6.3.5 Conversion to Number: (last bullet item, end of paragraph) - "An empty cell returns the value 0.

      Note: Evaluators may choose to convert references to Text in a different manner than they handle converting embedded Text to a Number." [Do we really need this note?]

      6.3.14 Conversion to Text (last bullet item): "Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.14."

      6.3.15 Conversion to DateParam (last bullet item): "Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.15."

      6.3.16 Conversion to TimeParam (last bullet item): "Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.16."

      [This happens in 6.13.8 COUNTBLANK and 6.13.14 ISBLANK but they are too intertwined to fix separately (and they have other issues. I will open a separate JIRA issue on them.]

      [I put in "Number" because the sections in question don't say scalar, they say Number.]

      Show
      6.3.5 Conversion to Number: (last bullet item, end of paragraph) - "An empty cell returns the value 0. Note: Evaluators may choose to convert references to Text in a different manner than they handle converting embedded Text to a Number." [Do we really need this note?] 6.3.14 Conversion to Text (last bullet item): "Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.14." 6.3.15 Conversion to DateParam (last bullet item): "Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.15." 6.3.16 Conversion to TimeParam (last bullet item): "Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.16." [This happens in 6.13.8 COUNTBLANK and 6.13.14 ISBLANK but they are too intertwined to fix separately (and they have other issues. I will open a separate JIRA issue on them.] [I put in "Number" because the sections in question don't say scalar, they say Number.]

      Description

      6.3.5 Conversion to Number: (last bullet item, end of paragraph) - "If the cell is empty (blank), use 0 (zero) as the value. Evaluators may choose to convert references to Text in a different manner than they handle converting embedded Text to a Number."

      6.3.14 Conversion to Text (last bullet item): "Reference: perform conversion to scalar. If the referenced cell is empty, treat as an empty string (a text value with length 0). Then perform as above."

      6.3.15 Conversion to DateParam (last bullet item): "Reference: perform conversion to scalar, then perform as above. If the cell is empty, return 0."

      6.3.16 Conversion to TimeParam (last bullet item): "Reference: perform conversion to scalar, then perform as above. If the cell is empty, return 0."

      This happens in 6.13.8 COUNTBLANK and 6.13.14 ISBLANK but they are too intertwined to fix separately (and they have other issues. I will open a separate JIRA issue on them.

      Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.14.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: