I'm getting close to figuring it out, but I've got a question.
In my Compare Function I inspect the x object by doing a simple MsgBox(x.ToString())
CellValue = '14'
it would think I should be getting 14 (the actual value in the cell.
I've been following your VB code from this page and adapting it to my Listview Sort Comparer I wrote that works just fine.
https://www.syncfusion.com/kb/454/how-do-i-implement-my-own-custom-icomparer-to-sort-a-column-in-the-gridcontrol
When I look in the C++ Sorting example the comparer function has the following, which I'm lost at how to convert to VB.
//the idea is to get at the FormulaTag object in the GridStyleInfoStore passed in
//and use the FormulaTag.Text property to compare two cells.
GridStyleInfo xStyle = new GridStyleInfo((GridStyleInfoStore) x);
GridStyleInfo yStyle = new GridStyleInfo((GridStyleInfoStore) y);
string xs = (xStyle.FormulaTag != null) ? xStyle.FormulaTag.Text : "";
string ys = (yStyle.FormulaTag != null) ? yStyle.FormulaTag.Text : "";
double xd = 0;
double yd = 0;
double.TryParse(xs, System.Globalization.NumberStyles.Any, null, out xd);
double.TryParse(ys, System.Globalization.NumberStyles.Any, null, out yd);
c = xd.CompareTo(yd);
All I need is the actual cellvalue so I can check if its numeric, Date, or just string and do the appropriate type of search.
