I'm having troubles in Jasper to force the excel cell format to "Text" (instead of "General") when the cell content is a STRING even though it can be easily done in JExcel:
sheet.addCell(new Label(1,1,"test",new WritableCellFormat(NumberFormats.TEXT)))
I believe that the problem is in JExcelApiMetadataExporter, the CellTextValueHandler doesn't try to use the cellComplexFormat if the cell contains a string type.
Is that correct (in which case it would be nice if that problem could be fixed ! :-)), or did I miss anything obvious ?