Text Wrap in Excel Export

[parthbhagat]

Hi all,

 

I am trying to export my report in Excel file with the help of JExcelApiExporter. With that what is happening that, when value of a cell having value is very long in size then it uses cell of next row. In this scenario variable JRXlsAbstractExporterParameter.IS_COLLAPSE_ROW_SPAN is not set to True.

If I set this variable to True then it will not merge rows which actually need to happen.

I have also tried isStretchWithOverflow="true" for the particular textfield. But not found proper results.

 

I had attached images of the results with & without flag JRXlsAbstractExporterParameter.IS_COLLAPSE_ROW_SPAN flag.

 

Thanking you,

Parth Bhagat.

Post Edited by parthbhagat at 09/07/2010 04:33