ExtendedValue

The kinds of value that a cell in a spreadsheet can have.

Google WorkspaceProductivitySpreadsheets

Properties

Name	Type	Description
numberValue	number	Represents a double value.
stringValue	string	Represents a string value.
boolValue	boolean	Represents a boolean value.
formulaValue	string	Represents a formula.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "ExtendedValue",
  "type": "object",
  "description": "The kinds of value that a cell in a spreadsheet can have.",
  "properties": {
    "numberValue": {
      "type": "number",
      "description": "Represents a double value."
    },
    "stringValue": {
      "type": "string",
      "description": "Represents a string value."
    },
    "boolValue": {
      "type": "boolean",
      "description": "Represents a boolean value."
    },
    "formulaValue": {
      "type": "string",
      "description": "Represents a formula."
    }
  }
}