https://issues.apache.org/bugzilla/show_bug.cgi?id=47543
Summary: Using many HSSFRichTextString cells causes Excel 2003
and lower to crash
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P1
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Creating too many HSSFRichTextString cells causes Excel 2003 and lower to crash
when changing the color of the cells and then saving the Excel file.
Run the attached Driver program, which creates a file that demonstrates the
Excel 2003 errors.
1. Run the program, then open the resulting file in Excel 2003 or lower.
2. Select all cells by clicking on the corner cell
3. Press the color toolbar button to change the color of all cells
4. Press the save button in Excel and it will crash.
Note: The row and column count is only 10 in the attached example, but if you
increse the ROWS and COLS constants to 100 in the makeData()method below, then
Excel 2003 will crash after step 3 above.
This is a critical bug for our product, with very large customers complaining
vociferously. We are running POI 3.1 now but I tested this with 3.5 beta and
get the same results.
We often generate large workbooks that contain tables with many footnotes,
hence the need for HSSFRichTextString. To work around the HSSFRichTextString
problem for other cells, we have been forced to fallback to using the
deprecated version of HSSFCell.setCellValue() that takes a plain String instead
of the recommended HSSFRichTextString.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
