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=36941>. 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=36941 Summary: HSSFCell.getCellFormula() returns "NO IDEA SHARED FORMULA EXP PTG" Product: POI Version: 3.0-dev Platform: All OS/Version: All Status: NEW Severity: major Priority: P2 Component: HSSF AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] I have an Excel file with some formulas, some of them return "NO IDEA SHARED FORMULA EXP PTG" when I use: HSSFCell.getCellFormula() I have found some postings and some bugs with similar issues, some seem to fixed, some not. Seems to have something to do with "shared formulas". Since I use the latest version of POI (poi-3.0-alpha1-20050704.jar) and I don't know if it's the same issue, I opened a new bug to attatch my excel sheet causing the problems. I cannot reproduce such a "problematic" excel sheet by myself, it comes from someone else. If I change the values of some cells in the sheet, that's not a problem. I also can copy the cells to an other spreadsheet or workbook - the problem "survives". Only if I remove a complete row or a complete column before (in Excel!), the formulas suddenly appear when I try to read them using HSSFCell.getCellFormula(). You can find the problematic cells / formulas in G59:G64 I also attatched a (very) simple java class for testing. Some other Bugs/Postings talk about similar problems and patches for it, but I can't find a POI version where these patches are applied, or it must be a different problem. I don't understand how people can use Formula Reading from POI, the error happend with the latest version of POI and with the third Excel file I ever tested! -- 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/
