Class FilterCriteria

Criteria for showing/hiding rows in a filter or filter view.

Inheritance
System.Object
FilterCriteria
Namespace: Google.Apis.Sheets.v4.Data
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class FilterCriteria : object, IDirectResponseSchema

Properties

Condition

A condition that must be true for values to be shown. (This does not override hidden_values -- if a value is listed there, it will still be hidden.)

Declaration
public virtual BooleanCondition Condition { get; set; }
Property Value
Type Description
BooleanCondition

ETag

The ETag of the item.

Declaration
public virtual string ETag { get; set; }
Property Value
Type Description
System.String

HiddenValues

Values that should be hidden.

Declaration
public virtual IList<string> HiddenValues { get; set; }
Property Value
Type Description
System.Collections.Generic.IList<System.String>

VisibleBackgroundColor

The background fill color to filter by; only cells with this fill color are shown. Mutually exclusive with all other filter criteria. Requests to set this field fail with a 400 error if any other filter criteria field is set.

Declaration
public virtual Color VisibleBackgroundColor { get; set; }
Property Value
Type Description
Color

VisibleBackgroundColorStyle

The background fill color to filter by; only cells with this fill color are shown. Mutually exclusive with all other filter criteria. Requests to set this field fail with a 400 error if any other filter criteria field is set. If visible_background_color is also set, this field takes precedence.

Declaration
public virtual ColorStyle VisibleBackgroundColorStyle { get; set; }
Property Value
Type Description
ColorStyle

VisibleForegroundColor

The text color to filter by; only cells with this text color are shown. Mutually exclusive with all other filter criteria. Requests to set this field fail with a 400 error if any other filter criteria field is set.

Declaration
public virtual Color VisibleForegroundColor { get; set; }
Property Value
Type Description
Color

VisibleForegroundColorStyle

The text color to filter by; only cells with this text color are shown. Mutually exclusive with all other filter criteria. Requests to set this field fail with a 400 error if any other filter criteria field is set. If visible_foreground_color is also set, this field takes precedence.

Declaration
public virtual ColorStyle VisibleForegroundColorStyle { get; set; }
Property Value
Type Description
ColorStyle

Implements