[Libreoffice-bugs] [Bug 135505] New: Calc: Maths with date off by one day in the afternoon

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: simon at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200806/4f85857c/attachment-0001.htm>