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 2005/06/07 20:14:52 UTC
DO NOT REPLY [Bug 26502] -
[PATCH] Conversion of Shared Formula to individual Formula
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=26502>.
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=26502
------- Additional Comments From vani.narasimhan@nscorp.com 2005-06-07 20:14 -------
Created an attachment (id=15328)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=15328&action=view)
getCellFormula() returns NO IDEA SHARED FORMULA EXP PTG
The last column is a formula column in my attached excel sheet ,it is not
being read by POI.
System.out.println("srcCell.getCellFormula() ="+srcCell.getCellFormula());
returns "NO IDEA SHARED FORMULA EXP PTG"
It fails in HSSFFormulaEvaluator at the following code block
FormulaParser parser = new FormulaParser(srcCell.getCellFormula(),
workbook.getWorkbook());
parser.parse(); //as parser expected an excel formula rather than a
String
Can anyone help me read the formula cell's value.
Thanks
regards
Vani.
--
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/