RE: [oic] designed non-interoperability

[Hanssens Bart <Bart.Hanssens@fedict.be>]

Hi Andreas,

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

Hmz, what version of LibreOffice are you using ?
It seems that LO 3.5.2.2 on Windows behaves differently

I'mwondering what value other spreadsheets return when TIME(),
or similar functions, takes an input value > 24:00:00
(regardless of the file format, so perhaps check Excel, 1-2-3 etc)

It may be that wrapping was introduced for improving compatibility,
although it clearly violates the ODF 1.2 spec...


Best regards

Bart