-
Type: Bug
-
Status: Closed
-
Priority: Minor
-
Resolution: Unresolved
-
Affects Version/s: ODF 1.2
-
Fix Version/s: ODF-Next
-
Component/s: OpenFormula, Part 4 (Formula) [1.2: 2]
-
Labels:None
-
Proposal:
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.