Issue 94968 - oo3 calc: MOD(3^36;15) = 640
Summary: oo3 calc: MOD(3^36;15) = 640
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-10-16 06:10 UTC by justinehrlich
Modified: 2013-01-29 21:48 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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!