https://bz.apache.org/bugzilla/show_bug.cgi?id=66682
Bug ID: 66682
Summary: Boolean formula not handled in binary eventmodel
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 38598
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38598&action=edit
Excel binary format spreadsheet containing boolean formula
When reading a binary excel file (xlsb) using the eventmodel cells that are of
type BrtFmlaBool are not handled in the XSSFBSheetHandler.handleRecord method.
The consequence is that these cell will always yield an empty value regardless
of the evaluation of the formula.
The easy fix is to add a cell handler for this record type. Fortunately the
existing handler for BrtCellBool does what is needed, so adding a single line
with an additional case label does the job:
case BrtCellBool:
case BrtFmlaBool:
handleBoolean(data);
break;
Sample spreadsheet attached that contains cells showing this problem.
--
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]
