Excel Error in Linux

[bcaramu]

Hi,

 

I written below code create excel file. the excel file was created successfully in both environments like windows & Linux.  Created excel file is opening without any errors in Windows execution. But when am opening file created in LInux execution file getting error like below

 

Microsoft Office Excel File Repair Log

Errors were detected in file 'C:Documents and Settingsramakrishna.gLocal SettingsTemporary Internet FilesOLKD8CMC_CreditOne_200812302326_902.xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.

Code:

JRXlsExporter exporter = new JRXlsExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT,	print);File destFile = new File(exportLocation, reportName + "."+ EXTENSION_XLS);exporter.setParameter(JRExporterParameter.OUTPUT_FILE,destFile);exporter.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BORDER,Boolean.TRUE);exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IGNORE_PAGE_MARGINS,Boolean.TRUE);exporter.exportReport();exportedFile = exportLocation + "" + reportName + "."+ EXTENSION_XLS;	

[smdelfin]

"Microsoft Office Excel File Repair Log

Errors were detected in file 'file.xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

This is not an error isolated to Linux. I'm using Ireport for Netbeans on the Windows platform. I noticed that this error usually occurs on the newer version of Ireport. For older version of ireport, this error doesn't occur.

[monty241070]

Hi,

we have the same problem since running on Jasper Reports 3.1.0 and poi-3.0.1-FINAL-20070705.jar. Problem does not occur with jasperreport 2.0.4.

Problem occurs when running on Linux with Java 1.6 and Tomcat 6.

Sometimes repairs are succesfull. Sometimes absolutely not :-(

 

Guido

[riesvantwisk]

Same problem here, try to use JExcelApiExporter and see if that solves your problem.

 

I also tried jasperReports 3.1.4 with POI 3.2 final, but that didn't solve the problem.

 

Ries

[jmrunge]

I had same problem and solved with JExcelApiExporter as Ries sugested.

 

Thanks Ries!!

[teodord]

Hi,

 

If you have some files that would help us reproduce the problem, please post them on the trackers here:

http://jasperforge.org/projects/jasperreports/bugtracking/reportadvance

 

Thank you,

Teodor

 

[teodord]

Hi,

 

We managed to get a hold of this problem and solved it. The fix will be part of the next release. Until then, use the JExcelApiExporter, or try the SVN head version. These two exporters have almost the same capabilities.

 

Thank you,

Teodor