Wrap Text not changing row height

[druchti]

I am adding text to a cell that will go beyond the width of the cell. I have added WrapText = true to the cell. However, the row does not grow in size to accommodate all the text. How do I fix this?

I have attached the template xltx file I am using.

Here is the code.

Workbook oWorkbook = new Workbook();
oWorkbook.LoadFromFile("C:\\Users\\a05998\\Documents\\Visual Studio Projects\\ScreenShots\\SpireXLS\\bin\\Debug\\template1.xltx");
Worksheet oWorkSheet = oWorkbook.Worksheets[0];

CellRange oRange = oWorkSheet.FindString("#SpecialInstruction", false, false);
oRange.Style.WrapText = true;


oRange.Text = "Special instruction number one. Special instruction number two. Special instruction number three. Special instruction number four. Special instruction number five.";

[Alan.Li]

Hi,

Well, the behavior is the same as MS Excel, if there are some merged cells in the worksheet with wrapping text on, you cannot auto-fit the row operation on those cells. You can check this behavior in MS Excel manually doing the steps. Spire.Xls follows MS Excel standards.
For your requirement, you should set the height.

Code: Select all

oRange.RowHeight = 100;

Sincerely,
Alan
E-iceblue support team