If you use JR 1.2.5, you could try setting the JRXlsExporterParameter.IS_DETECT_CELL_TYPE flag when exporting. This would ensure that text fields that have numerical/date expressions produce numerical/date Excel cells.
HTH, Lucian Wetzelberger, Stephen wrote: > > All, I am trying to download a report to Excel. I have used the Excel > exporter. This works well, and looks like the report from a visual > standpoint. But the data is unusable in Excel. Formulas do not work > etc. Any ideas? Thanks in advance... > > /Stephen Wetzelberger/ > /Sr. Software Engineer/ > /TBB Global Logistics/ > /(717)227-5725/ > /[EMAIL PROTECTED]/ > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > ------------------------------------------------------------------------ > > _______________________________________________ > jasperreports-questions mailing list > jasperreports-questions@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jasperreports-questions > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
