Hi Zac. A boolean value is an atomic value and not a formula. When a formula shall return a Boolean value (when it's evaluated) you can't apply a function which shall fetch a Boolean value.
Yours sincerely, Karl-Heinz Zengerle ___________________________________________________ More than competence in Document Management ___________________________________________________ SAW AG Waldm�nchenerstr. 12 81549 M�nchen Tel.: ++49-89-68088368 Fax: ++49-89-68088389 www.sawag.com ___________________________________________________ -----Urspr�ngliche Nachricht----- Von: zacbol at cfi2.com [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 23:35 An: [EMAIL PROTECTED] Betreff: Retrieving bool from an HSSFCell of type CELL_FORMULA I'm working with HSSF to read Excel data into my own data structure, using the high level API (hssf.usermodel). There seems, however, to be a problem calling HSSFCell.getBooleanCellValue() for cells of type CELL_FORMULA. Rather than reading the data, an exception is thrown. In contrast, HSSFCell.getStringCellValue() and HSSFCell.getNumericCellValue() work fine in this context. Further, HSSFCell.getBooleanCellValue() works correctly for cells of type CELL_BOOLEAN. The following seems to indicate that this issue has been resolved: http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13078 Is it simply the case that this fix applies only to the event API and these changes have not propagated to the high-level API? Are there workarounds that avoid having to reimplement the existing code using the Event API or fixing the POI sourcecode(if this really is a bug)? Thanks. -Zac ----- End forwarded message ----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
