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.



7248
7249
7250
# File 'lib/google/apis/sheets_v4/classes.rb', line 7248

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



7233
7234
7235
# File 'lib/google/apis/sheets_v4/classes.rb', line 7233

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)


7240
7241
7242
# File 'lib/google/apis/sheets_v4/classes.rb', line 7240

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


7246
7247
7248
# File 'lib/google/apis/sheets_v4/classes.rb', line 7246

def visible_values
  @visible_values
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



7253
7254
7255
7256
7257
# File 'lib/google/apis/sheets_v4/classes.rb', line 7253

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