Page 1 of 1

Autoheight not working correctly

Posted: Fri Aug 05, 2016 9:35 pm
by 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?

Re: Autoheight not working correctly

Posted: Wed Aug 10, 2016 8:32 am
by larsa
Hello

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

Re: Autoheight not working correctly

Posted: Fri Aug 19, 2016 10:15 am
by 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.