<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span> changed
<a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Problem with new function SECOND"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121978">bug 121978</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Assignee</td>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
<td>winfrieddonkers@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>ASSIGNED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Problem with new function SECOND"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121978#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Problem with new function SECOND"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121978">bug 121978</a>
from <span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span></b>
<pre>I'll take it.
<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">Bug 118800</a> was meant to fix rounding 59.9 seconds to 60, which is not a valid
result for SECOND, which must return integer values between 0 and 59
(inclusive).
This bug shows that the fix for tdf118800 is not correct, as it returns the
integer part of the second value, instead of rounding the value.
ODF1.2 Part 2 ยง6.10.16 states that the second value is to be rounded.
That means that SECOND(11:22:59.9) should return 0 (11:23:00).</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>