[Libreoffice-bugs] [Bug 132083] New: FORMATTING - Wrong date substraction in cell's operation

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132083
           Summary: FORMATTING - Wrong date substraction in cell's
                    operation
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jarko at sortsk.pl

Description:
E.g. "2020-04-13 12:18:00" - "2020-04-13 12:08:00" results in 9 (nine) minutes,
instead of 10. To get 10 we have to add one second:
"2020-04-13 12:18:01" - "2020-04-13 12:08:00" = 10

Other values are computed correctly, but not sure, if in ANY case.

Steps to Reproduce:
1. Set 'date' format for two cells
2. Fill in both: 2020-04-13 12:18:00 and 2020-04-13 12:08:00
3. Substract values in third cell, formatted as 'hour'

Actual Results:
9 (minutes)

Expected Results:
10 (minutes)


Reproducible: Always


User Profile Reset: No



Additional Info:
Wersja: 6.4.2.2 (x64)
Identyfikator kompilacji: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
Wątki CPU: 4; System operacyjny: Windows 6.1 Service Pack 1 Build 7601; Render
UI: domyślny; VCL: win; 
Ustawienia regionalne: pl-PL (pl_PL); Język UI: pl-PL
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/20200413/1d7241b3/attachment.htm>