IronPython to set column sort order
I am trying to figure out how to assign a sort order to an existing column in the data set. Basically, I need to make sure that after reloading data, a string column is set to "Natural" sort order instead of "Default" sort order.
I was able to access the DataColumn.Properties.Comparer method and see that when the column's sort method is "Natural" it returns a "NatrualStringComparer" that exists in the Spotfire.Dxp.Data.Collections assembly. However, when trying to import and initialize an instance of this comparer, it can't be found or imported.
Any help on assiging a Natural String Comparer to this Comparer property of the data column?