Naveen
Naveen

Reputation: 141

Display Full Text in Excel without truncation

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?

Upvotes: 11

Views: 15173

Answers (2)

skw
skw

Reputation: 526


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.

Upvotes: 12

Deathtiny
Deathtiny

Reputation: 748

Try to set the isStretchWithOverflow property to True for the concerned textfield :

<textField isStretchWithOverflow="true">
   ...
</textField>

It worked for me.

Upvotes: 6

Related Questions