[Libreoffice-bugs] [Bug 114229] New: Basic -timeserial function minutes outside the range 0-59

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114229
           Summary: Basic -timeserial function minutes outside the range
                    0-59
           Product: LibreOffice
           Version: 4.1.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: raal at post.cz

Description:
see helop: https://help.libreoffice.org/Basic/TimeSerial_Function_Runtime


minute: Any integer expression that indicates the minute of the time that is
used to determine the serial time value. In general, use values between 0 and
59. However, you can also use values that lie outside of this range, where the
number of minutes influence the hour value.

12, -5, 45 corresponds to 11, 55, 45

but  TimeSerial(12,-5,45)  throws error:
Action not supported.
Invalid procedure call

tested with LO 4.1 and LO 6

Steps to Reproduce:
1. open attached file with macro
2.run the macro


Actual Results:  
error

Expected Results:
macro return time 11:55:45


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; 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/20171204/b3738b31/attachment-0001.html>