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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from Mike Kaganski <mikekaganski at hotmail.com> ---
Created attachment 151960
  --> https://bugs.documentfoundation.org/attachment.cgi?id=151960&action=edit
Testing results with Excel 2016

The code tested was:

> Sub testTimeSerial()
>   Dim result As String
>   Dim i As Long
>   Dim h As Long, m As Long, s As Long
>   For h = -30 To 30 Step 2
>     For m = -70 To 70 Step 10
>       For s = -70 To 70 Step 10
>         i = i + 1
>         Cells(i, 1) = h
>         Cells(i, 2) = m
>         Cells(i, 3) = s
>         Cells(i, 4) = testImpl(h, m, s)
>       Next s
>     Next m
>   Next h
> End Sub
> 
> Function testImpl(h As Long, m As Long, s As Long) As String
>   On Error GoTo errHandler
>   testImpl = TimeSerial(h, m, s)
>   Exit Function
> errHandler:
>   testImpl = "Error: " & Err
> End Function

-- 
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/20190606/30dcee90/attachment.html>