jasper reports - Number display as # in generated Excel file -


i have excel file generated jasperreports. can see here excel's column display ### if number long. don't want resize width of column, want display number without seen ### , stretch height. have tried set column stretch overflow , stretch type = relative band height

this screenshot:

enter image description here

you need set appropriate jasper reports excel property on report element, or on whole report iself. documentation: http://jasperreports.sourceforge.net/sample.reference/xlsfeatures/

specifically

net.sf.jasperreports.export.xls.column.width.ratio 

if these properties not available in jasperreports version, may have fiddle around sizing decent.


Comments

Popular posts from this blog

Using 'OR' and 'AND' in SQL Server -

c++ - NetBeans Remote Development with additional configuration -

visual studio - TFS will not accept changes I've made to a Java project -