We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

AutofitRow

Thread ID:

Created:

Updated:

Platform:

Replies:

18534 Sep 1,2004 10:23 PM Apr 11,2008 08:41 AM Windows Forms 3
loading
Tags: XlsIO
Simon
Asked On September 1, 2004 10:23 PM

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 [Syncfusion]
Replied On September 1, 2004 11:36 PM

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
Replied On April 10, 2008 08:59 AM

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



Yavanaarasi G [Syncfusion]
Replied On April 11, 2008 08:41 AM

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



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;