Set Range Formatting
Deletes a range of cells, shifting other cells into the deleted area. Make sure you pay attention to the fields listed in FieldMask!
Inputs
|
In
Exec
|
|
|
In Token
Google Sheets Web Token Object Reference
|
A validated UGoogleSheetsWebToken object. Used to authenticate the Sheets operation. |
|
Operation Params
Google Sheets Operation Params Structure
|
Generic request operation parameters |
|
Call on Complete
Delegate (by ref)
|
This delegate will be called when the operation completes and tell you whether or not it was successful and return the response as a UGoogleSheetsObjectSheet Tab Data Object. |
|
In Spreadsheet Id
String
|
This is the spreadsheet ID number or key. Get it from your spreadsheet URL by calling GetSpreadsheetIdFromUrl. |
|
In Format to Apply
Google Sheets Cell Format Structure
|
A cell format struct that will be applied to the given range. Include or remove specific properties in FieldMask to include or exclude updates in Google Sheets. |
|
Specific Sheet Id
Integer
|
The ID number or GID of the sheet tab. If blank or negative, this operation will affect the entire spreadsheet on every sheet tab. |
|
Specific Range
String
|
A single range, expressed in A1 notation, that you wish to retrieve. Call GetRangeInA1NotationFromColumnAndRowIndices passing in 1-based indices. |
|
Field Mask
String
|
The fields listed in this string will be modified - if it's not in this list it won't be changed in your sheet. All are listed by default - remove properties you DON'T want to change. Be sure to use camelCase. If the spelling and casing it not exact, the request will fail. |
Outputs
|
Out
Exec
|