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

[Nipun Tamrakar]

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]

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]

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