Issue 71059

Summary:	ODFF: Add optional workdays/weekend parameter to NETWORKDAYS and WORKDAY
Product:	Calc	Reporter:	be4truth <b4tasttd>
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	guss77, issues, ooo, oooforum, rb.henschel, sjeet1411
Version:	OOo 2.0.4
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description be4truth 2006-11-01 02:04:59 UTC

An enhancement of the NETWORKDAYS function to tell which days of the week are
working days.
This would be useful for many developing countries where Saturday is still a
working day as well as different religious groups who choose different days of
the week than most countries of the western world.

Comment 1 oc 2008-07-15 10:44:39 UTC

reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)

Comment 2 guss77 2008-12-08 15:15:52 UTC

Also for WORKDAY(). 

Currently this type of computation is rather useless for a lot of people outside
Europe/America as often the weekend is different and so this calculation gives
erroneous results without the user getting any indication as to what is wrong,
as the description in the function manager makes no indication of the
saturday+sunday limitation and a user can easily believe that the weekend days
are determined by the locale selected (as they should be).

At the least a user should be able to disable the builtin weekend days so that
the list of weekend days can be supplied using the holidays array.

Comment 3 Regina Henschel 2010-04-02 22:47:39 UTC

This enhancement is necessary for the ODF1.2 definition of NETWORKDAYS and
WORKDAY, which have a forth parameter to indicate, which days are workdays.
EXCEL 2010 will have versions with this workday definitions too. So this
function should be implemented.

Comment 4 be4truth 2010-04-07 03:18:18 UTC

Given the fact that in Asia (where I live) billions of people work 6 days a week
and the governments are in the process of moving towards openoffice this is not
an enhancement but a must for this function to be meaningful at all.

Comment 5 oooforum (fr) 2014-07-18 07:02:06 UTC

I bump this old issue
MS-Excel 2010 implement two news functions with NETWORKDAYS.INTL and WORKDAY.INTL.
Once again, Lib0 will implement too for the next 4.3 build:
https://bugs.freedesktop.org/show_bug.cgi?id=73147

Is it possible to integrate this code nor develop another one?

Comment 6 Ariel Constenla-Haile 2014-07-18 20:10:36 UTC

(In reply to oooforum from comment #5)
> Is it possible to integrate this code nor develop another one?

no, it's not possible.
Of course, you are free to contact the author and try to convince him/her (personally, I wouldn't be too optimistic)

Comment 7 oooforum (fr) 2014-10-28 16:21:57 UTC

*** Issue 125702 has been marked as a duplicate of this issue. ***