https://issues.apache.org/bugzilla/show_bug.cgi?id=55668
Bug ID: 55668
Summary: nullPointerException when using
setCellType(Cell.CELL_TYPE_STRING) when the cell have
an expression with empty result
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Steps:
open excel
write an expression inside the cell
the cell result should be empty (null in POI HSSF workbook)
save as xls file
Read the file using POI and try to convert it to String by using
setCellType(Cell.CELL_TYPE_STRING)
--
the cell have a value of:
=IF('Q:\Comune\A&O division\SALES\GRIGLIE\CALCULATIONS\AIR EXPORT\[GRID
COSTI.xlsx]FreightOS'!A758="","",'Q:\Comune\A&O
division\SALES\GRIGLIE\CALCULATIONS\AIR EXPORT\[GRID
COSTI.xlsx]FreightOS'!A758)
And the result(or the cached value is blank)
--
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]
