TAdvSpreadGrid Sorting on a column that is formula

VCL TMS VCL UI Pack
1

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?
2

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]

3

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.