Created attachment 38598 [details] 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.
linking to https://github.com/apache/poi/pull/485 so people are aware of the PR
This seems to have been applied via r1910951