Class: Google::Apis::SheetsV4::DataFilter
- Inherits:
-
Object
- Object
- Google::Apis::SheetsV4::DataFilter
- 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
Filter that describes what data should be selected or returned from a request.
Instance Attribute Summary collapse
-
#a1_range ⇒ String
Selects data that matches the specified A1 range.
-
#developer_metadata_lookup ⇒ Google::Apis::SheetsV4::DeveloperMetadataLookup
Selects DeveloperMetadata that matches all of the specified fields.
-
#grid_range ⇒ Google::Apis::SheetsV4::GridRange
A range on a sheet.
Instance Method Summary collapse
-
#initialize(**args) ⇒ DataFilter
constructor
A new instance of DataFilter.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ DataFilter
Returns a new instance of DataFilter
3875 3876 3877 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3875 def initialize(**args) update!(**args) end |
Instance Attribute Details
#a1_range ⇒ String
Selects data that matches the specified A1 range.
Corresponds to the JSON property a1Range
3834 3835 3836 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3834 def a1_range @a1_range end |
#developer_metadata_lookup ⇒ Google::Apis::SheetsV4::DeveloperMetadataLookup
Selects DeveloperMetadata that matches all of the specified fields. For
example, if only a metadata ID is specified this considers the
DeveloperMetadata with that particular unique ID. If a metadata key is
specified, this considers all developer metadata with that key. If a
key, visibility, and location type are all specified, this considers all
developer metadata with that key and visibility that are associated with a
location of that type. In general, this
selects all DeveloperMetadata that matches the intersection of all the
specified fields; any field or combination of fields may be specified.
Corresponds to the JSON property developerMetadataLookup
3847 3848 3849 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3847 def @developer_metadata_lookup end |
#grid_range ⇒ Google::Apis::SheetsV4::GridRange
A range on a sheet.
All indexes are zero-based.
Indexes are half open, e.g the start index is inclusive
and the end index is exclusive -- [start_index, end_index).
Missing indexes indicate the range is unbounded on that side.
For example, if "Sheet1"
is sheet ID 0, then:
Sheet1!A1:A1 == sheet_id: 0,
start_row_index: 0, end_row_index: 1,
start_column_index: 0, end_column_index: 1
Sheet1!A3:B4 == sheet_id: 0,
start_row_index: 2, end_row_index: 4,
start_column_index: 0, end_column_index: 2
Sheet1!A:B == sheet_id: 0,
start_column_index: 0, end_column_index: 2
Sheet1!A5:B == sheet_id: 0,
start_row_index: 4,
start_column_index: 0, end_column_index: 2
Sheet1 == sheet_id:0
The start index must always be less than or equal to the end index.
If the start index equals the end index, then the range is empty.
Empty ranges are typically not meaningful and are usually rendered in the
UI as #REF!
.
Corresponds to the JSON property gridRange
3873 3874 3875 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3873 def grid_range @grid_range end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
3880 3881 3882 3883 3884 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3880 def update!(**args) @a1_range = args[:a1_range] if args.key?(:a1_range) @developer_metadata_lookup = args[:developer_metadata_lookup] if args.key?(:developer_metadata_lookup) @grid_range = args[:grid_range] if args.key?(:grid_range) end |