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 hiddenValues -- 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 all other filter criteria. Requests to set this field will fail with a 400 error if any other filter criteria field is set.

Declaration

[JsonProperty("visibleBackgroundColor")]
public virtual Color VisibleBackgroundColor { get; set; }

Property Value

Type	Description
Color

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 will fail with a 400 error if any other filter criteria field is set.

Declaration

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

Property Value

Type	Description
Color

Implements

IDirectResponseSchema