ok, I was able to produce a small dummy report file that illustrates the text format issue. Since it's a small file, it cannot be used to illustrate the large memory footprint issue. The Jasper generated XLSX file is attached. I used the following code to examine the content of this Jasper generated XLSX file:
Workbook doc1 = new Workbook("C:/Temp/Test_In_File.xlsx");
debugXlsx(doc1);
public static void debugXlsx(Workbook wb) throws Exception {
WorksheetCollection wsc = wb.getWorksheets();
Worksheet ws = wsc.get(0);
Cells cells = ws.getCells();
ColumnCollection cc = cells.getColumns();
RowCollection rc = cells.getRows();
int colCount = cc.getCount();
int rowCount = rc.getCount();
for (int rowIdx = 0; rowIdx < rowCount; rowIdx++) {
Row r = rc.get(rowIdx);
System.out.print("[" + rowIdx + "]: ");
for (int colIdx = 0; colIdx < colCount; colIdx++) {
Cell cell = r.get(colIdx);
Style style = cell.getStyle();
Font font = style.getFont();
if (font.isBold()) {
System.out.print("B");
}
if (font.isItalic()) {
System.out.print("I");
}
if (font.isStrikeout()) {
System.out.print("S");
}
System.out.print(",");
}
System.out.println();
}
}
The above code will print the letter B if it sees that the cell is bold, and I if italic and S if strikeout, and the following was being printed on the console (first 20 lines). As you can see, pretty much every cell was reported to be bold, italic and strikethrough. However, if you open the attached Jasper generated XLSX file in Microsoft Excel, there is no bold, italic or strikethrough content.
[0]: BIS,BIS,BIS,BIS,,,,,,,,,,,,,,,,,,,,,,
[1]: BIS,BIS,BIS,BIS,,,,,,,,,,,,,,,,,,,,,,
[2]: BIS,BIS,,,,,,,,,,,,,,,,,,,,,,,,
[3]: BIS,BIS,,,,,,,,,,,,,,,,,,,,,,,,
[4]: BIS,BIS,,,,,,,,,,,,,,,,,,,,,,,,
[5]: BIS,BIS,,,,,,,,,,,,,,,,,,,,,,,,
[6]: BIS,,,,,,,,,,,,,,,,,,,,,,,,,
[7]: BIS,BIS,,,,,,,,,,,,,,,,,,,,,,,,
[8]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[9]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[10]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[11]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[12]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[13]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[14]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[15]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[16]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[17]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[18]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[19]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,
[20]: BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,BIS,