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

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/sheets_v4/classes.rb,
lib/google/apis/sheets_v4/representations.rb,
lib/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.



7123
7124
7125
# File 'lib/google/apis/sheets_v4/classes.rb', line 7123

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



7108
7109
7110
# File 'lib/google/apis/sheets_v4/classes.rb', line 7108

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)


7115
7116
7117
# File 'lib/google/apis/sheets_v4/classes.rb', line 7115

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>)


7121
7122
7123
# File 'lib/google/apis/sheets_v4/classes.rb', line 7121

def visible_values
  @visible_values
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



7128
7129
7130
7131
7132
# File 'lib/google/apis/sheets_v4/classes.rb', line 7128

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