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.