We are using your UltraSpreadsheet for one of our forms.

We have added an 'Excel Like" Ribbon.   One of the controls on the Ribbon is for Sorting.   We have developed a dialog the allows the user to define multiple levels of sorting (e.g. Name Column, then Country, the City).    We now need to build a collection that allows us to describe this multi-level sort operation, and will then apply it to the spreadsheet.

Where we are stuck is creating the initial SortSettings variable.   The definition for this is Infragistics.Documents.Excel.Sorting.SortSettings<T>, and the documentation indicates  T is a type which logically contains data and can have sort condition applied to that data.Totally understand this, but what type of object can stand in for the "T".   So far every thing that we have tried has resulted in a "cannot be used as type parameter T syntax error.   It looks like it wants an "ISortable" class.   The closest appears to be a WorksheetColumnCollection.   Of course we need to sort multiple columns...not just one.

The variable definition of:

Infragistics.Documents.Excel.Sorting.SortSettings<Infragistics.Documents.Excel.WorksheetColumnCollection> theSortSpecifications;

is accepted by the C# compiler, but we have been unable to initialize the variable - theSortSpecifications.   Basically the "New" says that 

Infragistics.Documents.Excel.Sorting.SortSettings<Infragistics.Documents.Excel.WorksheetTableColumn>  does not contain a constructor that takes zero arguments. (or 1 argument when passed a WorksheetTableColumn).

Perhaps we are totally misunderstanding what the SortConditionCollection is for....what we need is a way to have a collection that defines multiple levels of sort, with each sort being a-Z or Z-A or based on a Formatting value.   Our current intent is to use the Add method on the SortConditions member of the SortSettings.

Suggestions?   Example?