https://bugs.documentfoundation.org/show_bug.cgi?id=133910
--- Comment #9 from libre officer <smartaz...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
