https://bugs.documentfoundation.org/show_bug.cgi?id=166193
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Windows (All) |All
Component|Calc |Documentation
CC| |olivier.hallot@libreoffice.
| |org
Hardware|x86-64 (AMD64) |All
--- Comment #1 from Mike Kaganski <mikekagan...@hotmail.com> ---
(In reply to kirsche40 from comment #0)
> Cell input is:
> =NETWORKDAYS("2020-01-01"; "2020-12-31"; {"2020-01-01", "2020-04-10",
> "2020-04-13", "2020-05-08", "2020-05-25", "2020-08-31", "2020-12-25",
> "2020-12-28"})
>
> Actual Results:
> "Err:259"
1. Please check if the "Err:259" is the real actual result. Isn't it "Err:539"?
2. Please check your options, to see if the colon "," is an array row or column
separator in your Calc's formula setting. It is likely, that you should use
your locale's row/column separator (e.g., for me those are ";" and ".",
respectively; and both work - the function doesn't care what shape the passed
array is).
For me, the following *three* variants work OK:
=NETWORKDAYS("2020-01-01"; "2020-12-31";
{"2020-01-01";"2020-04-10";"2020-04-13";"2020-05-08";"2020-05-25";"2020-08-31";"2020-12-25";"2020-12-28"})
=NETWORKDAYS("2020-01-01"; "2020-12-31";
{"2020-01-01"."2020-04-10"."2020-04-13"."2020-05-08"."2020-05-25"."2020-08-31"."2020-12-25"."2020-12-28"})
=NETWORKDAYS("2020-01-01"; "2020-12-31";
{"2020-01-01"|"2020-04-10"|"2020-04-13"|"2020-05-08"|"2020-05-25"|"2020-08-31"|"2020-12-25"|"2020-12-28"})
The function NETWORKDAYS is not broken, as far as I can tell. But you may want
to add some details to the wiki.
Olivier: should we create a template about the symbols used as separators, to
add to all help articles? Something like "The function arguments separators and
inline array separators depend on the locale, and are configured on
Options->Calc->Formula"?
--
You are receiving this mail because:
You are the assignee for the bug.
