Class: Google::Apis::SheetsV4::CellData
- Inherits:
-
Object
- Object
- Google::Apis::SheetsV4::CellData
- 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
Data about a specific cell.
Instance Attribute Summary collapse
-
#data_validation ⇒ Google::Apis::SheetsV4::DataValidationRule
A data validation rule.
-
#effective_format ⇒ Google::Apis::SheetsV4::CellFormat
The format of a cell.
-
#effective_value ⇒ Google::Apis::SheetsV4::ExtendedValue
The kinds of value that a cell in a spreadsheet can have.
-
#formatted_value ⇒ String
The formatted value of the cell.
-
#hyperlink ⇒ String
A hyperlink this cell points to, if any.
-
#note ⇒ String
Any note on the cell.
-
#pivot_table ⇒ Google::Apis::SheetsV4::PivotTable
A pivot table.
-
#text_format_runs ⇒ Array<Google::Apis::SheetsV4::TextFormatRun>
Runs of rich text applied to subsections of the cell.
-
#user_entered_format ⇒ Google::Apis::SheetsV4::CellFormat
The format of a cell.
-
#user_entered_value ⇒ Google::Apis::SheetsV4::ExtendedValue
The kinds of value that a cell in a spreadsheet can have.
Instance Method Summary collapse
-
#initialize(**args) ⇒ CellData
constructor
A new instance of CellData.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ CellData
Returns a new instance of CellData
2511 2512 2513 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2511 def initialize(**args) update!(**args) end |
Instance Attribute Details
#data_validation ⇒ Google::Apis::SheetsV4::DataValidationRule
A data validation rule.
Corresponds to the JSON property dataValidation
2452 2453 2454 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2452 def data_validation @data_validation end |
#effective_format ⇒ Google::Apis::SheetsV4::CellFormat
The format of a cell.
Corresponds to the JSON property effectiveFormat
2457 2458 2459 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2457 def effective_format @effective_format end |
#effective_value ⇒ Google::Apis::SheetsV4::ExtendedValue
The kinds of value that a cell in a spreadsheet can have.
Corresponds to the JSON property effectiveValue
2462 2463 2464 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2462 def effective_value @effective_value end |
#formatted_value ⇒ String
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
2469 2470 2471 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2469 def formatted_value @formatted_value end |
#hyperlink ⇒ String
A hyperlink this cell points to, if any.
This field is read-only. (To set it, use a =HYPERLINK
formula
in the userEnteredValue.formulaValue
field.)
Corresponds to the JSON property hyperlink
2477 2478 2479 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2477 def hyperlink @hyperlink end |
#note ⇒ String
Any note on the cell.
Corresponds to the JSON property note
2482 2483 2484 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2482 def note @note end |
#pivot_table ⇒ Google::Apis::SheetsV4::PivotTable
A pivot table.
Corresponds to the JSON property pivotTable
2487 2488 2489 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2487 def pivot_table @pivot_table end |
#text_format_runs ⇒ Array<Google::Apis::SheetsV4::TextFormatRun>
Runs of rich text applied to subsections of the cell. Runs are only valid
on user entered strings, not formulas, bools, or numbers.
Runs start at specific indexes in the text and continue until the next
run. Properties of a run will continue unless explicitly changed
in a subsequent run (and properties of the first run will continue
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
2499 2500 2501 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2499 def text_format_runs @text_format_runs end |
#user_entered_format ⇒ Google::Apis::SheetsV4::CellFormat
The format of a cell.
Corresponds to the JSON property userEnteredFormat
2504 2505 2506 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2504 def user_entered_format @user_entered_format end |
#user_entered_value ⇒ Google::Apis::SheetsV4::ExtendedValue
The kinds of value that a cell in a spreadsheet can have.
Corresponds to the JSON property userEnteredValue
2509 2510 2511 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2509 def user_entered_value @user_entered_value end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2516 def update!(**args) @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 |