You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/10/18 13:20:42 UTC
[Bug 55668] New: nullPointerException when using
setCellType(Cell.CELL_TYPE_STRING) when the cell have an expression with
empty result
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: dev@poi.apache.org
Reporter: ghaleb@tradeos.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55668] nullPointerException when using
setCellType(Cell.CELL_TYPE_STRING) when the cell have an expression with
empty result
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55668
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS| |All
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Can you please attach a test-xls-file which has this setup to allow to
reproduce the problem easily?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 55668] nullPointerException when using
setCellType(Cell.CELL_TYPE_STRING) when the cell have an expression with
empty result
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55668
--- Comment #2 from Ghaleb <gh...@tradeos.com> ---
Created attachment 31003
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31003&action=edit
Try to convert all cells to String using
cell.setCellType(Cell.CELL_TYPE_STRING);
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org