Affects Version/s: ODF 1.2 CD 05
Fix Version/s: ODF-Next
The CELL function is currently defined with far too man host-dependent characteristics.
1. CELL("SHEET") It assumes that sheets are numbered, without further explanation. (This applies for a great variety of the functions in secction 6.13.)
2. The determination of CELL("ADDRESS") is underspecified with regard to sheet and if the current cell is being referenced externally.
3. The determination of CELL("FILENAME") is unclear, especially in the context of packages. This result is apparently always a host-dependent behavior, but it is not clear what is the desired interoperable case were the CELL("FILENAME") used as an IRI Reference, and in what context. What guidance is there for what value should be provided here and what an user could rely on it for. Is an IRI always returned, rather than an IRI Reference, for example.
4. Does the result of CELL("CONTENT") provide a value of the type of the cell, or does it always provide text that can be interpreted as the appropriate type?
5. Is CELL("FORMAT") intended to be comprehensive? Does "-" mean that the color is in lieu of a minus sign in the formatted value? For the (), see
6. Is CELL("TYPE") meant to be comprehensive? What about date-type values, currency-type values, and other distinct cell value types that may happen to be supported (Logical, Complex, ... )?
7. Is CELL("PARENTHESES") related to the use of parentheses to signify NEGATIVE values in accounting information? Why does it say POSITIVE here and under CELL("FORMAT")?
The note at the bottom does not comprehend all forms of references. There are cuboids and cells whose values are arrays/matrices, yes?