class Google::Apis::SheetsV4::CellData

Data about a specific cell.

Attributes

data_source_formula[RW]

A data source formula. Corresponds to the JSON property `dataSourceFormula` @return [Google::Apis::SheetsV4::DataSourceFormula]

data_source_table[RW]

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]

data_validation[RW]

A data validation rule. Corresponds to the JSON property `dataValidation` @return [Google::Apis::SheetsV4::DataValidationRule]

effective_format[RW]

The format of a cell. Corresponds to the JSON property `effectiveFormat` @return [Google::Apis::SheetsV4::CellFormat]

effective_value[RW]

The kinds of value that a cell in a spreadsheet can have. Corresponds to the JSON property `effectiveValue` @return [Google::Apis::SheetsV4::ExtendedValue]

formatted_value[RW]

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]

note[RW]

Any note on the cell. Corresponds to the JSON property `note` @return [String]

pivot_table[RW]

A pivot table. Corresponds to the JSON property `pivotTable` @return [Google::Apis::SheetsV4::PivotTable]

text_format_runs[RW]

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

user_entered_format[RW]

The format of a cell. Corresponds to the JSON property `userEnteredFormat` @return [Google::Apis::SheetsV4::CellFormat]

user_entered_value[RW]

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

new(**args) click to toggle source
# File lib/google/apis/sheets_v4/classes.rb, line 2539
def initialize(**args)
   update!(**args)
end

Public Instance Methods

update!(**args) click to toggle source

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