On Thu, Feb 14, 2013 at 4:47 PM, Rob Weir <robw...@apache.org> wrote: > 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. >
And I should mention that this would come up quite frequently, due to the way Calc treats empty cells. So if a user had a spreadsheet for users to fill out and did: =a1^a2 and used that return in a calculation, and initially had A1 and A2 blank for the user to fill in, then before there was no error before the user entered data, but now there is. So it is essentially changing the UI of template spreadsheets. -Rob > 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