https://issues.apache.org/bugzilla/show_bug.cgi?id=44508
Summary: Number format exception when reading boolean formula
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows 2000
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=21601)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=21601)
the excel file, edited by Open Office Calc, contains boolean values that are
considered as functions
Reading an excel file, created with Open Office Calc, where the boolean flags
are apparently saved as cells of type FORMULA, causes number format exceptions
at evaluation time
Caused by: java.lang.NumberFormatException: You cannot get a boolean value from
a non-boolean cell
at
org.apache.poi.hssf.usermodel.HSSFCell.getBooleanCellValue(HSSFCell.java:850)
at
org.apache.poi.hssf.usermodel.HSSFCell.setCellType(HSSFCell.java:468)
at
org.apache.poi.hssf.usermodel.HSSFCell.setCellType(HSSFCell.java:329)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:289)
--
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]
