https://bz.apache.org/bugzilla/show_bug.cgi?id=57755
Bug ID: 57755
Summary: POI Formula Evaluation Failed with condition
Product: POI
Version: 3.11-FINAL
Hardware: Sun
OS: SunOS
Status: NEW
Severity: critical
Priority: P2
Component: POI Overall
Assignee: [email protected]
Reporter: [email protected]
Hello
I'am using POI in order to read excels files from my users. In one of the
cells, i've got this formula :
IF(H24>0,((D24*(Q24))/((3600*H24)/I24))+IF(AND(N24>0,L24>0),(D24*L24*(Q24)/N24),0),0)
The problem arrive when i've got a 0 value for N24. In this case, POI returns
me an DIV/0 error, but i don't understand why .. because of the IF (N24>0)
test.
Anyway, I tried changing the formula and keep only the latest part like this :
IF (N24>0,D24*L24*(Q24)/N24,0) => still doesn't work.
To Evaluate the formula I use : FormulaEvaluator evaluator =
wb.getCreationHelper().createFormulaEvaluator();
And then i do a switch.
--
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]
