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 2007/05/20 23:00:35 UTC
DO NOT REPLY [Bug 42464] New: - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
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=42464>.
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=42464
Summary: Parsing spreadsheet results in "Expected ExpPtg to be
converted from Shared to Non-Shared Formula"
Product: POI
Version: 3.0-dev
Platform: Other
OS/Version: other
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: david.karr@wamu.net
I'm using v3.0-rc4. I have a app that uses POI that I've been using to parse
spreadsheets and generate data from. I just got a new version of the
spreadsheet with some innocuous changes, and it now fails with the exception
that follows this. I would provide this spreadsheet in the bug, but it has
customer data in it. I would try to narrow down the test case, but I don't even
know what this exception means, so I'm not sure what to remove from the test case.
org.apache.poi.hssf.record.RecordFormatException: Coding Error: Expected ExpPtg
to be converted from Shared to Non-Shared Formula
at org.apache.poi.hssf.record.formula.ExpPtg.toFormulaString(ExpPtg.java:78)
at org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:886)
at org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:868)
at org.apache.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:630)
at
com.wamu.uia.riskrating.genmessages.GenRiskRatingMessageFiles.getCellValue(GenRiskRatingMessageFiles.java:1032)
at
com.wamu.uia.riskrating.genmessages.GenRiskRatingMessageFiles.getCellValue(GenRiskRatingMessageFiles.java:1069)
at
com.wamu.uia.riskrating.genmessages.GenRiskRatingMessageFiles.buildLoanData(GenRiskRatingMessageFiles.java:933)
at
com.wamu.uia.riskrating.genmessages.GenRiskRatingMessageFiles.go(GenRiskRatingMessageFiles.java:356)
at
com.wamu.uia.riskrating.genmessages.GenRiskRatingMessageFiles.main(GenRiskRatingMessageFiles.java:247)
--
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/
DO NOT REPLY [Bug 42464] - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
Posted by bu...@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=42464>.
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=42464
------- Additional Comments From david.karr@wamu.net 2007-12-12 13:13 -------
Created an attachment (id=21265)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=21265&action=view)
Ant-based test case that demonstrates both a "good" and "bad" spreadsheet
This test case does not include the poi jar files. They have to be copied into
the "lib" directory, and then modify the "build.properties" file. This
information is echoed in the README.txt file in the zip file.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 42464] - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
Posted by bu...@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=42464>.
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=42464
------- Additional Comments From david.karr@wamu.net 2007-05-20 15:19 -------
Created an attachment (id=20222)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=20222&action=view)
This is a "sanitized" version of the spreadsheet that causes the problem
--
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/
DO NOT REPLY [Bug 42464] - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
Posted by bu...@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=42464>.
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=42464
------- Additional Comments From david.karr@wamu.net 2007-12-12 06:38 -------
It simply has to do with the number of columns. If I remove columns one by one,
it will get to a state where the bug doesn't occur. It's been a while since
I've looked at this, but I'm pretty sure it's only when accessing those "wide"
columns that it happens. Accessing the initial columns doesn't trigger the bug.
If that's not enough info, I can try setting up this test case again and
generate a sheet with the maximum number of columns that doesn't trigger the bug.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 42464] - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
Posted by bu...@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=42464>.
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=42464
nick@torchbox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution| |FIXED
------- Additional Comments From nick@torchbox.com 2008-01-08 15:02 -------
Finally fixed in trunk
Eventually tracked it down to the silliest of things - using a signed 8 bit
value instead of an unsigned 8 bit value, so very long columns weren't being
matched to their shared formulas, as the shared formula ran to column -127...
With the signing issue fixed, we can parse the formula on both spreadsheets
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 42464] - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
Posted by bu...@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=42464>.
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=42464
nick@torchbox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
------- Additional Comments From nick@torchbox.com 2007-12-12 03:57 -------
Are you able to do another version of this spreadsheet that's almost the same,
but doesn't trigger the bug?
Ideally, we want two very similar versions of the spreadsheet, one which
triggers the bug, and one that doesn't. That way, it'll be much easier for us to
spot what area the change lies in, to narrow down what's wrong.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 42464] - Parsing spreadsheet results in "Expected ExpPtg to be converted from Shared to Non-Shared Formula"
Posted by bu...@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=42464>.
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=42464
------- Additional Comments From nick@torchbox.com 2007-12-12 06:44 -------
If you could knock out some columns until you have a sheet with n columns that
works, and n+1 columns that doesn't, then that'd be great.
(We want to get the two sheets as similar as possible, but have one work
completely, and the other not. Only having a sheet where some columns work and
some don't leaves a few more unknown variables than we'd like)
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org