<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:smartazaiz@gmail.com" title="libre officer <smartazaiz@gmail.com>"> <span class="fn">libre officer</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UNO: `callFunction`does not accept optional Array parameter"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133910">bug 133910</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UNO: `callFunction`does not accept optional Array parameter"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133910#c11">Comment # 11</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UNO: `callFunction`does not accept optional Array parameter"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133910">bug 133910</a>
from <span class="vcard"><a class="email" href="mailto:smartazaiz@gmail.com" title="libre officer <smartazaiz@gmail.com>"> <span class="fn">libre officer</span></a>
</span></b>
<pre>(In reply to Xisco Faulí from <a href="show_bug.cgi?id=133910#c10">comment #10</a>)
<span class="quote">> 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 <a href="https://www.libreoffice.org/download/libreoffice-fresh/">https://www.libreoffice.org/download/libreoffice-fresh/</a> ?
> 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.</span >
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>