Using IsTextWrapped

Aspose.Cells Product Family
1

Hi,

I am using the following code to set the text wrap.

cell[i,j].Style.IsTextWrapped = true;

the width has been set to '83'. When i get the excel the text is not wrapped. I have attached the excel for your referance. In the second row the headers are displayed horizontally insted of being wrapped.

Do i need to set the shrink fit property also. Should height also be set for this property to work?

Rgds

Soumya

2

Please call AutoFitRow method to extend height of headers.

workbook.Worksheets["Sheet2"].AutoFitRow(3);