Hi Richard,
On Sun, May 28, 2006 at 00:11:47 +0100, Richard Kernick wrote:
> MUST save with explicit conversions. So
> file format has =VALUEL("3.5"; "GB")+3 and the UI can display to the user
> ="3.5"+3, because it does A. Another implementation may display
> =VALUE("3.5")+3, because it doesn't. But they must save back to
> =VALUEL("3.5"; "GB")+3.
Nice approach, though I think such automatisms sooner or later fail. It
already fails when a document was created in a CJK locale using
fullwidth digits, and the application loading it doesn't support
transliteration from fullwidth to halfwidth/ascii.
Eike
--
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommitee's list.
