[Libreoffice-bugs] [Bug 114011] New: DATEADD() LOBasic function displays year incorrectly

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: iplaw67 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171123/9607f7b9/attachment.html>