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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
