poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60452] New: WorkdayCalculator calculateWorkdays does return wrong value for same day input
Date Wed, 07 Dec 2016 17:06:23 GMT
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.heer@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message