Summary: | [PATCH] WorkdayCalculator calculateWorkdays does return wrong value for same day input | ||
---|---|---|---|
Product: | POI | Reporter: | Fabio <fabio.heer> |
Component: | SS Common | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | critical | CC: | haeni.sebastian |
Priority: | P2 | Keywords: | PatchAvailable |
Version: | 3.16-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux | ||
Attachments: | Patch for WorkdayCalculator |
Created attachment 34505 [details] 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.