Bug 41131

Summary: Returning null while getting the value of formula cell value.
Product: POI Reporter: Rajkumar G <rajkumar.ganapathy>
Component: POI OverallAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: Other   
OS: other   
Attachments: Excell contains some formula cells

Description Rajkumar G 2006-12-07 23:25:08 UTC
Hi, 
Im using poi-2.5.1-final-20040804.jar for read the excel file. In my excell file
some cell have formulas. When i trying to get the formula cell using
row.getCell(17) it's returning null(It's not return any values like 0 or empty). 
The code snippet is give bellow.
HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(excelFile));
HSSFSheet sheet = wb.getSheetAt(0);
row = sheet.getRow(0);
cell = row.getCell((short) 17); -- actually in my excel 17 th column have formula.

when i trying to take that it's returning null. 
Here with i'll attach the excel sheet also.

Can you please any one give a solution for this. I referred the same kind of
issues. but i don't find any solutions for this. Can you please help me this.
Comment 1 Rajkumar G 2006-12-07 23:28:27 UTC
Created attachment 19230 [details]
Excell contains some formula cells
Comment 2 Andy Oliver 2006-12-08 02:58:26 UTC
Since we do not calculate the values it is the expected behavior.  This is not
an appropriate forum to ask questions (for that you need to use the mail list)