Class FilterCriteria

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

Inheritance

System.Object

FilterCriteria

Implements

IDirectResponseSchema

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class FilterCriteria : 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

[JsonProperty("condition")]
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

[JsonProperty("hiddenValues")]
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 visible_foreground_color.

Declaration

[JsonProperty("visibleBackgroundColor")]
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. This field is mutually exclusive with visible_foreground_color, and must be set to an RGB-type color. If visible_background_color is also set, this field takes precedence.

Declaration

[JsonProperty("visibleBackgroundColorStyle")]
public virtual ColorStyle VisibleBackgroundColorStyle { get; set; }

Property Value

Type	Description
ColorStyle

VisibleForegroundColor

The foreground color to filter by; only cells with this foreground color are shown. Mutually exclusive with visible_background_color.

Declaration

[JsonProperty("visibleForegroundColor")]
public virtual Color VisibleForegroundColor { get; set; }

Property Value

Type	Description
Color

VisibleForegroundColorStyle

The foreground color to filter by; only cells with this foreground color are shown. This field is mutually exclusive with visible_background_color, and must be set to an RGB-type color. If visible_foreground_color is also set, this field takes precedence.

Declaration

[JsonProperty("visibleForegroundColorStyle")]
public virtual ColorStyle VisibleForegroundColorStyle { get; set; }

Property Value

Type	Description
ColorStyle

Implements

IDirectResponseSchema