Class: Google::Apis::SheetsV4::SheetProperties

Inherits:
Object
  • Object
show all
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

Properties of a sheet.

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ SheetProperties

Returns a new instance of SheetProperties



4561
4562
4563
# File 'generated/google/apis/sheets_v4/classes.rb', line 4561

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#grid_propertiesGoogle::Apis::SheetsV4::GridProperties

Properties of a grid. Corresponds to the JSON property gridProperties



4553
4554
4555
# File 'generated/google/apis/sheets_v4/classes.rb', line 4553

def grid_properties
  @grid_properties
end

#hiddenBoolean Also known as: hidden?

True if the sheet is hidden in the UI, false if it's visible. Corresponds to the JSON property hidden

Returns:

  • (Boolean)


4547
4548
4549
# File 'generated/google/apis/sheets_v4/classes.rb', line 4547

def hidden
  @hidden
end

#indexFixnum

The index of the sheet within the spreadsheet. When adding or updating sheet properties, if this field is excluded then the sheet will be added or moved to the end of the sheet list. When updating sheet indices or inserting sheets, movement is considered in "before the move" indexes. For example, if there were 3 sheets (S1, S2, S3) in order to move S1 ahead of S2 the index would have to be set to 2. A sheet index update request will be ignored if the requested index is identical to the sheets current index or if the requested new index is equal to the current sheet index + 1. Corresponds to the JSON property index

Returns:

  • (Fixnum)


4530
4531
4532
# File 'generated/google/apis/sheets_v4/classes.rb', line 4530

def index
  @index
end

#right_to_leftBoolean Also known as: right_to_left?

True if the sheet is an RTL sheet instead of an LTR sheet. Corresponds to the JSON property rightToLeft

Returns:

  • (Boolean)


4541
4542
4543
# File 'generated/google/apis/sheets_v4/classes.rb', line 4541

def right_to_left
  @right_to_left
end

#sheet_idFixnum

The ID of the sheet. Must be non-negative. This field cannot be changed once set. Corresponds to the JSON property sheetId

Returns:

  • (Fixnum)


4536
4537
4538
# File 'generated/google/apis/sheets_v4/classes.rb', line 4536

def sheet_id
  @sheet_id
end

#sheet_typeString

The type of sheet. Defaults to GRID. This field cannot be changed once set. Corresponds to the JSON property sheetType

Returns:

  • (String)


4559
4560
4561
# File 'generated/google/apis/sheets_v4/classes.rb', line 4559

def sheet_type
  @sheet_type
end

#tab_colorGoogle::Apis::SheetsV4::Color

Represents a color in the RGBA color space. This representation is designed for simplicity of conversion to/from color representations in various languages over compactness; for example, the fields of this representation can be trivially provided to the constructor of "java.awt.Color" in Java; it can also be trivially provided to UIColor's "+colorWithRed:green:blue:alpha" method in iOS; and, with just a little work, it can be easily formatted into a CSS "rgba()" string in JavaScript, as well. Here are some examples: Example (Java): import com.google.type.Color; // ... public static java.awt.Color fromProto(Color protocolor) float alpha = protocolor.hasAlpha() ? protocolor.getAlpha().getValue() : 1.0; return new java.awt.Color( protocolor.getRed(), protocolor.getGreen(), protocolor.getBlue(), alpha); public static Color toProto(java.awt.Color color) float red = (float) color.getRed(); float green = (float) color.getGreen(); float blue = (float) color.getBlue(); float denominator = 255.0; Color.Builder resultBuilder = Color .newBuilder() .setRed(red / denominator) .setGreen(green / denominator) .setBlue(blue / denominator); int alpha = color.getAlpha(); if (alpha != 255) result.setAlpha( FloatValue .newBuilder() .setValue(((float) alpha) / denominator) .build()); return resultBuilder.build(); // ... Example (iOS / Obj-C): // ... static UIColor* fromProto(Color* protocolor) float red = [protocolor red]; float green = [protocolor green]; float blue = [protocolor blue]; FloatValue* alpha_wrapper = [protocolor alpha]; float alpha = 1.0; if (alpha_wrapper != nil) alpha = [alpha_wrapper value]; return [UIColor colorWithRed:red green:green blue:blue alpha:alpha]; static Color* toProto(UIColor* color) CGFloat red, green, blue, alpha; if (![color getRed:&red green:&green blue:&blue alpha:&alpha]) return nil; Color* result = [Color alloc] init]; [result setRed:red]; [result setGreen:green]; [result setBlue:blue]; if (alpha <= 0.9999) [result setAlpha:floatWrapperWithValue(alpha)]; [result autorelease]; return result; // ... Example (JavaScript): // ... var protoToCssColor = function(rgb_color) var redFrac = rgb_color.red || 0.0; var greenFrac = rgb_color.green || 0.0; var blueFrac = rgb_color.blue || 0.0; var red = Math.floor(redFrac * 255); var green = Math.floor(greenFrac * 255); var blue = Math.floor(blueFrac * 255); if (!('alpha' in rgb_color)) return rgbToCssColor_(red, green, blue); var alphaFrac = rgb_color.alpha.value || 0.0; var rgbParams = [red, green, blue].join(','); return ['rgba(', rgbParams, ',', alphaFrac, ')'].join(''); ; var rgbToCssColor_ = function(red, green, blue) var rgbNumber = new Number((red << 16) | (green << 8) | blue); var hexString = rgbNumber.toString(16); var missingZeros = 6 - hexString.length; var resultBuilder = ['#']; for (var i = 0; i < missingZeros; i++) resultBuilder.push('0'); resultBuilder.push(hexString); return resultBuilder.join(''); ; // ... Corresponds to the JSON property tabColor



4516
4517
4518
# File 'generated/google/apis/sheets_v4/classes.rb', line 4516

def tab_color
  @tab_color
end

#titleString

The name of the sheet. Corresponds to the JSON property title

Returns:

  • (String)


4413
4414
4415
# File 'generated/google/apis/sheets_v4/classes.rb', line 4413

def title
  @title
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4566
4567
4568
4569
4570
4571
4572
4573
4574
4575
# File 'generated/google/apis/sheets_v4/classes.rb', line 4566

def update!(**args)
  @title = args[:title] if args.key?(:title)
  @tab_color = args[:tab_color] if args.key?(:tab_color)
  @index = args[:index] if args.key?(:index)
  @sheet_id = args[:sheet_id] if args.key?(:sheet_id)
  @right_to_left = args[:right_to_left] if args.key?(:right_to_left)
  @hidden = args[:hidden] if args.key?(:hidden)
  @grid_properties = args[:grid_properties] if args.key?(:grid_properties)
  @sheet_type = args[:sheet_type] if args.key?(:sheet_type)
end