Vaadin 7 ExcelExport exported file is not correctly formatted.

Flow
1

I have my own class extends ExcelExport. I used it in my code as follows:-

ExcelExportFA2 excelExport = new ExcelExportFA2(exportTable);
excelExport.excludeCollapsedColumns();
excelExport.setUseTableFormatPropertyValue(true);
excelExport.setDisplayTotals(true);
excelExport.setReportTitle(null);
excelExport.setDateDataFormat(SalkkuTM.getI18N("dateFormat"));

try{
    excelExport.setExportFileName( getCaption().replace(" ", "_") + "_" +
            new ExcelExportUtil().getDateString(new Date()) + ".xls" );
}catch(Exception e){
    excelExport.setExportFileName(SalkkuTM.getI18N("ExportFile.caption"));
}

excelExport.export();

It exports the file. But the file total row is not correctly formatted. It is left aligned. How can I make it right aligned? Please check the exported as attachment.

17077540.xls (5 KB)

2

Generally you should consult the documentation of that particular extension for more info; in this case [TableExport]
(https://vaadin.com/directory/component/tableexport). Briefly looking at the ExcelExport class it looks like the best bet is to override the ExcelExport.defaultTotalsDoubleCellStyle() method and reconfigure the CellStyle.alignment property.