TAdvStringGrid and filtering hidden columns

VCL TMS VCL UI Pack
1

I have a problem with filtering data in TAdvStringGrid. The example – grid has two
columns, one with name, the other with ID. Both columns are visible, I enter a
filter in the first column (Name), the data in the second column (ID) filter
according to the first. However, if I hide the ID column and enter a filter in the
Name column, the ID is incorrect. Data in the hidden columns are not filtered,
so when I retrieve the ID from the selected row I get incorrect data.

Grid with the data.

713×415 12.7 KB


Both columns are visible, I enter the filter in
the first column and get ID – it  is
correct.
713×415 10.3 KB


I'm hiding the ID column.
713×415 11.5 KB


I enter the filter in the first column and get
ID - it is wrong - 1 instead of 3.
713×415 9.79 KB


How to filter the data in hidden columns?

2

Can you use grid.SuppressColumn() to hide  the column instead of grid.HideColumn(), that should solve your issue.

3

Indeed this solution works well. Thank you so much for your help.