Class RepeatCellRequest

Updates all cells in the range to the values in the given Cell object. Only the fields listed in the fields field are updated; others are unchanged.

If writing a cell with a formula, the formula's ranges will automatically increment for each field in the range. For example, if writing a cell with formula =A1 into range B2:C4, B2 would be =A1, B3 would be =A2, B4 would be =A3, C2 would be =B1, C3 would be =B2, C4 would be =B3.

To keep the formula's ranges static, use the $ indicator. For example, use the formula =$A$1 to prevent both the row and the column from incrementing.

Inheritance

System.Object

RepeatCellRequest

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 RepeatCellRequest : IDirectResponseSchema

Properties

Cell

The data to write.

Declaration

[JsonProperty("cell")]
public virtual CellData Cell { get; set; }

Property Value

Type	Description
CellData

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

Fields

The fields that should be updated. At least one field must be specified. The root cell is implied and should not be specified. A single "*" can be used as short-hand for listing every field.

Declaration

[JsonProperty("fields")]
public virtual object Fields { get; set; }

Property Value

Type	Description
System.Object

Range

The range to repeat the cell in.

Declaration

[JsonProperty("range")]
public virtual GridRange Range { get; set; }

Property Value

Type	Description
GridRange

Implements

Google.Apis.Requests.IDirectResponseSchema