Is there a way to filter the contents of a string grid?

[vfclists]

Is there a way to filter the contents of a string grid?

I am thinking of a routine that can hide the rows which do not match the content, but can restore them into view when the filter is removed.

Is there some kind of property that can make a string grid row hidden like those in a database, or something like setting row heights to zero and getting navigation of browsing events to skip over the zero height rows?

[Mike.Cornflake]

None that I'm aware of :-(

[taazz]

use virtualtreeview it has a grid mode and can filter and sort.

[vfclists]

If a string grid's purpose is to display data only and the contents are not edited in any way will a list box be a suitable replacement?

I have seen TListFilterEdit which enables the elements of List Box to be filtered.

@taazz I will checkout the VirtualTreeView as well.

PS. What is the difference between a list box and list view?

[taazz]

If a string grid's purpose is to display data only and the contents are not edited in any way will a list box be a suitable replacement?

I have seen TListFilterEdit which enables the elements of List Box to be filtered.

@taazz I will checkout the VirtualTreeView as well.

PS. What is the difference between a list box and list view?

The list box has a single field that is show in list a list view has nodes can be viewed as a tree, grid, or simple a list of icons. A list view is the most configurable single control you can find and that is why it breaks a lot of common grounds to do it.

[jesusr]

Is there a way to filter the contents of a string grid?

I am thinking of a routine that can hide the rows which do not match the content, but can restore them into view when the filter is removed.

Is there some kind of property that can make a string grid row hidden like those in a database, or something like setting row heights to zero and getting navigation of browsing events to skip over the zero height rows?

What is the problem on setting wished rows height to zero?. If you need to find which rows were hidden use the same rows height as marker or use grid.Objects[0, row] as marker. Or maybe I'm missing something?

[sashozs]

The first problem I can see is doing calculations. If you just hide the rows (or columns) by setting the height or width to 0, they are still virtually there, so you can't correctly do calculations based on the visible parts of the table... Well ok, except if you add a routine that will check the height/width of the row/column before taking it in consideration on calculating

So, I believe filters might be of a great use in the stringgrid.

[jamie]

The first problem I can see is doing calculations. If you just hide the rows (or columns) by setting the height or width to 0, they are still virtually there, so you can't correctly do calculations based on the visible parts of the table... Well ok, except if you add a routine that will check the height/width of the row/column before taking it in consideration on calculating

So, I believe filters might be of a great use in the stringgrid.

Please look at the posted date.

 I am sure by now the problem has been solved. 

[vfclists]

The first problem I can see is doing calculations. If you just hide the rows (or columns) by setting the height or width to 0, they are still virtually there, so you can't correctly do calculations based on the visible parts of the table... Well ok, except if you add a routine that will check the height/width of the row/column before taking it in consideration on calculating

So, I believe filters might be of a great use in the stringgrid.

Please look at the posted date.

 I am sure by now the problem has been solved. 

I don't see any information that StringGrids can be filtered unless you are referring to the technique shown at https://gitlab.com/freepascal.org/lazarus/lazarus/-/issues/38473

[jcmontherock]

In OnStringGridDrawCell event you have the control of each cell and/or row to be drawn.

[Thaddy]

See this, it is related.
https://forum.lazarus.freepascal.org/index.php/topic,68354.msg528243.html#msg528243

[vfclists]

See this, it is related.
https://forum.lazarus.freepascal.org/index.php/topic,68354.msg528243.html#msg528243

The example you quoted brings to mind the Linux sort and cut commands

I just implemented a quick and dirty version based on hiding the grid rows by setting  TStringGrid'RowHeights[aRow] := 0.

https://forum.lazarus.freepascal.org/index.php/topic,68362.msg528280/topicseen.html#new

Critiques welcome.