Front-ends may lack representation for some of KeyValue's basic types: number, text, boolean and date. In that case lexical conversions are required. For instance, OpenOffice Calc and Excel do not have specific representations for time. Instead, they use a double which represents the number of days since a certain epoch. Therefore, the front-end must convert from double to KeyValue's representation of time.
Moreover, lexical conversions can make user interface more
friendly. For instance, OpenOffice Calc and Excel users might prefer to
use "Yes
" and "No
" rather than the built-in
boolean values (TRUE
and FALSE
).
Front-ends must implement all lexical converters they need. The
lexical conversion cited above (from text to boolean values) is, indeed,
implemented for OpenOffice and Excel add-ins. Instead of
TRUE
and FALSE
we can use any of the following
strings:
"TRUE
", "True
",
"true
", "YES
", "Yes
",
"yes
", "Y
", "y
"; or
"FALSE
", "False
",
"false
", "NO
", "No
",
"no
", "N
", "n
".
Additionally, OpenOffice and Excel add-ins implement lexical
conversions from text to number, that is, providing the text
"1.23
" when a number is required is the same as providing
the number 1.23.