https://bugs.documentfoundation.org/show_bug.cgi?id=114011
Bug ID: 114011
Summary: DATEADD() LOBasic function displays year incorrectly
Product: LibreOffice
Version: 6.0.0.0.alpha1+ Master
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ipla...@tuta.io
Description:
It was reported on the German M-L that the help is incorrect when describing
how to enter the string for the date. Indeed, it does seem wrong, or rather
incomplete, but that is tangential to what is to follow:
1) Open a Writer document
2) Create a new macro module in the document with the following :
Sub example_dateadd
MsgBox DateAdd("m", 1, 31012004) &" - "& DateAdd("M", 1, 31012005)
End Sub
Try and execute the macro.
Using the above:
- if use double quote characters around the date string, I get various error
messages, such as "unsuported type", or "unsupported operation" depending on
which way I type the string separators (dots or slashes);
- if I use as in the above example, i.e. no quotes around what is essentially
an integer, I get a MsgBox that displays "31/01/32767 - 31/01/32767" which is
obviously incorrect.
This latter behaviour is the one being reported here.
Steps to Reproduce:
See above description
Actual Results:
See above
Expected Results:
Correct display of the year.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:57.0)
Gecko/20100101 Firefox/57.0
--
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
