https://bz.apache.org/ooo/show_bug.cgi?id=126830

          Issue ID: 126830
        Issue Type: DEFECT
           Summary: Modulo function does not work properly, when dividend
                    is result of calculations.
           Product: Calc
           Version: 4.1.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: ui
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 85277
  --> https://bz.apache.org/ooo/attachment.cgi?id=85277&action=edit
Bug example

When i was trying to do some manipulations with time as numbers, modulo
function was giving me incorrect result. Based on attached example it seems
like it is related to calculations used to create dividend, not it value.

What I did is I subtracted 9:45 from 15:15, and from result i subtracted 0:30.
Now total time i multiplied by 1440 to get number of minutes. Which is in that
case 300.
Calculated modulo 60 of returned value, gives me me 60 while i'm expecting 0.

When i tried to use 300 as entered value, or i didn't use second subtraction to
obtain 300, then I'm getting expected result.
Other thing is, function if returns true while comparing entered 300 with
calculated one which gives incorrect result.

-- 
You are receiving this mail because:
You are the assignee for the issue.

Reply via email to