[Libreoffice-bugs] [Bug 127143] New: Time addition short of one second in calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127143

            Bug ID: 127143
           Summary: Time addition short of one second in calc
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jgermer at sapo.pt

Description:
Adding 5 minutes time intervals by "A_+10/60/24" to "16.07.2019 00:00:00" is
short of one second between line 18 and 19. This depends on the actual starting
date and fraction of day to be added. Starting with "16.07.1970 00:00:00" or by
changing the interval to "A_+10/60/24" time is added correctly.

Steps to Reproduce:
1.Fill in field A1 "16.07.2019 00:00:00"
2.Fill in field A2 "=A1+5/60/24", A3 "=A2+5/60/24" continue accordingly until
line 20 or more
3.Observe the interval between line 18 and 19
Additional:
4.Do changes as mentioned in the description above
5.Change starting year to 1990

Actual Results:
For steps 1 to 3:
16.07.19 01:25:00 in line 18
16.07.19 01:29:59 in line 19
---
For step 4:
As expected
---
For step 5:
16.07.90 00:05:00 in line 2
16.07.90 00:09:59 in line 3



Expected Results:
16.07.19 01:25:00 in line 18
16.07.19 01:30:00 in line 19
---
As is
---
16.07.90 00:05:00 in line 2
16.07.90 00:10:00 in line 3



Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
According to libreoffice-forum.de this bug does not occur on LO 5.1.5.2,
6.1.6.3 or excel.

-- 
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/20190825/6b22eef4/attachment-0001.html>