poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61064] New: Update CEILING to match later versions of Excel
Date Wed, 03 May 2017 13:54:43 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61064

            Bug ID: 61064
           Summary: Update CEILING to match later versions of Excel
           Product: POI
           Version: 3.16-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: vertexshader256@gmail.com
  Target Milestone: ---

The CEILING function in MathX needs to allow a negative number argument and a
positive significance.

= CEILING(-11.12333, 0.03499)
= -11.09183

Test within testCeiling() which should be failing:
d = -11.12333; s = 0.03499;
assertEquals("ceiling ", Double.NaN, MathX.ceiling(d, s));

The logic within ceiling() should be changed to:
if (n>0 && s<0) {
    c = Double.NaN;
}

More info:
http://www.excelfunctions.net/Excel-Ceiling-Function.html

-- 
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