Unfortunately, it is not possible to assign a value to a cell if it is text with more than 32767 characters. Excel does not support it. The exception you see is correctly enforcing the limits of the Excel file format. You can find all limits for Excel 2013 here.

FYI, due to a fix for issue 103739 in the latest SR of versions 11.1 and later, the cell's WrapText value will be automatically set to True when it is Default and text with newlines is set on the cell. This is mimic how MS Excel automatically turns on wrap text for a cell when Alt+Enter is used to add newlines in that cell.

Here is an updated link: http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=ExcelEngine_Populating_a_Worksheet_from_a_DataSet.html

You should save the state of any controls that need to be loaded into dock panes. Then, before you load the layout for the dock manager, you should create the controls (if they don't already exist), give them the same Name they had before, and reinitialize them with any state that you have saved. You must also add them somewhere in the control hierarchy of the Form (or UserControl) in which the UltraDockManager resides. I like to create a temporary Panel which is hidden for this purpose so you don't see any flicker on screen. I have attached a relatively simple sample which does this.

Actually, you only need to set the FillPatternForegroundColor to a non-empty value and the FillPatternStyle will default to Solid. I know the naming is a little strange, but the FillPatternBackgroundColor is only used when you have some sort of pattern filling the cell and that color is then the alternate color for the pattern.

It's possible this could be named in a slightly better way, but at this point, it would be a breaking change to rename the property.

This sounds like it may be a bug with the Excel library. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.