[Libreoffice-bugs] [Bug 125580] New: Wrong value when adding two dates

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125580
           Summary: Wrong value when adding two dates
           Product: LibreOffice
           Version: 6.2.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: contact at alexrio.fr

Description:
When using the + operator on dates multiple times the result ends up being
erroneous.

Steps to Reproduce:
1. Enter =FLOOR(NOW(), "00:05") in cell A1 to have "clean" date
2. Enter =A1 + TIME(0;5;0)
3. Use the handle to apply the function multiple times

Actual Results:
After 20 lines the output becomes:

29/05/19 17:05
29/05/19 17:10
29/05/19 17:14
29/05/19 17:19

Meaning 4 minutes have been added instead of 5

Expected Results:
Always have the same value added on every row


Reproducible: Always


User Profile Reset: No



Additional Info:
Bug is also present when using a plain text date on first cell and formatting
as a date but doesn't work with only =NOW() function in first cell.
Same behavior when using "+ (1/24/12)" as increment.

Version: 6.2.4.2.0+
Build ID: 6.2.4-1
CPU threads: 8; OS: Linux 5.1; UI render: default; VCL: gtk3; 
Locale: fr-FR (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
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/20190529/b41a76a4/attachment.html>