Class FilterCriteria

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

Inheritance

object

FilterCriteria

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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
string

HiddenValues

Values that should be hidden.

Declaration

[JsonProperty("hiddenValues")]
public virtual IList<string> HiddenValues { get; set; }

Property Value

Type	Description
IList<string>

VisibleBackgroundColor

The background fill color to filter by; only cells with this fill color are shown. Mutually exclusive with visible_foreground_color. Deprecated: Use visible_background_color_style.

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. Deprecated: Use visible_foreground_color_style.

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