trrrrev Posted January 31, 2012 Share Posted January 31, 2012 Greetings. Upon exprorting a report to either XLSX or Excel various java numerical types (BigDecimal,integer,double,float,number) are converted to "text" on export. Apparently adding the following line net.sf.jasperreports.export.xls.detect.cell.type=true to the file apache-tomcat/webapps/jasperserver/WEB-INF/classes/jasperreports.properties should fix the problem. But it hasn't , and yes I restarted the jasperserver after making the change. out setup. jasperserver 4.1.0 , linux. Any ideas? Link to comment Share on other sites More sharing options...
mgeise Posted February 1, 2012 Share Posted February 1, 2012 Your field may have a numeric type, but what about the text field you are displaying it from in your report. Check the Expression Class on you text field. Link to comment Share on other sites More sharing options...
trrrrev Posted February 1, 2012 Author Share Posted February 1, 2012 Yeah, the types im referring to are the text field types, not the field types. The field types are also numeric. Is their a way to dump java properties for a running java? I want to verify that the excel export setting is being loaded. Link to comment Share on other sites More sharing options...
trrrrev Posted February 1, 2012 Author Share Posted February 1, 2012 problem solved. The issues is the known bug in iReports 4.1 and up, by which text field expression class is not saved. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now