Can i prevent auto merging cell when using subreport in excel?

[tranquoctu1988]

 Hi everyone,

I've tried to use sub report at Group Footer Band. Everything are good when i using PDF exporter but when i change to XLSX export it will auto merging cell in my report. I tried to set all parameter i can find in Excel exporter but it's not work:

        exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

        exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS, Boolean.FALSE);

        exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

        exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);

        exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_GRAPHICS, Boolean.FALSE);

        exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

        exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);

 

My report and sub report have the same column number and the same column width.

I'm sorry about my bad English skill!

Can you give me an advice to fix this problem?????

Thank you so much.

 

 

[tranquoctu1988]

I had attached my export problem file.

[tranquoctu1988]

Can anyone give me an advance? WIth me, it really a very big problem.