<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Problem with new function SECOND"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121978">121978</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Problem with new function SECOND
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gmolleda@us.es
</td>
</tr></table>
<p>
<div>
<pre>When fixing the 118800 bug
(<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - HOUR, MINUTE and SECOND function return value that is 1 too high, when seconds value of time >= 59.5 (HOUR, MINUTE) or >= xx.5 (SECOND)"
href="show_bug.cgi?id=118800">https://bugs.documentfoundation.org/show_bug.cgi?id=118800</a>), 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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>