https://bz.apache.org/bugzilla/show_bug.cgi?id=57755
--- Comment #2 from JP <[email protected]> --- I made some test. When changed : IF (N24>0,D24*L24*(Q24)/N24,0) by 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 Then 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: [email protected] For additional commands, e-mail: [email protected]
