[Bug 166193] NETWORKDAYS function is broken
https://bugs.documentfoundation.org/show_bug.cgi?id=166193 --- Comment #2 from kirsch...@gmx.de --- (In reply to Mike Kaganski from comment #1) > 1. Please check if the "Err:259" is the real actual result. Isn't it > "Err:539"? Sorry, it's a typo. It is indeed "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). That does the trick. If I change my Calc's formula setting it works... A layer 8 problem. :( > 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"? In my opinion this would fix the issues in the wiki articles. I started on a german installation of LibreOffice and used the example from the german wiki page (https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS/de), without success. Therefore I would prefer this solution. An differend approach could be a changed behaviour on switch to a different locale for the UI. I did this to check the example from the english wiki (https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS/en), again without success. It happens because the old "german" separator was still used. Could there be an automatic switch to the proper separator OR at least a hint that the current settings could make trouble? On the other side, an automatic change could lead to much more confusion... -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166193] NETWORKDAYS function is broken
https://bugs.documentfoundation.org/show_bug.cgi?id=166193
Mike Kaganski 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 ---
(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.
