https://bugs.documentfoundation.org/show_bug.cgi?id=93685
Bug ID: 93685
Summary: WORKDAYINTL function has a new parameter that make old
spreadsheet in error
Product: LibreOffice
Version: 5.0.1.1 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rpn...@free.fr
The WORKDAYINTL (named WORKDAY in the help?) from LO 4 has this schema :
WORKDAY(StartDate; Days; Holidays).
But in LO 5.0.1, it has this schema :
WORKDAY(StartDate; Days; number or strings; array) with array matching with
Holydays in fact. A new parameter (number or strings) was created.
So old spreadsheet have errors because Holidays are arrays and number or
strings are required with another meaning.
To assure compatibility, the 4th parameter should be in the 3th position.
More, the English labels in the Function wizard are not clear ("number or
string" and "array").
It is a bug that make obsolete all spreadsheet that use this parameters.
So please, fix as soon as possible.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
