https://bugs.documentfoundation.org/show_bug.cgi?id=118596
Bug ID: 118596
Summary: Calc equation
=1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives
divide by zero error
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
=1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) gives divide by zero error.
=1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,31,0))) gives a real answer.
It looks as though if the minute part of two times subtract to zero calc
assumes the whole answer in minutes is zero for the purposes of recording a
divide by zero error.
My work around has been to add one minute to the second time value which for my
study is not significant.
Steps to Reproduce:
1.Start libre office calc
2. enter equation =1/(MINUTE(TIME(7,30,0))-MINUTE(TIME(21,30,0))) into cell
3.
Actual Results:
Divide by zero error
Expected Results:
a number 0.00 if cell format set to number with 2 decimal places.
Reproducible: Always
User Profile Reset: No
Additional Info:
Produced a value, 0.00 if cell format set to number with 2 decimal places.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
