poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55668] New: nullPointerException when using setCellType(Cell.CELL_TYPE_STRING) when the cell have an expression with empty result
Date Fri, 18 Oct 2013 11:20:42 GMT
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


Mime
View raw message