https://bugs.documentfoundation.org/show_bug.cgi?id=100342
Bug ID: 100342
Summary: Formula NETWORKDAYS do not use OASIS order for Work
days (4th parameter)
Product: LibreOffice
Version: 5.1.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: pierre-yves.sa...@laposte.net
Created attachment 125612
--> https://bugs.documentfoundation.org/attachment.cgi?id=125612&action=edit
NETWORKDAYS.ods
Hi
(In reply to Commit Notification from bug 77985 comment #6)
> Winfried Donkers committed a patch related to this issue.
> fdo#77985 make calc function NETWORKDAYS comply with ODFF1.2
Thank you for working on this.
The ODFF1.2 states(*):
"optional 4th parameter Workdays ... which days of the week ... in order
Sunday, Monday,...,Saturday. So, the default definition of the work week
excludes Saturday and Sunday and is: {1;0;0;0;0;0;1}"
I may be wrong but it seems you use Monday, Tuesday,...,Sunday order.
Steps to reproduce: open the NETWORKDAYS.ods attached
- In C11 the result is not correct using {1;0;0;0;0;0;1}
- In E11 the result is correct using {0;0;0;0;0;1;1}
Platform: Windows 7/64 & Version: 5.1.3.2
Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
CPU Threads: 2; OS Version: Windows 6.1; UI Render: default;
Locale: fr-FR (fr_FR)
(*)
http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018198_715980110
Regards
--
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