yaramada123 Posted July 19, 2007 Share Posted July 19, 2007 Hi, I am trying to export a 16 digit number into XLS, but it is getting exported as exponential number. 1. I used JXL api to open the sheet and edit the number so that it is displayed as normal number. 2. The problem I am facing is, If I am exporting 5000323421232345, the last digit is getting replaced with 0 instead of 5 as it is getting converted to exponential number 5.0000E+15 when Jasper exports it into XLS. How do I get around this problem, I can turn of IS_AUTO_CELL_DETECT_TYPE as there are numbers in other columns. Please let me know if any one knows a solution for this. Link to comment Share on other sites More sharing options...
lucianc Posted July 24, 2007 Share Posted July 24, 2007 Follow-up here. 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