<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 - Time addition short of one second in calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127143">127143</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Time addition short of one second in calc
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 release
</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>jgermer@sapo.pt
</td>
</tr></table>
<p>
<div>
<pre>Description:
Adding 5 minutes time intervals by "A_+10/60/24" to "16.07.2019 00:00:00" is
short of one second between line 18 and 19. This depends on the actual starting
date and fraction of day to be added. Starting with "16.07.1970 00:00:00" or by
changing the interval to "A_+10/60/24" time is added correctly.
Steps to Reproduce:
1.Fill in field A1 "16.07.2019 00:00:00"
2.Fill in field A2 "=A1+5/60/24", A3 "=A2+5/60/24" continue accordingly until
line 20 or more
3.Observe the interval between line 18 and 19
Additional:
4.Do changes as mentioned in the description above
5.Change starting year to 1990
Actual Results:
For steps 1 to 3:
16.07.19 01:25:00 in line 18
16.07.19 01:29:59 in line 19
---
For step 4:
As expected
---
For step 5:
16.07.90 00:05:00 in line 2
16.07.90 00:09:59 in line 3
Expected Results:
16.07.19 01:25:00 in line 18
16.07.19 01:30:00 in line 19
---
As is
---
16.07.90 00:05:00 in line 2
16.07.90 00:10:00 in line 3
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
According to libreoffice-forum.de this bug does not occur on LO 5.1.5.2,
6.1.6.3 or excel.</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>