Class CellData

Data about a specific cell.

Inheritance

System.Object

CellData

Implements

Google.Apis.Requests.IDirectResponseSchema

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class CellData : IDirectResponseSchema

Properties

DataValidation

A data validation rule on the cell, if any.

When writing, the new data validation rule will overwrite any prior rule.

Declaration

[JsonProperty("dataValidation")]
public virtual DataValidationRule DataValidation { get; set; }

Property Value

Type	Description
DataValidationRule

EffectiveFormat

The effective format being used by the cell. This includes the results of applying any conditional formatting and, if the cell contains a formula, the computed number format. If the effective format is the default format, effective format will not be written. This field is read-only.

Declaration

[JsonProperty("effectiveFormat")]
public virtual CellFormat EffectiveFormat { get; set; }

Property Value

Type	Description
CellFormat

EffectiveValue

The effective value of the cell. For cells with formulas, this is the calculated value. For cells with literals, this is the same as the user_entered_value. This field is read-only.

Declaration

[JsonProperty("effectiveValue")]
public virtual ExtendedValue EffectiveValue { get; set; }

Property Value

Type	Description
ExtendedValue

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

FormattedValue

The formatted value of the cell. This is the value as it's shown to the user. This field is read- only.

Declaration

[JsonProperty("formattedValue")]
public virtual string FormattedValue { get; set; }

Property Value

Type	Description
System.String

Hyperlink

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.)

Declaration

[JsonProperty("hyperlink")]
public virtual string Hyperlink { get; set; }

Property Value

Type	Description
System.String

Note

Any note on the cell.

Declaration

[JsonProperty("note")]
public virtual string Note { get; set; }

Property Value

Type	Description
System.String

PivotTable

A pivot table anchored at this cell. The size of pivot table itself is computed dynamically based on its data, grouping, filters, values, etc. Only the top-left cell of the pivot table contains the pivot table definition. The other cells will contain the calculated values of the results of the pivot in their effective_value fields.

Declaration

[JsonProperty("pivotTable")]
public virtual PivotTable PivotTable { get; set; }

Property Value

Type	Description
PivotTable

TextFormatRuns

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.

Declaration

[JsonProperty("textFormatRuns")]
public virtual IList<TextFormatRun> TextFormatRuns { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<TextFormatRun>

UserEnteredFormat

The format the user entered for the cell.

When writing, the new format will be merged with the existing format.

Declaration

[JsonProperty("userEnteredFormat")]
public virtual CellFormat UserEnteredFormat { get; set; }

Property Value

Type	Description
CellFormat

UserEnteredValue

The value the user entered in the cell. e.g, 1234, 'Hello', or =NOW() Note: Dates, Times and DateTimes are represented as doubles in serial number format.

Declaration

[JsonProperty("userEnteredValue")]
public virtual ExtendedValue UserEnteredValue { get; set; }

Property Value

Type	Description
ExtendedValue

Implements

Google.Apis.Requests.IDirectResponseSchema