[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: RE: [oic] TIME function in ODF vs OOXML
That may be old. There is an ISO/IEC AMD that does a lot about dates and time and the transition versus "pure" case. I've seen it but I don't recall whether TIME is touched. I do know that examples have been touched and that might apply here. -----Original Message----- From: oic@lists.oasis-open.org [mailto:oic@lists.oasis-open.org] On Behalf Of Hanssens Bart Sent: Tuesday, May 22, 2012 01:25 To: oic@lists.oasis-open.org Subject: [oic] TIME function in ODF vs OOXML Hi, Interesting, but nasty issue for implementers * ODF 1.2, Part 2 6.10.17 TIME: ((hours*60*60) + (minutes*60) + seconds) / (24*60*60) * ECMA 376, 3rd Edition, Part 1 18.7.7.323 TIME: TIME(26,120,240) results in a serial value of 0.169444444... So if I read this correctly, TIME(48;0;0) in ODF has a serial value of 2, while in OOXML the value is 0 Best regards Bart --------------------------------------------------------------------- To unsubscribe, e-mail: oic-unsubscribe@lists.oasis-open.org For additional commands, e-mail: oic-help@lists.oasis-open.org
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]