https://bugs.documentfoundation.org/show_bug.cgi?id=139363
--- Comment #4 from Johnny Rosenberg <guraknu...@gmail.com> ---
I just can't think of any issues that could occur due to lack of compatibility
with previous versions of LibreOffice. As far as I can see, everything would
still work, wouldn't it? If you wrote code to handle values that are ”out of
bounds” (for instance month=13), that code wouldn't be necessary any more but
it wouldn't hurt either.
My main argument for changing this isn't Excel compatibility anyway. I just
think that the function should handle things like this automatically, because
it makes it very convenient when using it in a loop and you can easily do
calculations by just adding and subtracting years, months and days. Days would
of course work well anyway, since you can always convert to the date format and
just add and subtract days, but calculating months is more difficult. Let's say
you want the date for today + 18 months. Wouldn't it make sense then to just do
something like DateSerial(ThisYear, ThisMonth+18, ThisDay)? If that can't be
done with DateSerial, you need to keep track of leap years and how many days
each month has, things like DateSerial keeps track of anyway. For instance
DateSerial(1900,2,29) throws an error message, I have tested that, so obviously
it already keeps track of leap-years and everything else needed to know that
this date does not exist.
And, since Excel was mentioned, I just have to add that I personally don't care
much for Excel compatibility, I don't even use Windows (except at work), but
many users are used to Excel so I don't think avoiding compatibility is a good
thing either. In this case we can have both compatibility and great
functionality, so why not? And as I said, I can't see the case that changing
this the way I described would break anything in old LibreOffice macros. The
worst thing I can see is that people wrote code that is no longer needed. They
can just keep it, it won't do any harm.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
