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.
