Can anyone tell me how to wrap text in Comma Separated Value format? in jasper report The text I am trying to wrap are in the column header , which are static text. Is there any way that all the column headings are wrapped instead of merging. actually I have 9 columns, and in csv, some of the column heading are merged cells (3 of them) the others are not merged (since there is not much space), so only part of the heading text is shown by default. You have to drag the column width manually in excel sheet to view the full heading. I am supposed to make the heading visible by default. So in case it is not merge cells and wrap text, all of them will be visible. Please tell me how to wrap text?
The other thing that I tried increasing the page width so that all my column headings come on the page with merge cells and I do not need to wrap the text but the effect is displayed only in P.D.F and the comma separated value format (C.S.V) page width is not increased. Can anyone tell me how to increase the Comma separated value format page width?