poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57755] POI Formula Evaluation Failed with condition
Date Wed, 25 Mar 2015 12:38:05 GMT

--- Comment #2 from JP <jp.iwasinta@gmail.com> ---
I made some test.
When changed :
IF (N24>0,D24*L24*(Q24)/N24,0) 
IF ((N24*1)>0,D24*L24*(Q24)/N24,0) it works.

Then trying to explain why :
I checked the excel file : The type in Standard Number
I checked the code and i made cell.getCellType() which return a String ... so
because of the string return the test  N24 > 0 was always true ... so that's
why i had a DIV/0 error.

The thing i don't understand is why the getCell returns a string ... in place
of a number.

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

View raw message