AutofitRow

[Simon]

I have used the AutofitRow method to fit a row to the text. Is it possible to get the row height of that has been "autofitted"? eg.

sht["A1"].Value2 = "Long text"
sht["A1"].WrapText = true;
sht.AutofitRow(1);
double rowHeight = sht.Rows[0].RowHeight;

The above code does not return the new value of the row height but the previous value;

Any help would be much appreciated.

[Administrator]

Hi Simon,

Thank you for your interest in Syncfusion Essential ExcelRW.

This issue has been identified as a bug and will be fixed as soon as possible. I will update this thread with more information when this issue gets fixed. Thank you for your patience.

Best regards,

Stephen.

>I have used the AutofitRow method to fit a row to the text. Is it possible to get the row height of that has been "autofitted"? eg.
>
>sht["A1"].Value2 = "Long text"
>sht["A1"].WrapText = true;
>sht.AutofitRow(1);
>double rowHeight = sht.Rows[0].RowHeight;
>
>The above code does not return the new value of the row height but the previous value;
>
>Any help would be much appreciated.

[Amal Ibrahim]

Hi,
I have the same issue. Did you have a fix for this issue?

[Yavanaarasi G]

Hi Amal,

Thank you for your interest in Syncfusion products.

I regret to let you that currently we do not have support to obtain the new height of the Row when WrapText property is set to true for a cell using XlsIO. We have logged feature request regarding this. We will get back to you once the feature is implemented.

An option to obtain the row height with wrap text but the actual row height is not set by xlsIO. This would mean that excel calculates the row height and we have a helper method that returns the approx height.

Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Windows/42240_2/main.htm

It will not return accurate height, but it will return only the approximate height.

Please let me know if you have any questions.

Regards,
G.Yavana