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.

Error: Row Height must be in range from 0 to 409

Thread ID:

Created:

Updated:

Platform:

Replies:

63789 Jul 10,2007 12:59 AM Jul 10,2007 05:15 AM ASP.NET Web Forms (Classic) 2
loading
Tags: XlsIO
Nipun Tamrakar
Asked On July 10, 2007 12:59 AM

Hello

When i try to add a lot of text in one cell it gives the following error.
"Row Height must be in range from 0 to 409 Parameter name: RowHeight Actual value was 714.189447099285."

I need to add text of bigger size in one cell. It works perfectly when i directly add large text in MS Excel. Please help.

Nipun Tamrakar
Replied On July 10, 2007 04:52 AM

I found out that the error was caused due to following line i was using.

sheet.UsedRange.AutofitRows()

So now i want to do something like

IF sheet.UsedRange.RowHeight < 410 then
sheet.UsedRange.AutofitRows()
End IF
But sheet.UsedRange.RowHeight gives a very small negative value and the condition is always true.
Is there any way to acheive this solution ?
Thank you

Melba Winshia [Syncfusion]
Replied On July 10, 2007 05:15 AM

Hi Nipun,

Ms Excel has limitation on the Row height. Please refer the following link for more details

http://www.datadynamics.com/forums/602/ShowPost.aspx
http://office.microsoft.com/en-us/excel/HP051992911033.aspx

Kindly let me know if you have any other questions.

Thanks,
Melba

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.

;