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/10/05 22:36:52 UTC
DO NOT REPLY [Bug 36941] New: -
HSSFCell.getCellFormula() returns "NO IDEA SHARED FORMULA EXP PTG"
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: poi-dev@jakarta.apache.org
ReportedBy: akorthaus@web.de
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: 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/