[OASIS Issue Tracker] (OFFICE-3787) Part 2 uses "empty cell" and "cell is empty" - normalize on "empty cell"

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ https://issues.oasis-open.org/browse/OFFICE-3787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Regina Henschel updated OFFICE-3787:
------------------------------------
    Fix Version/s: ODF-Next
                       (was: ODF 1.3)

> Part 2 uses "empty cell" and "cell is empty" - normalize on "empty cell"
> ------------------------------------------------------------------------
>
>                 Key: OFFICE-3787
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3787
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2
>            Reporter: Patrick Durusau
>            Assignee: Patrick Durusau
>            Priority: Minor
>             Fix For: ODF-Next
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.7.2#77003)