<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <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#c2">Comment # 2</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 <a class="email" href="mailto:smartazaiz@gmail.com" title="libre officer <smartazaiz@gmail.com>"> libre officer</a> <pre>(In reply to Oliver Brinzing from <a href="show_bug.cgi?id=133910#c1">comment #1</a>) > (In reply to libre officer from <a href="show_bug.cgi?id=133910#c0">comment #0</a>) > > Description: > > Calling Calc functions which accepts additional argument as an array of > > values throws a BASIC runtime error. > > Are you sure this can work ? > > According to: > <a href="https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_workday">https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_workday</a>. > html?DbPAR=CALC#bm_id3149012 > > Holidays is a list of optional holidays. > Enter a *cell* *range* in which the holidays are listed individually. That's the problem, I am obliged to provide a cell range object instead of a simple array of date values. Actually, what I do is to create new temporary Calc file, and insert value from another generated date list, then get the cell range to feed it to `workday`, then close that Calc file. I use Base form, so it is slower to create a Calc file and do all the stuffs I mentioned. Instead, it would be much convenient and faster if I feed `workday` directly with array of values without the need to create a cell range. Other Calc functions don't needs to create a new sheet, you just call it (weekday, weeknum, etc.).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>