https://bugs.documentfoundation.org/show_bug.cgi?id=149898
Bug ID: 149898
Summary: Calculating datetime differences - different results
depending on formatting
Product: LibreOffice
Version: 7.0.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: cpo...@gmail.com
Description:
When calculating the difference between two datetime values in Calc, the result
is different depending on whether the numbers are formatted as date/time
(correct) or decimal (wrong result). See the attached example.
Steps to Reproduce:
See the spreadsheet attached.
Actual Results:
Caculation result depends on number format.
Expected Results:
Caculation result must not depend on number format.
Reproducible: Always
User Profile Reset: No
Additional Info:
Verified on both Windows with version 7.0.6.2 and macOS with version 7.3.4.2
--
You are receiving this mail because:
You are the assignee for the bug.
