Axolot Data

Posted: **Mon Oct 20, 2014 1:14 pm**

Hello!

Please, help me. How to set row height automaticaly depending on the cell content?
This code does not work on XLSReadWriteII v5.20.36 (((

Code: Select all

  
  x[0].MergeCells(0,0, 5,0);
  x[0].Cell[0,0].FontStyle := [xfsBold];
  x[0].Cell[0,0].FontSize  := 12;
  x[0].Cell[0,0].HorizAlignment := chaCenter;
  x[0].AsString[0,0] := 'very very very very very very very very very very very very very very very very long text';
  x[0].AutoHeightRow(0);

Posted: **Tue Oct 21, 2014 9:04 am**

Hello

This will not work for the following reasons:

1. Your text is only one line of text.
2. If you want a text to fit to the width of a column you must set: XLS[0].Cell[0,0].WrapText := True;
3. AutoRowHeight don't work with wrapped text.

Posted: **Thu Oct 23, 2014 7:50 am**

Yes, my text has only one line of text.
OK, I can set in Excel "TextWrap" and increase RowHeight manualy, but it isn't what I need! There are too many such cells in output file (((
Why AutoRowHeight doesn't work with wrapped text?

Posted: **Tue Oct 28, 2014 10:41 am**

Can you answer me - why AutoRowHeight doesn't work with wrapped text?

Posted: **Wed Oct 29, 2014 6:53 am**

Hello

It's not implemented.

Posted: **Thu Oct 30, 2014 6:52 am**

Can you implement this feature?

Posted: **Fri Oct 31, 2014 8:26 am**

Hello

It will probably be implemented in the next major release.

Posted: **Tue Nov 04, 2014 5:00 pm**

Thank you!

Please, tell me when you plan to make next major release?

Axolot Data

AutoHeightRow

AutoHeightRow

Re: AutoHeightRow

Re: AutoHeightRow

Re: AutoHeightRow

Re: AutoHeightRow

Re: AutoHeightRow

Re: AutoHeightRow

Re: AutoHeightRow