Return-Path: Delivered-To: apmail-jakarta-poi-dev-archive@www.apache.org Received: (qmail 75175 invoked from network); 7 Jun 2005 18:15:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Jun 2005 18:15:10 -0000 Received: (qmail 73695 invoked by uid 500); 7 Jun 2005 18:15:09 -0000 Delivered-To: apmail-jakarta-poi-dev-archive@jakarta.apache.org Received: (qmail 73679 invoked by uid 500); 7 Jun 2005 18:15:08 -0000 Mailing-List: contact poi-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "POI Developers List" Reply-To: "POI Developers List" Delivered-To: mailing list poi-dev@jakarta.apache.org Received: (qmail 73640 invoked by uid 99); 7 Jun 2005 18:15:08 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=NO_REAL_NAME,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from ajax-1.apache.org (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 07 Jun 2005 11:15:05 -0700 Received: by ajax.apache.org (Postfix, from userid 99) id 71D0519B; Tue, 7 Jun 2005 20:14:52 +0200 (CEST) From: bugzilla@apache.org To: poi-dev@jakarta.apache.org Subject: DO NOT REPLY [Bug 26502] - [PATCH] Conversion of Shared Formula to individual Formula X-Bugzilla-Reason: AssignedTo Message-Id: <20050607181452.71D0519B@ajax.apache.org> Date: Tue, 7 Jun 2005 20:14:52 +0200 (CEST) X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG� RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT . 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/