https://bugs.documentfoundation.org/show_bug.cgi?id=89848
Bug ID: 89848
Summary: Problem of rounded value in time difference
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113915
--> https://bugs.documentfoundation.org/attachment.cgi?id=113915&action=edit
Example of the issue
Hello, in the file I attached, the cells A1 and A2 contain two dates with 1
second of difference
In the cell A3, I substract A2 to A1, I multiplied the difference by 24*3600 to
get the result in second and I convert the it into a number. The result is not
exactly 1 but 1.0000000xxx where xxx is something different of 0. It should be
exactly one.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs