Apache OpenOffice (AOO) Bugzilla – Issue 94968
oo3 calc: MOD(3^36;15) = 640
Last modified: 2013-01-29 21:48:42 UTC
When I calculate mod(3^36;15), I get 640. I tried this on both my Vista x64 machine and my Intel MacBook running Leopard, both gave the same results. It should be < 15 and OO should report 0 for such a high number. Other values close to this give expected results.
confirm the wrong result. But I think the function should not return 0 but give an overflow error. If it would return 0, then the user cannot notice that it is a wrong result, because 0 is among the possible results {0,1,..,14}.
I suggested it return 0 because it's a precision issue due to such a large number being returned as a float, not an overflow problem. OO does calculate =3^36 = 1.50E+017. An overflow problem would be =mod(3^1000;15) which OO correctly returns as #NUM!