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

Reply via email to