[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: RE: [oic] designed non-interoperability
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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]