Issue 94968

Summary: oo3 calc: MOD(3^36;15) = 640
Product: Calc Reporter: justinehrlich <justin.ehrlich>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, pescetti, rb.henschel
Version: OOO300m9Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description justinehrlich 2008-10-16 06:10:15 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.
Comment 1 Regina Henschel 2008-10-16 14:27:04 UTC
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}.
Comment 2 justinehrlich 2008-10-16 16:42:28 UTC
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!