class Google::Apis::SheetsV4::DataFilter
Filter that describes what data should be selected or returned from a request.
Attributes
Selects data that matches the specified A1 range. Corresponds to the JSON property `a1Range` @return [String]
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` @return [Google::Apis::SheetsV4::DeveloperMetadataLookup]
A range on a sheet. All indexes are zero-based. Indexes are half open, i.e. 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` @return [Google::Apis::SheetsV4::GridRange]
Public Class Methods
# File lib/google/apis/sheets_v4/classes.rb, line 3673 def initialize(**args) update!(**args) end
Public Instance Methods
Update properties of this object
# File lib/google/apis/sheets_v4/classes.rb, line 3678 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