<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 - EDITING: Hourly time series not calculated correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142974">bug 142974</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;">Resolution</td>
<td>FIXED
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - EDITING: Hourly time series not calculated correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142974#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - EDITING: Hourly time series not calculated correctly"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142974">bug 142974</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 Felix Collins from <a href="show_bug.cgi?id=142974#c7">comment #7</a>)
<span class="quote">> I guess it would be a horrible backward compatibility issue though.</span >
True. There are billions of spreadsheets that do calculations like
"DATEVALUE("2021-06-22")+1/1440" to mean "add 1 minute to the date", or add 1
to add 1 day, etc.
<span class="quote">> It would be interesting to know why the original design decision went this way.</span >
I suppose that back in the day, in 1980s, computers didn't have a reasonable
integer type capable of holding such numbers like *milli*seconds (the minimal
reasonable resolution for time in spreadsheets, since people often need
sub-second precision) since epoch - even seconds already approach unsigned
32-bit limit, and spreadsheets started even before 32-bit era.</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>