talonkrass Posted April 4, 2011 Share Posted April 4, 2011 I've updated to JasperReports 4.0.1 in my current Java implementation (from 3.7.4), and I've got a new problem. XLSX files are being reported as corrupt by Excel, and when you open them, the dates are unformatted numbers.The only way I've found to fix it so far is to set IS_DETECT_CELL_TYPE to false in the exporter.I would really like to use IS_DETECT_CELL_TYPE to get real numbers and dates in my spreadsheets, rather than strings. Is there a way to get it to work? Link to comment Share on other sites More sharing options...
talonkrass Posted April 5, 2011 Author Share Posted April 5, 2011 I was using the JRXlsxExporter when this problem occurred. I've found switching to the JExcelApiExporter to export XLS files works with IS_DETECT_CELL_TYPE set to true. 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