[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]