WPF Filterable DataGrid, multi language

The new filtering method is completely different from the current version or the one commonly used to filter data (as far as I know).
Its operation is the closest to that of Excel.

How to use

Add Namespace into your xaml :

    <Window xmlns:control="http://filterdatagrid.control.com/2021" ..

Control

  <control:FilterDataGrid 
   FilterLanguage="English" DateFormatString="d" ShowStatusBar="True" ShowElapsedTime="False"
   ExcludeFields="lastname,age,manager" ...

Properties
- ShowStatusBar : displays the status bar, default : false
- ShowElapsedTime : displays the elapsed time of filtering in status bar, default : false
- ShowRowsCount : display the number of rows, default : false
- FilterLanguage : translation into available language, default : English
- ExcludeFields : comma separated fields to exclude from filter, only works in AutoGenerateColumns mode
- DateFormatString : date display format, default : "d"
⚠️ Before version 1.2.5.2, you must set the "Time" part of the DateTime fields to zero, otherwise the filter doesn't work.
see the documentation "Standard date and time format strings"

Custom TextColumn

If you add custom columns, you must set AutoGenerateColumns="False"

<control:FilterDataGrid.Columns>   
    <control:DataGridTextColumn IsColumnFiltered="True" ...

Custom TemplateColumn

⚠️ FieldName property of DataGridTemplateColumn is required

<control:FilterDataGrid.Columns>   
    <control:DataGridTemplateColumn IsColumnFiltered="True"
                             FieldName="LastName" ...

Global Style

You can define a global style which overrides the default style of "FilterDataGrid"

<Style
            x:Key="FilterDatagridStyle"
            BasedOn="{StaticResource {ComponentResourceKey TypeInTargetAssembly=control:FilterDataGrid,
                                                           ResourceId=FilterDataGridStyle}}"
            TargetType="{x:Type control:FilterDataGrid}">
            <Setter Property="Margin" Value="10" />
            <Setter Property="RowHeaderWidth" Value="40" />
     ...
</Style>

Benchmark

Intel Core i7, 2.93 GHz, 16 GB, Windows 10, 64 bits.
Tested on the "Last name" column of the demo application using a random distinct name generator, between 5 and 8 letters in length.
The elapsed time decreases based on the number of columns and filtered items.

Number of rows	Opening of the PopUp	Applying the filter	Total (PopUp + Filter)
10 000	< 1 second	< 1 second	< 1 second
100 000	< 1 second	< 1 second	< 1 second
500 000	± 2.5 second	< 1 second	± 2.6 second
1 000 000	± 4.5 second	< 1 second	± 4.8 second

Demonstration

Contributors

"# FilterDatagridWpf"