https://bz.apache.org/bugzilla/show_bug.cgi?id=60452
Bug ID: 60452
Summary: WorkdayCalculator calculateWorkdays does return wrong
value for same day input
Product: POI
Version: 3.16-dev
Hardware: PC
OS: Linux
Status: NEW
Severity: critical
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: fabio.h...@dvbern.ch
Target Milestone: ---
Created attachment 34505
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34505&action=edit
Patch for WorkdayCalculator
The excel function NETWORKDAYS can be used with two equal input dates, e.g.
2017-01-01, 2017-01-01. In this case, the underlying WorkdayCalculator returns
erroneously the value 2 instead of 0.
This behavior is not conform with the calculations in MS Office and
LibreOffice.
Tests and a fix is provided in the attachment.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
