chore: Update discovery artifacts (#1356)
## Deleted keys were detected in the following stable discovery artifacts:
compute v1 https://github.com/googleapis/google-api-python-client/commit/685c19d4b5262d27a2b1016e01186188afe610fd
genomics v1 https://github.com/googleapis/google-api-python-client/commit/d0e6cc48df2d0a00d91ce6fbab83aa82146f3573
## Deleted keys were detected in the following pre-stable discovery artifacts:
compute alpha https://github.com/googleapis/google-api-python-client/commit/685c19d4b5262d27a2b1016e01186188afe610fd
compute beta https://github.com/googleapis/google-api-python-client/commit/685c19d4b5262d27a2b1016e01186188afe610fd
genomics v2alpha1 https://github.com/googleapis/google-api-python-client/commit/d0e6cc48df2d0a00d91ce6fbab83aa82146f3573
## Discovery Artifact Change Summary:
feat(analyticsadmin): update the api https://github.com/googleapis/google-api-python-client/commit/9648bae09873a132e7b4627096c153043911be6e
feat(artifactregistry): update the api https://github.com/googleapis/google-api-python-client/commit/7dd722fe8b0ae822f4847219c442aa67a1aae7fd
feat(assuredworkloads): update the api https://github.com/googleapis/google-api-python-client/commit/9b84ffce415133e860cc55bfbd3b9c15c3d46a24
feat(cloudasset): update the api https://github.com/googleapis/google-api-python-client/commit/a8228db5ef31724493f0f62bf8062aca9adc44aa
feat(cloudbuild): update the api https://github.com/googleapis/google-api-python-client/commit/c9d8208c0f9579d958224566af369b809e13016a
feat(compute): update the api https://github.com/googleapis/google-api-python-client/commit/685c19d4b5262d27a2b1016e01186188afe610fd
feat(container): update the api https://github.com/googleapis/google-api-python-client/commit/c5cd244f996b1dfb605ef28eb22f8b0e76bffa1b
feat(dialogflow): update the api https://github.com/googleapis/google-api-python-client/commit/0c6b31fd2deb75ca1c023fed36903b638f5e74f8
feat(documentai): update the api https://github.com/googleapis/google-api-python-client/commit/6dcec9fd8c0f803d37b4c8355870208e5a8c61ce
feat(drive): update the api https://github.com/googleapis/google-api-python-client/commit/8788823461610f31eebd655915e07def9690da48
feat(genomics): update the api https://github.com/googleapis/google-api-python-client/commit/d0e6cc48df2d0a00d91ce6fbab83aa82146f3573
feat(logging): update the api https://github.com/googleapis/google-api-python-client/commit/7f5fa161fd3db9ca6f2df23f5c8bd41ba01e9b9c
feat(privateca): update the api https://github.com/googleapis/google-api-python-client/commit/0a5c31d74f788444640c174c413b12d494a00f1a
feat(pubsublite): update the api https://github.com/googleapis/google-api-python-client/commit/dd67e9b117fdc8d0d0ecff6ade657003a95c12f7
feat(recommender): update the api https://github.com/googleapis/google-api-python-client/commit/4b261d97bea2a8bc042a274c2d904be09da2d82c
diff --git a/docs/dyn/sheets_v4.spreadsheets.html b/docs/dyn/sheets_v4.spreadsheets.html
index 072dd5f..2c3ab0e 100644
--- a/docs/dyn/sheets_v4.spreadsheets.html
+++ b/docs/dyn/sheets_v4.spreadsheets.html
@@ -309,7 +309,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -431,7 +431,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -553,7 +553,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -655,7 +655,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1270,7 +1270,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1332,7 +1332,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1402,7 +1402,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1432,7 +1432,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1652,7 +1652,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1781,7 +1781,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -1896,7 +1896,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -2048,7 +2048,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -2537,7 +2537,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -2573,7 +2573,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -2810,7 +2810,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -2850,11 +2850,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -2885,7 +2885,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -2896,7 +2896,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -2918,7 +2918,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -2934,7 +2934,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -3016,7 +3016,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -3027,7 +3027,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -3049,7 +3049,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -3065,7 +3065,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -3231,7 +3231,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -3271,7 +3271,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -3474,7 +3474,7 @@
"shiftDimension": "A String", # The dimension from which deleted cells will be replaced with. If ROWS, existing cells will be shifted upward to replace the deleted cells. If COLUMNS, existing cells will be shifted left to replace the deleted cells.
},
"deleteSheet": { # Deletes the requested sheet. # Deletes a sheet.
- "sheetId": 42, # The ID of the sheet to delete. If the sheet is of SheetType.DATA_SOURCE type, the associated DataSource is also deleted.
+ "sheetId": 42, # The ID of the sheet to delete. If the sheet is of DATA_SOURCE type, the associated DataSource is also deleted.
},
"duplicateFilterView": { # Duplicates a particular filter view. # Duplicates a filter view.
"filterId": 42, # The ID of the filter being duplicated.
@@ -3590,7 +3590,7 @@
},
"repeatCell": { # 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. # Repeats a single cell across a range.
"cell": { # Data about a specific cell. # The data to write.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -3827,7 +3827,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -3867,11 +3867,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -3902,7 +3902,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -3913,7 +3913,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -3935,7 +3935,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -3951,7 +3951,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -4033,7 +4033,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -4044,7 +4044,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -4066,7 +4066,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -4082,7 +4082,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -4248,7 +4248,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -4288,7 +4288,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -4822,7 +4822,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -5059,7 +5059,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -5099,11 +5099,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -5134,7 +5134,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -5145,7 +5145,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -5167,7 +5167,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -5183,7 +5183,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -5265,7 +5265,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -5276,7 +5276,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -5298,7 +5298,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -5314,7 +5314,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -5480,7 +5480,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -5520,7 +5520,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -5555,7 +5555,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -5677,7 +5677,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -5799,7 +5799,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -5901,7 +5901,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -6516,7 +6516,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -6578,7 +6578,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -6648,7 +6648,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -6678,7 +6678,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -6898,7 +6898,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -7027,7 +7027,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -7142,7 +7142,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -7294,7 +7294,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -7914,7 +7914,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -8054,7 +8054,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -8323,7 +8323,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -8445,7 +8445,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -8567,7 +8567,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -8669,7 +8669,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9284,7 +9284,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9346,7 +9346,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9416,7 +9416,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9446,7 +9446,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9666,7 +9666,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9795,7 +9795,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -9910,7 +9910,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -10339,7 +10339,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -10507,7 +10507,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -11012,7 +11012,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -11234,7 +11234,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -11425,7 +11425,7 @@
},
],
"spreadsheetId": "A String", # The spreadsheet the updates were applied to.
- "updatedSpreadsheet": { # Resource that represents a spreadsheet. # The spreadsheet after updates were applied. This is only set if [BatchUpdateSpreadsheetRequest.include_spreadsheet_in_response] is `true`.
+ "updatedSpreadsheet": { # Resource that represents a spreadsheet. # The spreadsheet after updates were applied. This is only set if BatchUpdateSpreadsheetRequest.include_spreadsheet_in_response is `true`.
"dataSourceSchedules": [ # Output only. A list of data source refresh schedules.
{ # Schedule for refreshing the data source. Data sources in the spreadsheet are refreshed within a time interval. You can specify the start time by clicking the Scheduled Refresh button in the Sheets editor, but the interval is fixed at 4 hours. For example, if you specify a start time of 8am , the refresh will take place between 8am and 12pm every day.
"dailySchedule": { # A schedule for data to refresh every day in a given time interval. # Daily refresh schedule.
@@ -11647,7 +11647,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -12044,7 +12044,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -12166,7 +12166,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -12288,7 +12288,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -12390,7 +12390,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13005,7 +13005,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13067,7 +13067,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13137,7 +13137,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13167,7 +13167,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13387,7 +13387,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13516,7 +13516,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13631,7 +13631,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13794,7 +13794,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -13933,7 +13933,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -14170,7 +14170,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -14210,11 +14210,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -14245,7 +14245,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -14256,7 +14256,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -14278,7 +14278,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -14294,7 +14294,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -14376,7 +14376,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -14387,7 +14387,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -14409,7 +14409,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -14425,7 +14425,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -14591,7 +14591,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -14631,7 +14631,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -15033,7 +15033,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -15306,7 +15306,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -15703,7 +15703,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -15825,7 +15825,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -15947,7 +15947,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -16049,7 +16049,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -16664,7 +16664,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -16726,7 +16726,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -16796,7 +16796,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -16826,7 +16826,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -17046,7 +17046,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -17175,7 +17175,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -17290,7 +17290,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -17453,7 +17453,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -17592,7 +17592,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -17829,7 +17829,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -17869,11 +17869,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -17904,7 +17904,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -17915,7 +17915,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -17937,7 +17937,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -17953,7 +17953,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -18035,7 +18035,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -18046,7 +18046,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -18068,7 +18068,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -18084,7 +18084,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -18250,7 +18250,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -18290,7 +18290,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -18692,7 +18692,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -18958,7 +18958,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -19355,7 +19355,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -19477,7 +19477,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -19599,7 +19599,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -19701,7 +19701,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20316,7 +20316,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20378,7 +20378,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20448,7 +20448,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20478,7 +20478,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20698,7 +20698,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20827,7 +20827,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -20942,7 +20942,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -21105,7 +21105,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -21244,7 +21244,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -21481,7 +21481,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -21521,11 +21521,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -21556,7 +21556,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -21567,7 +21567,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -21589,7 +21589,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -21605,7 +21605,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -21687,7 +21687,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -21698,7 +21698,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -21720,7 +21720,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -21736,7 +21736,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -21902,7 +21902,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -21942,7 +21942,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -22344,7 +22344,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -22619,7 +22619,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -23016,7 +23016,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -23138,7 +23138,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -23260,7 +23260,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -23362,7 +23362,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -23977,7 +23977,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24039,7 +24039,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24109,7 +24109,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24139,7 +24139,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24359,7 +24359,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24488,7 +24488,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24603,7 +24603,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24766,7 +24766,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -24905,7 +24905,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -25142,7 +25142,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -25182,11 +25182,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -25217,7 +25217,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -25228,7 +25228,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -25250,7 +25250,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -25266,7 +25266,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -25348,7 +25348,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -25359,7 +25359,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -25381,7 +25381,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -25397,7 +25397,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -25563,7 +25563,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -25603,7 +25603,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -26005,7 +26005,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -26316,7 +26316,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -26713,7 +26713,7 @@
"basicChart": { # The specification for a basic chart. See BasicChartType for the list of charts this supports. # A basic chart specification, can be one of many kinds of charts. See BasicChartType for the list of all charts this supports.
"axis": [ # The axis on the chart.
{ # An axis of the chart. A chart may not have more than one axis per axis position.
- "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain.
+ "format": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the title. Only valid if the axis is not associated with the domain. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -26835,7 +26835,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -26957,7 +26957,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -27059,7 +27059,7 @@
],
},
},
- "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough and underline are not supported.
+ "bubbleTextStyle": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text inside the bubbles. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -27674,7 +27674,7 @@
},
"themeColor": "A String", # Theme color.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for baseline value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -27736,7 +27736,7 @@
"position": { # Position settings for text. # Specifies the horizontal text positioning of key value. This field is optional. If not specified, default positioning is used.
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # Text formatting options for key value. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -27806,7 +27806,7 @@
},
],
"subtitle": "A String", # The subtitle of the chart.
- "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough and underline are not supported.
+ "subtitleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The subtitle text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -27836,7 +27836,7 @@
"horizontalAlignment": "A String", # Horizontal alignment setting for the piece of text.
},
"title": "A String", # The title of the chart.
- "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough and underline are not supported.
+ "titleTextFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The title text format. Strikethrough, underline, and link are not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -28056,7 +28056,7 @@
],
},
},
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format for all labels on the chart. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -28185,7 +28185,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -28300,7 +28300,7 @@
},
},
"placement": "A String", # The placement of the data label relative to the labeled data.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format used for the data label. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -28463,7 +28463,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -28602,7 +28602,7 @@
{ # Data about each cell in a row.
"values": [ # The values in the row, one per column.
{ # Data about a specific cell.
- "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g `=SUM(DataSheet!Column)`.
+ "dataSourceFormula": { # A data source formula. # Output only. Information about a data source formula on the cell. The field is set if user_entered_value is a formula referencing some DATA_SOURCE sheet, e.g. `=SUM(DataSheet!Column)`.
"dataExecutionStatus": { # The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. # Output only. The data execution status.
"errorCode": "A String", # The error code.
"errorMessage": "A String", # The error message, which may be empty.
@@ -28839,7 +28839,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -28879,11 +28879,11 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"formattedValue": "A String", # The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.
- "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field.
+ "hyperlink": "A String", # A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.
"note": "A String", # Any note on the cell.
"pivotTable": { # A pivot table. # 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.
"columns": [ # Each column grouping in the pivot table.
@@ -28914,7 +28914,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -28925,7 +28925,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -28947,7 +28947,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -28963,7 +28963,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -29045,7 +29045,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
"items": [ # The items in the source data that should be placed into this group. Each item may be a string, number, or boolean. Items may appear in at most one group within a given ManualRule. Items that do not appear in any group will appear on their own.
@@ -29056,7 +29056,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -29078,7 +29078,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
],
@@ -29094,7 +29094,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -29260,7 +29260,7 @@
"top": 42, # The top padding of the cell.
},
"textDirection": "A String", # The direction of the text in the cell.
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run).
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The format of the text in the cell (unless overridden by a format run). Setting a cell-level link will clear the cell's existing links. Setting a link in a format run will clear the cell-level link.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.
@@ -29300,7 +29300,7 @@
"type": "A String", # The type of error.
},
"formulaValue": "A String", # Represents a formula.
- "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in "serial number" format.
+ "numberValue": 3.14, # Represents a double value. Note: Dates, Times and DateTimes are represented as doubles in SERIAL_NUMBER format.
"stringValue": "A String", # Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `"123"`.
},
},
@@ -29702,7 +29702,7 @@
},
},
"horizontalAlignment": "A String", # The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`
- "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer.
+ "textFormat": { # The format of a run of text in a cell. Absent values indicate that the field isn't specified. # The text format of title in the slicer. The link field is not supported.
"bold": True or False, # True if the text is bold.
"fontFamily": "A String", # The font family.
"fontSize": 42, # The size of the font.