FilterValue.FilterByBlank Property

Gets a special value representing a blank cell for use in a filter criteria.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public static FilterValue FilterByBlank { get; }

VB.NET

Public Shared ReadOnly Property FilterByBlank As FilterValue

Property Value

Type	Description
FilterValue	A FilterValue object.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FilterByBlank property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/AutoFilterActions.cs#L84

AutoFilterColumn products = worksheet.AutoFilter.Columns[1];
products.ApplyCustomFilter("*Gi*", FilterComparisonOperator.Equal, FilterValue.FilterByBlank, FilterComparisonOperator.Equal, false);
#endregion #FilterTextByCondition

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/AutoFilterActions.cs#L125

AutoFilterColumn products = worksheet.AutoFilter.Columns[1];
products.ApplyCustomFilter("*Gi*", FilterComparisonOperator.Equal, FilterValue.FilterByBlank, FilterComparisonOperator.Equal, false);
#endregion #FilterTextByCondition

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/AutoFilterActions.vb#L70

            Dim products As DevExpress.Spreadsheet.AutoFilterColumn = worksheet.AutoFilter.Columns(1)
            products.ApplyCustomFilter("*Gi*", DevExpress.Spreadsheet.FilterComparisonOperator.Equal, DevExpress.Spreadsheet.FilterValue.FilterByBlank, DevExpress.Spreadsheet.FilterComparisonOperator.Equal, False)
#End Region  ' #FilterTextByCondition

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/AutoFilterActions.vb#L121

                Dim products As AutoFilterColumn = worksheet.AutoFilter.Columns(1)
                products.ApplyCustomFilter("*Gi*", FilterComparisonOperator.Equal, FilterValue.FilterByBlank, FilterComparisonOperator.Equal, False)
'                #End Region ' #FilterTextByCondition

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/AutoFilterActions.vb#L120

                Dim products As AutoFilterColumn = worksheet.AutoFilter.Columns(1)
                products.ApplyCustomFilter("*Gi*", FilterComparisonOperator.Equal, FilterValue.FilterByBlank, FilterComparisonOperator.Equal, False)
'                #End Region ' #FilterTextByCondition