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