https://bugs.documentfoundation.org/show_bug.cgi?id=153139
Bug ID: 153139
Summary: [LibreOffice Calc 7.4.4.2] Incorrect calculation of
times
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I want the time of R4 (see image) to appear in Q4 rounded down to the half
hour. Only, I suppose because of the miscalculated remainder, in the case of
only 30 minutes instead of giving 0 it gives a higher value. Even with -30 it
gives an error. It works correctly up to 29 minutes and from 31 and up, even at
1:30 it works.
Yet I tried doing the same calculations in a separate file, one calculation per
column, and there it works correctly.
Curiously to create the test file I tried multiplying by constant numbers the
cell containing 1 minute to get the other values, both positive and negative
case, but I was getting error.
Steps to Reproduce:
Create a file with the same data and formula.
The value of P is entered by hand. The value of Q is calculated by addition and
subtraction.
Actual Results:
In case of 0:30 the calculation of the remainder is wrong, in all other cases
it is correct.
If I write 0:30:01 the calculation becomes correct, but doing so would change
other calculations and I think it should work correctly in the case of 30
minutes as well.
Expected Results:
The remainder of the division between 0:30 and 0:30 should be zero
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Right now I don't have that information available because I don't have access
to the computer where that file is stored.
And it is not possible to save the bug report in order to access that computer.
I also find it inappropriate to publish my email address and if I could write
in my own language it would be much easier to describe the problem.
--
You are receiving this mail because:
You are the assignee for the bug.
