'Declaration Public Property FilterComparisonStyle As FilterComparisonStyle
public FilterComparisonStyle FilterComparisonStyle {get; set;}
FilterComparisonStyle affects how the grid compares the cell values to the operand of any FilterConditions applied to the column.
Note that this property has no effect when the filter condition is using a quantiative operator. This includes the following FilterComparisionOperator values: Custom, Equals, NotEquals, GreaterThan, GreaterThanOrEqualTo, LessThan, and LessThanOrEqualTo.
This property is intended to allow you more control when the filter condition is using a non-quantitative comparison like: Contains, DoesNotContain, DoesNotEndWith, DoesNotMatch, DoesNotStartWith, EndsWith, Like, Match, NotLike, and StartsWith.
This property allows you to control the behavior of non-quantitative comparsions. It's typically used when you want to change the filtering behavior of strings when using operators like Contains, StartsWith, or EndsWidth.
The MeetsCriteria method of the filter condition looks at FilterComparisonStyle to determine how to compare the cell's value to the filter operand. You can specify display text, value, or both for comparison. The display text is the test the user sees on the screen. The value is the raw, unformatted value of the cell. This typically only makes sense for numeric values that are being formatted via the format property and when using a filter that typically applies to strings like StartsWith, EndsWith, or Contains.
Note that there are some exceptions. For example, specifying ValueOnly will not compare to the raw value of a cell if there is a ValueList in the cell which is converting the value into some user-friendly display text.
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2