-
Type: Improvement
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: ODF 1.2
-
Fix Version/s: ODF-Later
-
Component/s: OpenFormula, Part 4 (Formula) [1.2: 2]
-
Labels:None
-
Proposal:
The terminology "Empty Cell" in the specification creates semantic confusion because we also find the empty string of type Text. The term makes parts of the specification ambigious and unintuitive to read, for instance (cmp. OFFICE-3764) in 4.11.8 "For =, if the value is empty it matches empty cells."
The definition in 4.7 reads "Empty Cell - An empty cell is neither zero nor the empty string, and an empty cell can be distinguished from cells containing values (including zero and the empty string). An empty cell is not the same as an Error, in particular, it is distinguishable from the Error #N/A (not available)."