[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 #9 from libre officer <smartazaiz at gmail.com> ---
(In reply to libre officer from comment #2)
> (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.).

Any enhancement to support array argument instead of cell range, which make it
mendatory to create Calc window ?

-- 
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/20200621/41e06a8c/attachment.htm>