| Summary: | StackOverflowError formatting a cell value which contains a formula | ||
|---|---|---|---|
| Product: | POI | Reporter: | Trejkaz (pen name) <trejkaz> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | major | ||
| Priority: | P2 | ||
| Version: | 3.7-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Mac OS X 10.4 | ||
The attachment is missing, please try again. Yegor "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. 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 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. Is it possible to provide your swapgraph.xls again ? Sample file is not available any more, so we cannot reproduce this problem, therefore resolving this for now, please reopen with more information if this is still a problem for you. Even if I manage to find the attachment: 1. The bug tracker won't let me attach it because you have the limit set too low. 2. If I post it elsewhere, nobody will ever look at it and then someone will be asking for it again in a few years, just like this time. Maybe you could get a copy off the last person who asked for it? |
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