designed non-interoperability

["Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>]

In the Apache OpenOffice release notes it is proudly advertised that:

Spreadsheet: TIME function returns values 00:00:00 <= x <= 23:59:59.999
The TIME spreadsheet function returns values between 00:00:00 and
23:59:59.999... inclusive and wraps values equal to or greater than
24:00:00.

ODF 1.2 part 2 6.10.17 on the other hand states:
-----------------------------------------------------
Syntax: TIME( Number hours ; Number minutes ; Number seconds )
Semantics: Returns the fraction of the day consumed by the given time,
i.e.:
((hours*60*60)+(minutes*60)+seconds)/(24*60*60)

Hours, minutes, and seconds may be any number (they shall not be limited
to the ranges 0..24,0..59, or 0..60 respectively).
-----------------------------------------------------

So TIME(48;0;0) should clearly evaluate to 2.
Gnumeric and LibreOffice evaluate this as 2.

Note that I am not talking about the format that is used to present the
result but the underlying value. Libreoffice shows this value as 48:0:0
and Gnumeric as 00:00, but both have the value underlying as 2 as one
can see by comparing the cell value with 2 or formatting it as a decimal
number.

Andreas


-- 
Andreas J. Guelzow, PhD, FTICA
Concordia University College of Alberta

Attachment: signature.asc
Description: This is a digitally signed message part