Autoheight not working correctly

[edbuescher]

I have an xlsx file created with a different 3rd party component. One of the columns has multi-line text in it. When I open it in Excel it looks fine with the rows properly sized to fit the multi-line text, but if I read that file into an XLSReadWriteII 5 component and then do a procedure call similar to:
LastRow:=XLS.Sheets[0].LastRow;
XLS.Sheets[0].AutoHeightRows(0,LastRow);
then the rows are adjusted as if there was only one long line of text in the column, not multiple lines.
Am I doing something wrong here?

[larsa]

Hello

No. Multi line cells are not supported in auto height. Will probably add this feature to the next major update.

[taz.higgins]

We also have this problem.
It used to work with older versions of XLSRW (build 21ish I think) with XLS, but it doesn't work with the current version.