Rob; Can you confirm the platform where you got those results?
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 >
