https://issues.apache.org/bugzilla/show_bug.cgi?id=47083
Josh Micich <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #1 from Josh Micich <[email protected]> 2009-04-23 09:26:27 PST --- Without an example spreadsheet it's hard to tell what is going wrong. POI has quite a few junit test cases that show AND() to be working correctly. Perhaps the problem is with one of the sub expressions. If either evaluates to #VALUE!, that error will propagate to AND()'s return result. You can drill down to the source of the #VALUE! error by trying things like this: HSSFCell cell = workbook.getSheet("Calculation").getRow(63).getCell(4); cell.setCellFormula("B13=\"ACCEPT\""); CellValue cellValue = formulaEvaluator.evaluate(cell); System.out.println(cellValue.formatAsString()); If this doesn't help you solve your problem, please upload an example spreadsheet which demonstrates the error. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- 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]
