Sorry, this functionality is currently missing. Bug 13078 talks about using boolean values (ie, the literals TRUE/FALSE) as parts of a formula. ie, things like IF(TRUE,......) etc.
What you want are boolean "return" values, which are stored in a different way from what 13078 talks about. I hesitate to call it such, but one workaround is to getNumericCellValue(), consider that number as an 8 byte (littleendian) IEEE format. The third byte is then the boolean value you require. .. phew It should be simpler to add this functinality.. you need to change records/FormulaRecord. If someone is willing to do it, i am happy to help with the specs. Regards - Avik On Wed, 2003-11-26 at 04:05, zacbol at cfi2.com wrote: > 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]
