RE: [oic] designed non-interoperability

["Dennis E. Hamilton" <dennis.hamilton@acm.org>]

Why are these comments posted here rather than as bug reports (or even comments on old bug reports) on the Apache OpenOffice Bugzilla?

 - Dennis

-----Original Message-----
From: oic@lists.oasis-open.org [mailto:oic@lists.oasis-open.org] On Behalf Of Andreas J. Guelzow
Sent: Tuesday, May 15, 2012 16:53
To: oic@lists.oasis-open.org
Subject: [oic] designed non-interoperability

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