Problem StatementJasper Report Export to excel is not working when report name has special character. Report name : Test: Sample report Report Id: test_sample_report getting error as below. I can get it corrected by changing removing the column : to space, but is there a configuration I can use the sheet name as report id. I am currently using 7.2.0, this used to work fine in previous release 5.4 Error MessageInvalid char : found at index (4) in sheet name 'Test: Sample report'[/code]Error Tracejava.lang.IllegalArgumentException: Invalid char : found at index (4) in sheet name 'Test: Sample report'' at org.apache.poi.ss.util.WorkbookUtil.validateSheetName(WorkbookUtil.java:153) at org.apache.poi.hssf.record.BoundSheetRecord.setSheetname(BoundSheetRecord.java:94) at org.apache.poi.hssf.model.InternalWorkbook.setSheetName(InternalWorkbook.java:530) at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:817) at net.sf.jasperreports.engine.export.JRXlsExporter.createSheet(JRXlsExporter.java:338) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportSheet(JRXlsAbstractExporter.java:1275) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:890) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:837) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:687) at com.jaspersoft.jasperserver.war.action.ReportExcelExporter.export(ReportExcelExporter.java:126) at com.jaspersoft.jasperserver.war.action.Abstr[/code]
