[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

--- Comment #2 from libre officer <smartazaiz at gmail.com> ---
(In reply to Oliver Brinzing from comment #1)
> (In reply to libre officer from comment #0)
> > 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:
> https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_workday.
> 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.).

-- 
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/20200613/5cd55549/attachment.htm>