[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Jun 13 19:54:11 UTC 2020
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>
More information about the Libreoffice-bugs
mailing list