Issue 71059 - ODFF: Add optional workdays/weekend parameter to NETWORKDAYS and WORKDAY
Summary: ODFF: Add optional workdays/weekend parameter to NETWORKDAYS and WORKDAY
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 125702 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-11-01 02:04 UTC by be4truth
Modified: 2014-10-28 16:21 UTC (History)
6 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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. ***