skalle Posted October 24, 2008 Share Posted October 24, 2008 Hi.I`m have a report that is exported to excel, the report is created using ireport 1.2.8. The excel output seems ok at first sight, but all numeric values are inside a cell with "general" format in excel. I want the numeric values to be formatted as number in excel as well, in ireport the corresponding values are bigdecimal.What I`ve done so far is check the is detect cell type in export options, but it didn`t help. Then I checked my jrxml manually and added (this property should probably have been there allready since I checked the detect cell type in Ireport, but it wasn`t there) But no luck, even when I added the property manually the xls output file still is formatting my bigdecimal values as general and not number. Any ideas? I have to use version 1.2.8. I will apreciate clarifying responses. Thanks.<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true" /> Link to comment Share on other sites More sharing options...
honeyani Posted October 24, 2008 Share Posted October 24, 2008 Hi ,I use iReport version 3.0.0 ,Detect cell type works fine in this version.Can you update the tool version and check this out.Thanks,Ani Link to comment Share on other sites More sharing options...
skalle Posted October 24, 2008 Author Share Posted October 24, 2008 Hi.I tried Ireport 3.0.0, using this version it seems to work. The cell in excel are still general though, but it seems that they are number not text. Does not version 1.2.8 support this kind of format handling? Or is it a bug? Link to comment Share on other sites More sharing options...
bluematrix Posted February 21, 2012 Share Posted February 21, 2012 I'm having the same issue using version 4.1.3.I make the adjustments to the properties and set "net.sf.jasperreports.export.xls.detect.cell.type" to true. I also adjust the pattern of the cell to "#,##0.00". 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