RE: problem with interpreting OpenFormula format in ODF1.2

2015-05-29 Thread Winfried Donkers
Hi Wol, > > "If modeis given and not equal to zero, the absolute value of Nis > > rounded __away from zero__ to a multiple of the absolute value of > > significanceand then the sign applied ." > > > > > > > > That sounds to me as CEILING behaviour, not FLOOR. > > > Can N be negative? The reference

Re: problem with interpreting OpenFormula format in ODF1.2

2015-05-29 Thread Wols Lists
On 19/05/15 12:24, Winfried Donkers wrote: > Hi, > > > > I'm currently working on the various FLOOR functions (all Calc and Excel > variations) and I struggle with this phrase in > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018610_715980110: > >

RE: problem with interpreting OpenFormula format in ODF1.2

2015-05-19 Thread Winfried Donkers
Hi Andras, Regina, > I think we have already resolved it as OFFICE-3879 for ODF1.2 Errata 01 > and ODF 1.3. > > It can be a copy&paste error. I filed a bug: > > https://issues.oasis-open.org/browse/OFFICE-3885 > > We'll discuss this on the next OASIS ODF TC meeting (1st of June), > > unless unti

Re: problem with interpreting OpenFormula format in ODF1.2

2015-05-19 Thread Andras Timar
On Tue, May 19, 2015 at 2:55 PM, Regina Henschel wrote: > Hi Andras, > > I think we have already resolved it as OFFICE-3879 for ODF1.2 Errata 01 and > ODF 1.3. > Hi Regina, You are right. Unfortunately it is not yet in the current 1.3 draft. Thanks! Andras _

Re: problem with interpreting OpenFormula format in ODF1.2

2015-05-19 Thread Regina Henschel
Hi Andras, I think we have already resolved it as OFFICE-3879 for ODF1.2 Errata 01 and ODF 1.3. Kind regards Regina Andras Timar schrieb: Hi, On Tue, May 19, 2015 at 1:24 PM, Winfried Donkers wrote: Hi, I'm currently working on the various FLOOR functions (all Calc and Excel variations

Re: problem with interpreting OpenFormula format in ODF1.2

2015-05-19 Thread Andras Timar
Hi, On Tue, May 19, 2015 at 1:24 PM, Winfried Donkers wrote: > Hi, > > > > I'm currently working on the various FLOOR functions (all Calc and Excel > variations) and I struggle with this phrase in > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018610_71