DO NOT REPLY [Bug 20321] - "NO IDEA SHARED FORMULA EXP PTG" appears when read copy/paste formula

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

DO NOT REPLY [Bug 20321] - "NO IDEA SHARED FORMULA EXP PTG" appears when read copy/paste formula

Bugzilla from bugzilla@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=20321>.
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=20321





------- Additional Comments From [hidden email]  2005-06-07 20:36 -------
Created an attachment (id=15330)
 --> (http://issues.apache.org/bugzilla/attachment.cgi?id=15330&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: [hidden email]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/