[Libreoffice-bugs] [Bug 100342] Formula NETWORKDAYS do not use OASIS order for Work days ( 4th parameter)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100342

Winfried Donkers  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |winfrieddonkers@libreoffice
   |desktop.org |.org

--- Comment #4 from Winfried Donkers  ---
As NETWORKDAYS should fully comply with ODF1.2 and currently it doesn't, I will
fix this.

-- 
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

[Libreoffice-bugs] [Bug 100342] Formula NETWORKDAYS do not use OASIS order for Work days ( 4th parameter)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100342

--- Comment #3 from pierre-yves samyn  ---
Hi 

(In reply to GerardF from comment #2)
> It is the world upside down :
> Excel pushing ISO standard and ODF (OASIS) american standard...

:)

> Should we provide a NETWORKDAYS function with week beginning on Sunday and
> NETWORKDAYS.INTL with week starting on Monday ?

The current functionning is ok for me (monday, tuesday... order). My concern
is: 
I started documentation. Should I wait, is this a bug, and it will be modified,
or it is deliberate (for consistency with other functions as you marked).

The change was not documented in the release notes but refers to OASIS, we can
not know...

Regards
Pierre-Yves

-- 
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

[Libreoffice-bugs] [Bug 100342] Formula NETWORKDAYS do not use OASIS order for Work days ( 4th parameter)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100342

GerardF  changed:

   What|Removed |Added

 CC||gerard.farg...@orange.fr

--- Comment #2 from GerardF  ---
It is the world upside down :
Excel pushing ISO standard and ODF (OASIS) american standard...

For NETWORDAYS.INTL, Excel help says :
"Weekend string values are seven characters long and each character in the
string represents a day of the week, starting with Monday. 1 represents a
non-workday and 0 represents a workday. Only the characters 1 and 0 are
permitted in the string. Using 111 will always return 0.

For example, 011 would result in a weekend that is Saturday and Sunday."

Should we provide a NETWORKDAYS function with week beginning on Sunday and
NETWORKDAYS.INTL with week starting on Monday ?

Confusing...

-- 
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

[Libreoffice-bugs] [Bug 100342] Formula NETWORKDAYS do not use OASIS order for Work days ( 4th parameter)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100342

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #1 from m.a.riosv  ---
Reproducible.
Win10x64
Version: 5.1.4.1 (x64)
Build ID: a4d48e4ff0e9f93e78b6356ca7b0b6303e360356
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 

Changing the locale for cells or LibreOffice to English US doesn't help.

-- 
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