IsTextWrapped problem


#1

If I set the IsTextWrapped property on a cell and display the spreadsheet, the text is wrapped correctly but the row is not sized to fit the text.

If you type in say “hello world. This is a test” into a cell in Excel and go to the Format Cells option, if you check the Wrap Text option and ok it, the text is wrapped and the row resized to fit the text in.

Why does the Aspose component not do this?


#2

Dear Haydn,

Thank for your consideration.

Generally speaking, the AutoFit function is a slow function. In MS Excel, you will not find the slowness of the AutoFit. But if you want to wrap many cells, automatically calling autofix function will slow down your program.

You can set the IsTextWrapped property on many cells and call AutoFitRow once. That will speed up the program.