omb Posted June 26, 2008 Share Posted June 26, 2008 Hi, I am using JavaBeanDataSource to populate reports. The field values are defined as java.math.BigDecimal types in .jrxml files. Corresponding bean methods return BigDecimal values to populate the report. I see that xls file contain "Number as text" warning instead of these BigDecimal fields stored as numerical values. I saw an earlier thread that recommended using JExcelApi instead of POI to export to XLS file. I have tried both the libraries with same result. Appreciate any help in this regard. Thanks. Link to comment Share on other sites More sharing options...
lucianc Posted June 26, 2008 Share Posted June 26, 2008 Which JasperReports version are you using? Do you set the IS_DETECT_CELL_TYPE flag to true? If this happens when IS_DETECT_CELL_TYPE is set, please include more information (e.g. JRXML template, XLS output, etc). Regards,Lucian Link to comment Share on other sites More sharing options...
omb Posted June 27, 2008 Author Share Posted June 27, 2008 Thanks, setting the IS_DETECT_CELL_TYPE fixed the XLS output. 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