<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FORMATTING - Wrong date substraction in cell's operation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132083">bug 132083</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;">Status</td>
<td>REOPENED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FORMATTING - Wrong date substraction in cell's operation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132083#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - FORMATTING - Wrong date substraction in cell's operation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132083">bug 132083</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to Albrecht Müller from <a href="show_bug.cgi?id=132083#c4">comment #4</a>)
<span class="quote">> I think this is a bug. Look at the problem from a users point of view: The
> essential part is that you subtract two numbers containing only integral
> multiples of time units, you get an integral result and this result is
> obviously wrong. As only integral numbers are involved there is no room for
> round off errors. If this is not a bug what else can count as bug?
>
> And I think it is a pretty serious one: How can I trust the results of more
> complicated calculations if I can easily demonstrate that LibreOffices does
> not even get simple integer calculations right?</span >
It's a misconception. You are making arithmetics with times. And time in
LibreOffice is just a fraction of a base unit, which is a day. 12:00:00 in
LibreOffice is 0.5 (half a day). You are *not* doing simple integer
calculations. Just try to format your cells as numbers.
And you may see the bug I linked as See Also that you might want to track. This
is either NOTABUG or duplicate of that one, in any case it should be closed.</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>