https://bugs.documentfoundation.org/show_bug.cgi?id=135505
Bug ID: 135505
Summary: Calc: Maths with date off by one day in the afternoon
Product: LibreOffice
Version: 6.3.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: si...@seymour-eng.co.uk
Description:
The calculation based on the date gives a different result in the morning to
the afternoon.
Steps to Reproduce:
1. Cell G1: =NOW() Assume it is 06/08/20
2. All other G Cells I put a Date say G307: 06/08/2020
3. N307: =IF(ISBLANK(M307),IF(G307<>"",(G307)-G$1,""),"COMPLETE")
4. In the morning N307 is blank , in afternoon N307 is -1
Actual Results:
In the morning it gives the result I expect, if the date in the G column is the
Same as todays date then the N column is blank. In the afternoon the N column
reads -1 but G1 is still stating the correct date.
This has been the case for may versions of Libreoffice. Same results on
different Laptops
Expected Results:
I would expect the N cell to remain the same all day
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
OS: Windows 10 pro
OS is 64bit: YES
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs