RE: [oic] designed non-interoperability

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

On Tue, 2012-05-15 at 18:14 -0600, Dennis E. Hamilton wrote:
> Why are these comments posted here rather than as bug reports (or even comments on old bug reports) on the Apache OpenOffice Bugzilla?

In view of the presentation in the release notes, I can't see this as a
bug but as an intentionally designed incompatibility. I have posted
these comments to this list because I would like to talk about this at
our upcoming OIC call (and the next ODF adoption TC call).

Andreas
 
> -----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

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