class Google::Apis::SheetsV4::CellData
Data about a specific cell.
Attributes
A data source formula. Corresponds to the JSON property `dataSourceFormula` @return [Google::Apis::SheetsV4::DataSourceFormula]
A data source table, which allows the user to import a static table of data from the DataSource
into Sheets. This is also known as “Extract” in the Sheets editor. Corresponds to the JSON property `dataSourceTable` @return [Google::Apis::SheetsV4::DataSourceTable]
A data validation rule. Corresponds to the JSON property `dataValidation` @return [Google::Apis::SheetsV4::DataValidationRule]
The format of a cell. Corresponds to the JSON property `effectiveFormat` @return [Google::Apis::SheetsV4::CellFormat]
The kinds of value that a cell in a spreadsheet can have. Corresponds to the JSON property `effectiveValue` @return [Google::Apis::SheetsV4::ExtendedValue]
The formatted value of the cell. This is the value as it's shown to the user. This field is read-only. Corresponds to the JSON property `formattedValue` @return [String]
A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell- level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell. Corresponds to the JSON property `hyperlink` @return [String]
Any note on the cell. Corresponds to the JSON property `note` @return [String]
A pivot table. Corresponds to the JSON property `pivotTable` @return [Google::Apis::SheetsV4::PivotTable]
Runs of rich text applied to subsections of the cell. Runs are only valid on user entered strings, not formulas, bools, or numbers. Properties of a run start at a specific index in the text and continue until the next run. Runs will inherit the properties of the cell unless explicitly changed. When writing, the new runs will overwrite any prior runs. When writing a new user_entered_value
, previous runs are erased. Corresponds to the JSON property `textFormatRuns` @return [Array<Google::Apis::SheetsV4::TextFormatRun>]
The format of a cell. Corresponds to the JSON property `userEnteredFormat` @return [Google::Apis::SheetsV4::CellFormat]
The kinds of value that a cell in a spreadsheet can have. Corresponds to the JSON property `userEnteredValue` @return [Google::Apis::SheetsV4::ExtendedValue]
Public Class Methods
# File lib/google/apis/sheets_v4/classes.rb, line 2539 def initialize(**args) update!(**args) end
Public Instance Methods
Update properties of this object
# File lib/google/apis/sheets_v4/classes.rb, line 2544 def update!(**args) @data_source_formula = args[:data_source_formula] if args.key?(:data_source_formula) @data_source_table = args[:data_source_table] if args.key?(:data_source_table) @data_validation = args[:data_validation] if args.key?(:data_validation) @effective_format = args[:effective_format] if args.key?(:effective_format) @effective_value = args[:effective_value] if args.key?(:effective_value) @formatted_value = args[:formatted_value] if args.key?(:formatted_value) @hyperlink = args[:hyperlink] if args.key?(:hyperlink) @note = args[:note] if args.key?(:note) @pivot_table = args[:pivot_table] if args.key?(:pivot_table) @text_format_runs = args[:text_format_runs] if args.key?(:text_format_runs) @user_entered_format = args[:user_entered_format] if args.key?(:user_entered_format) @user_entered_value = args[:user_entered_value] if args.key?(:user_entered_value) end