<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Change of behaviour in function DateSerial."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117878">bug 117878</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;">Hardware</td>
<td>x86-64 (AMD64)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>6.0.4.2 release
</td>
<td>5.4.0.0.alpha0+
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Change of behaviour in function DateSerial."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117878#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Change of behaviour in function DateSerial."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117878">bug 117878</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>I consider accepting invalid dates as wrong, but.. seems that odd roll-over
behaviour was for VBA "compatibility" (and for VBA mode it does work)? But then
again, why was 02-31 accepted but not 02-32 (which VBA apparently accepts)? I
suspect that was due to the dumb old algorithm.
So, do we want to accept any day (and month) number there and roll over? Or
should we restrict to the arbitrary previous margin values 1<=month<=12 and
1<=day<=31? Which IMHO does not make sense and I certainly would not accept any
complaint that suddenly also day 32 is accepted..
My take: do the full roll-over if that is what VBA does as well.</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>