Autoheight not working correctly
Posted: Fri Aug 05, 2016 9:35 pm
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?
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?