DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=41131>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41131 Summary: Returning null while getting the value of formula cell value. Product: POI Version: unspecified Platform: Other OS/Version: other Status: NEW Severity: normal Priority: P2 Component: POI Overall AssignedTo: poi-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] 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. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
