jasper reports - Display Full Text in Excel without truncation

Question

How to display Full Text in Excel without truncation programatically? Currently the data is getting truncated. Is it possible to automatically adjust the row height so as to display the enitre text?

Answer 1

I got these problems also and solved them this way:
For the first one, add the following property to your report:

net.sf.jasperreports.print.keep.full.text

and put it to true

You can also add this property to a specific text field. For more information, refer to this link

For the second one, as Deathtiny says, add isStretchWithOverflow=true to the field that you want, for it to grow with the amount of text in it.

I hope this helps.