I have a report that may look like this simplified:
String, String, Integer, Integer, String
Or sometimes, i could change dynamicaly and look like this:
String, String, String, Integer, Integer
Or any other combination.
Is there any way i can get Excel reports to format numbers as numbers and strings as strings?
I can't set the correct datatypes of my textfields in templates, because it is determined on runtime. The only way I see i using the API to replace textfields with designTextfields, which can have their class type set.
Am I missing something, or is this the only way? Any help is very appreciated:)
You probably need to set the property net.sf.jasperreports.export.xls.detect.cell.type to true on your report. See here: