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 2006/12/08 08:25:08 UTC
DO NOT REPLY [Bug 41131] New: - Returning null while getting the value of formula cell value.
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: rajkumar.ganapathy@iflexsolutions.com
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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41131] - Returning null while getting the value of formula cell value.
Posted by bu...@apache.org.
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
acoliver@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
------- Additional Comments From acoliver@apache.org 2006-12-08 02:58 -------
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)
--
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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41131] - Returning null while getting the value of formula cell value.
Posted by bu...@apache.org.
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
------- Additional Comments From rajkumar.ganapathy@iflexsolutions.com 2006-12-07 23:28 -------
Created an attachment (id=19230)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=19230&action=view)
Excell contains some formula cells
--
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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/