Databases
StackOverflow2013
Postsdbo
POExcel crashes and misdisplays files written using Apache POI (in the Excel 87-2003 .XLS format)
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExcel crashes and misdisplays files written using Apache POI (in the Excel 87-2003 .XLS format)
    text
    copied!<p>our Java EE applications writes large (>3000 rows, >300 columns) Excel files using Apache POI. We have implemented the customer's requirement that many (>500) of the cells in the written file have a partial text formatting, i.e. the text in <em>one</em> cell is partially red and bold, and partially black. </p> <p>Apache POI does not complain when writing the files, and they can be opened, BUT Excel 97 misdisplays them: parts of the cells have the wrong font size, and cells with multiple font colors cannot be changed (altering the font size on them does not work). </p> <p>Also, Excel 2010 complains that the file is insecure (when downloaded from the server), and both Excel 97 and Excel 2010 crash on the exported files frequently. </p> <p>The previous version of the application used JExcelApi and did not write multiformatted text cells. The files generated by the server using the previos (JExcelApi-powered) version of the application do display normally in Office2010, without the security warning. </p> <p>Did anyone come across these issues and if so, how can I fix them?</p> <p>Also, did anyone figure out why setting AutoFilters fails to show up in Office 2010 in the specified, yet shows up in Excel 97 correctly (so it sometimes crashes or works just until one AutoFilter is selected?). </p> <p>Finally, I have tried to roundtrip an Excel export of the older version of the application, and found that Apache POI reduces the file size by >35%, while breaking the file's contents - although no changes are applied (just reading the file into a HSSF Workbook and re-writing it into a ByteArrayOutputStream. Did anyone figure out how to prevent POI from altering the written file?</p> <p>Thanks, </p> <p>Michael </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload