Hi,
I have a TAdvSpreadGrid which has a column of formulas like "=SUM(F4:AE4)". What I want to do is sort the grid on the column based on the values of these SUMs so that I get a points table in descending order but what happens is that it sorts on the actual formula string.
Is there an option that I'm completely missing?
Set the sort style to ssRaw , implement the OnRawCompare event handler and return the compare result based on grid.CellValue[col,row] instead of grid.Cells[col,row]
Bruno,
Many thanks, I've got that sort all working now.
The only issue is that the formulas don't sort themselves out:
So if Row 14 becomes Row 1 after the sort then the formula still says =SUM(F14:AE14). I can update all of the formulas in code after the sort but was wondering if there was again something that I'm missing.