[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter

[bugzilla-daemon at bugs.documentfoundation.org]

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

libre officer <smartazaiz at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
             Status|NEEDINFO                    |UNCONFIRMED

--- Comment #11 from libre officer <smartazaiz at gmail.com> ---
(In reply to Xisco Faulí from comment #10)
> Hello libre officer,
> A new major release of LibreOffice is available since this bug was reported.
> Could you please try to reproduce it with the latest version of LibreOffice
> from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' if the bug is still present in the latest version.

Hello Xisco,

It still raises exceptions for the cases as follow (see code comments):

Sub Main
        oFA = createUnoService( "com.sun.star.sheet.FunctionAccess" )
        holidays = Array("2020-02-22", "2020-02-23")

         ' Gives 24.02.2020, which is the result in Calc
        Print CDate( oFA.callFunction( "WORKDAY", Array( "2020-02-21", 1 )) )

         ' Runtime Error. Expected result should be : 25.02.2020
        Print CDate( oFA.callFunction( "WORKDAY", Array( "2020-02-21", 1,
"2020-02-24" )) )

        ' This one is not accepted as the third argument is a list of holidays
        Print CDate( oFA.callFunction( "WORKDAY", Array(  "2020-02-21", 1,
holidays)))

End Sub

The second `Print` does not accept the 3rd argument. even though it is accepted
in `Calc`.

I wish that in the last `Print`, I can pass the 3rd argument as a list of
holidays to exclude from `WORKDAY`.



Reproducible: Always

User Profile Reset: No

Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: fr-CH (fr_CH); UI: en-GB
Calc: CL

-- 
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/20210222/fec170c9/attachment.htm>