mtvgn Posted May 6, 2011 Share Posted May 6, 2011 Hi,when searching for how to get the numbers in my Excel export as numbers instead of general fields in the xls-document I found this: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=54927At this moment I've set theexporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);in the java code (and yes, when I put a breakpoint there I know the code is being executed when creating a report) and I've put the following line among the other property lines in the jrxml file and after that I reopened the report in iReport and compiled it and waited for RAD to pick up the new version and publish it.: <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true" />And still I'm getting everything as general fields in the excel field, no matter if their type is String, Long, BigDecimal or Date ... why??I'm using iReport 3.0.0., maybe thath helps. I just don't get that when there are two ways of letting the excel format be "as detected" and I've implemented both, it still is "do it yourself!"I hope anyone here has a solution for this as it feels like I'm out of options.mtvgn 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