[Libreoffice-bugs] [Bug 121978] New: Problem with new function SECOND

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 121978
           Summary: Problem with new function SECOND
           Product: LibreOffice
           Version: 6.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gmolleda at us.es

When fixing the 118800 bug
(https://bugs.documentfoundation.org/show_bug.cgi?id=118800), the developers
changed the SECOND function to not round. All right.

But now, by subtracting two dates with hours, the result is a little less than
the correct one and as a consequence the SECOND function fails to give the
second of the correct difference.

Now if you write in Calc:

A2: 00:03:09
A3: 2018-10-22 11:31:44
A4: 2018-10-22 11:34:53
A5: =A4-A3 --> result 00:03:09
A6: =SECOND(A5) --> result in Calc 6.1.3.2 is 8, BAD. In Calc 6.0.6.2 and Excel
2016 is 9 (RIGHT). 

The internal number in A2 is 0,0021875 that is 60*3 minutes + 9 seconds * 1/(24
hours*60 minutes*60 seconds) and in A5 is 0,002187499995. Now SECOND function
not round.

8 seconds, 99 hundredths is still the second 8 as the year of 12/31/2018 is
2018 and not 2019. You can wait 2018 if you write =YEAR("12/31/2018") and 8 if
you write =SECOND("00:00:08,99"). In 6.0.6.2 and Excel 2016 this function
results 9 and in Calc 6.1.3.2 the result is 8.

The problem is if you subtract two dates and the result goes wrong narrowly.
Before nothing happened and now offers a second less than it should.

-- 
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/20181208/fae5de94/attachment.html>