Class: Google::Apis::SheetsV4::PivotFilterCriteria

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
generated/google/apis/sheets_v4/classes.rb,
generated/google/apis/sheets_v4/representations.rb,
generated/google/apis/sheets_v4/representations.rb

Overview

Criteria for showing/hiding rows in a pivot table.

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ PivotFilterCriteria

Returns a new instance of PivotFilterCriteria.



7102
7103
7104
# File 'generated/google/apis/sheets_v4/classes.rb', line 7102

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#conditionGoogle::Apis::SheetsV4::BooleanCondition

A condition that can evaluate to true or false. BooleanConditions are used by conditional formatting, data validation, and the criteria in filters. Corresponds to the JSON property condition



7087
7088
7089
# File 'generated/google/apis/sheets_v4/classes.rb', line 7087

def condition
  @condition
end

#visible_by_defaultBoolean Also known as: visible_by_default?

Whether values are visible by default. If true, the visible_values are ignored, all values that meet condition (if specified) are shown. If false, values that are both in visible_values and meet condition are shown. Corresponds to the JSON property visibleByDefault

Returns:

  • (Boolean)


7094
7095
7096
# File 'generated/google/apis/sheets_v4/classes.rb', line 7094

def visible_by_default
  @visible_by_default
end

#visible_valuesArray<String>

Values that should be included. Values not listed here are excluded. Corresponds to the JSON property visibleValues

Returns:

  • (Array<String>)


7100
7101
7102
# File 'generated/google/apis/sheets_v4/classes.rb', line 7100

def visible_values
  @visible_values
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



7107
7108
7109
7110
7111
# File 'generated/google/apis/sheets_v4/classes.rb', line 7107

def update!(**args)
  @condition = args[:condition] if args.key?(:condition)
  @visible_by_default = args[:visible_by_default] if args.key?(:visible_by_default)
  @visible_values = args[:visible_values] if args.key?(:visible_values)
end