[Libreoffice-bugs] [Bug 117878] Change of behaviour in function DateSerial.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117878

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|x86-64 (AMD64)              |All
            Version|6.0.4.2 release             |5.4.0.0.alpha0+

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180625/a1f7be78/attachment.html>