Excel format Difference In OpenOffce and MSExcel

[jimjohn]

Hii

I am converting my Jasper to excel using the following code.

JExcelApiExporter exporterXLS = new JExcelApiExporter();

    exporterXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT,jsperPrintObject);
            exporterXLS.setParameter(    JExcelApiExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE);
            exporterXLS.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.TRUE);
            exporterXLS.setParameter(JExcelApiExporterParameter.IS_FONT_SIZE_FIX_ENABLED,Boolean.TRUE);
            exporterXLS.setParameter(JExcelApiExporterParameter.IS_AUTO_DETECT_CELL_TYPE,Boolean.TRUE);
            exporterXLS.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);
            exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_FILE_NAME,fileName + ".xls");
            exporterXLS.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM,output);

 

In Ms excel output  format is fine .But in Open office alignment get lost..

Is there any other things which i hve to add in Code in Order to get same out put in Open Office.?

Thanking You

Jim

 

[shikhap]

What jxl version are you  using ?

 

[Teodor Danciu]

Hi,

 

What alignment is lost? Cell text alignment?

Can you post some sample file here?

 

Thank you,

Teodor