On Feb 14, 2013, at 8:51 PM, Pedro Giffuni <p...@apache.org> wrote: > Rob; > > Can you confirm the platform where you got those results? >
I believe this was WinXP SP3 (32-bit), but I can confirm in the morning. -Rob > Thanks, > > Pedro. > > > ----- Messaggio originale ----- >> Da: Rob Weir <robw...@apache.org> >> A: dev@openoffice.apache.org; Pedro Giffuni <p...@apache.org> >> Cc: >> Inviato: Giovedì 14 Febbraio 2013 16:47 >> Oggetto: Re: Calc behavior: result of 0 ^ 0 >> >> On Thu, Feb 14, 2013 at 4:19 PM, Pedro Giffuni <p...@apache.org> wrote >>> >>> >>> ----- Messaggio originale ----- >>>> Da: Rob Weir >>> >>>> >>>> And I should say that I'm happy to help if you or anyone else >> wishes >>>> to introduce a "warning mode" or "formula lint" or >> similar feature >>>> that can be optionally enabled to check for possible inadvertent user >>>> errors. >>> >>> As the guys from the poisonous people video[1] said: >>> >>> "Patches Welcome" >> >> Pedro, I reverted your patch. It was broken in many ways. It is sad >> that with the length of this thread that no one, apparently even you, >> tried to test it. But I did and found: >> >> 0^0 now returns a #VALUE! error in Calc, breaking compatibility. >> >> 2^(1/3) which should be the cube root of 2 now returns 1. This is >> mathematically incorrect and breaks compatibility. >> >> 2^(-1/3) which should be the reciprocal of the cube root of 3 returns >> 1 with Pedro's changes. This is mathematically incorrect and breaks >> compatibility. >> >> -2^(1/3) which should be an error (returns #VALUE! in AOO 3.4.1) now >> returns 1 with Pedro's changes. This is mathematically incorrect and >> breaks compatibility. >> >> -2^(-1/3) which should be an error (returns #VALUE! in AOO 3.4.1) now >> returns 1 with Pedro's changes. This is mathematically incorrect and >> breaks compatibility. >> >> -Rob >> >>> Pedro. >>> >>> [1] http://www.youtube.com/watch?v=Q52kFL8zVoM >>
