[Libreoffice-bugs] [Bug 139932] New: DATE[VALUE](...) + TIME[VALUE](...) one second less than expected for some years and hours

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139932
           Summary: DATE[VALUE](...) + TIME[VALUE](...) one second less
                    than expected for some years and hours
           Product: LibreOffice
           Version: 6.4.5.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: bugreporter at public-files.de

Created attachment 169167
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169167&action=edit
example for one-second-less-behaviour

In the attached ods you can see that for 
- a few years 
- everyday
- but only for some hours

a))
1) DATE(<year>;1;1) evaluates correctly
2) TIME(<hour>;0;0) evaluates correctly
3) the sum of both evaluates to one second less than expected

b))
1) DATEVALUE("01.01.<year>") evaluates correctly
2) TIMEVALUE("<hour>:00:00") evaluates correctly
3) the sum of both evaluates to one second less than expected

This might be related to #127498, but there the TIMEVALUE(...) itself is
reported to be one second less whilst herein only the summations are.


Best regards
Ian

-- 
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/20210126/25d1668f/attachment.htm>