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 [EMAIL PROTECTED] 2005-09-01 09:51 ------- How soon can we expect the resolution to "Shared Formulas are not rendered at this time, that's why you get the "SHARED FORMULA EXP PTG"." or its already released. - Is there a quick fix to excel without having to go and type the formulae again (manually) (In reply to comment #8) > Created an attachment (id=15330) --> (http://issues.apache.org/bugzilla/attachment.cgi?id=15330&action=view) [edit] > 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. (In reply to comment #8) > Created an attachment (id=15330) --> (http://issues.apache.org/bugzilla/attachment.cgi?id=15330&action=view) [edit] > 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. (In reply to comment #8) > Created an attachment (id=15330) --> (http://issues.apache.org/bugzilla/attachment.cgi?id=15330&action=view) [edit] > 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
