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 2013/01/10 07:44:23 UTC
[Bug 54400] New: StackOverflowError formatting a cell value which
contains a formula
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
Bug ID: 54400
Summary: StackOverflowError formatting a cell value which
contains a formula
Product: POI
Version: 3.7
Hardware: PC
OS: Mac OS X 10.4
Status: NEW
Severity: major
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: trejkaz@trypticon.org
Classification: Unclassified
A collection of Excel files trigger a StackOverflowException with both POI 3.7
and 3.9.
Attached is the first file where I have managed to track it down to the
problematic cell. There are two other files supposedly with the same issue.
This is all publicly-accessible data, as I understand it.
Minimal code required for reproduction:
@Test
public void test() throws Exception
{
File file = new File("z:\\Data\\swapgraph.xls");
HSSFWorkbook workbook = new HSSFWorkbook(new POIFSFileSystem(new
FileInputStream(file)));
HSSFSheet sheet = workbook.getSheetAt(25);
HSSFRow row = sheet.getRow(5);
HSSFCell cell = row.getCell(1);
new HSSFDataFormatter().formatCellValue(cell, new
HSSFFormulaEvaluator(workbook));
}
Stack trace I have pasted here: http://pastie.org/5659697
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54400] StackOverflowError formatting a cell value which
contains a formula
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> ---
The 5MB restriction is not set by POI, we can't increase the attachement limit.
Option 1: Can you remove all sheets/rows/cells other than the problematic one
and attach the reduced file?
Option2: Can you put the bug file in Dropbox or Google Drive or in any other
file tracker ?
Yegor
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54400] StackOverflowError formatting a cell value which
contains a formula
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
--- Comment #4 from Trejkaz (pen name) <tr...@trypticon.org> ---
Hopefully this is accessible.
http://depositfiles.com/files/g2xzbqh60
I tried to remove sheets but the error changes as a result. Even if I don't
remove a sheet, just opening and closing the file with POI is enough to change
the error from one error to a different error.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54400] StackOverflowError formatting a cell value which
contains a formula
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
--- Comment #5 from yvesdm <yv...@gmail.com> ---
Is it possible to provide your swapgraph.xls again ?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54400] StackOverflowError formatting a cell value which
contains a formula
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
Trejkaz (pen name) <tr...@trypticon.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54400] StackOverflowError formatting a cell value which
contains a formula
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> ---
The attachment is missing, please try again.
Yegor
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54400] StackOverflowError formatting a cell value which
contains a formula
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54400
--- Comment #2 from Trejkaz (pen name) <tr...@trypticon.org> ---
"The file you are trying to attach is 5102 kilobytes (KB) in size. Attachments
cannot be more than 1000 KB.
We recommend that you store your attachment elsewhere and then paste the URL to
this file on the attachment creation page in the appropriate text field."
If you have a better place for this, feel free to suggest one.
Limiting the size of attachments doesn't really make for a productive bug
tracker.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org