microsoft.graph.workbookRangeView

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/microsoft.graph.workbookRangeView",
  "title": "microsoft.graph.workbookRangeView",
  "allOf": [
    {
      "$ref": "#/components/schemas/microsoft.graph.entity"
    },
    {
      "title": "workbookRangeView",
      "required": [
        "@odata.type"
      ],
      "type": "object",
      "properties": {
        "cellAddresses": {
          "description": "The cell addresses."
        },
        "columnCount": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "The number of visible columns. Read-only.",
          "format": "int32"
        },
        "formulas": {
          "description": "The formula in A1-style notation."
        },
        "formulasLocal": {
          "description": "The formula in A1-style notation, in the user's language and number-formatting locale. For example, the English '=SUM(A1, 1.5)' formula would become '=SUMME(A1; 1,5)' in German."
        },
        "formulasR1C1": {
          "description": "Represents the formula in R1C1-style notation."
        },
        "index": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "The index of the range.",
          "format": "int32"
        },
        "numberFormat": {
          "description": "Excel's number format code for the given cell. Read-only."
        },
        "rowCount": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "The number of visible rows. Read-only.",
          "format": "int32"
        },
        "text": {
          "description": "The text values of the specified range. The Text value won't depend on the cell width. The # sign substitution that happens in Excel UI won't affect the text value returned by the API. Read-only."
        },
        "values": {
          "description": "The raw values of the specified range view. The data returned could be of type string, number, or a Boolean. Cell that contains an error returns the error string."
        },
        "valueTypes": {
          "description": "The type of data of each cell. Read-only. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error."
        },
        "rows": {
          "type": "array",
          "items": {
            "$ref": "#/components/schemas/microsoft.graph.workbookRangeView"
          },
          "description": "The collection of range views associated with the range. Read-only. Read-only.",
          "x-ms-navigationProperty": true
        },
        "@odata.type": {
          "type": "string"
        }
      }
    }
  ],
  "x-ms-discriminator-value": "#microsoft.graph.workbookRangeView"
}