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.
2854 2855 2856 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2854 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
2795 2796 2797 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2795 def data_validation @data_validation end |
#effective_format ⇒ Google::Apis::SheetsV4::CellFormat
The format of a cell.
Corresponds to the JSON property effectiveFormat
2800 2801 2802 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2800 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
2805 2806 2807 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2805 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
2812 2813 2814 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2812 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
2820 2821 2822 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2820 def hyperlink @hyperlink end |
#note ⇒ String
Any note on the cell.
Corresponds to the JSON property note
2825 2826 2827 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2825 def note @note end |
#pivot_table ⇒ Google::Apis::SheetsV4::PivotTable
A pivot table.
Corresponds to the JSON property pivotTable
2830 2831 2832 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2830 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
2842 2843 2844 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2842 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
2847 2848 2849 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2847 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
2852 2853 2854 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2852 def user_entered_value @user_entered_value end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 2859 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 |