Excel row content gets cut off

[kingsteff]

Hello there,

my problem is:

everytime i generate a report as an XLS File, i got much content in every cell (text only) an this content is beeing automatically cut off, especially when there is a line break in it.

"This is an

example"

--> only  "This is an" is the content of the cell.

 

how can i fix this? enlarge cell height or width won't do the trick, cause what is if there are two or three line breaks??

 

thanks for help

 

steff

[lucianc]

You should either set isStretchWithOverflow="true" for the text fields (in which case the text field will stretch at fill time), or set the net.sf.jasperreports.print.keep.full.text property to true (in which case the text field would not change its height, but the entire text will be present in the Excel cell).

HTH,

Lucian

[kingsteff]

finally i got the answer. because i dont want to strech the cells, bute also what to be the content into it.

i set the property

net.sf.jasperreports.print.keep.full.text  = TRUE (thanks for the answer also)

which is false by default.

so try this if u have the same problems

bye

 

steff

Post Edited by kingsteff at 04/20/2009 09:54

[naveennaliath]

How to set  'Keep full text 'Programatically?

[annaclause]

How do you set the text field?

[shamphadtale]

You can set property programaticaly as - jasperPrint.getPropertiesMap().setProperty("net.sf.jasperreports.print.keep.full.text", "true");