<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 - SUM (in status bar) produces different result depending on first value (and selection direction), when counting times"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132582">132582</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>SUM (in status bar) produces different result depending on first value (and selection direction), when counting times
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>cno@nouenoff.nl
</td>
</tr></table>
<p>
<div>
<pre>Will attach a spreadsheet
There are some ranges with times (HH:MM:SS)
1 – Select from D6 to D2 (bottom to top)
> notice that the sum restarts counting at 24
2 – Select from H5 to H2 (bottom to top)
> notice that the sum continues to count above 24
Interesting :)
= = = Note!
I thought this could be related to the fact that counting columns of time cells
with SUM() sometimes restarts at 24, and sometimes just totals..
I've seen this effect for over 10 year now, but never fiddled out what made the
difference.
Alas I see no way how the now reported bug, influences that..
= = =</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>