microsoft.graph.workbookRangeFormat

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://artifacts.apis.io/microsoft-excel/json-schema/microsoft-excel-microsoft-graph-workbook-range-format-schema.json",
  "title": "microsoft.graph.workbookRangeFormat",
  "x-generated": "2026-11-05",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/microsoft-excel-openapi.yml#/components/schemas/microsoft.graph.workbookRangeFormat",
  "allOf": [
    {
      "$ref": "#/$defs/microsoft.graph.entity"
    },
    {
      "title": "workbookRangeFormat",
      "required": [
        "@odata.type"
      ],
      "type": "object",
      "properties": {
        "columnWidth": {
          "oneOf": [
            {
              "type": [
                "number",
                "null"
              ],
              "format": "double"
            },
            {
              "type": [
                "string",
                "null"
              ]
            },
            {
              "$ref": "#/$defs/ReferenceNumeric"
            }
          ],
          "description": "The width of all columns within the range. If the column widths aren't uniform, null will be returned."
        },
        "horizontalAlignment": {
          "type": [
            "string",
            "null"
          ],
          "description": "The horizontal alignment for the specified object. The possible values are: General, Left, Center, Right, Fill, Justify, CenterAcrossSelection, Distributed."
        },
        "rowHeight": {
          "oneOf": [
            {
              "type": [
                "number",
                "null"
              ],
              "format": "double"
            },
            {
              "type": [
                "string",
                "null"
              ]
            },
            {
              "$ref": "#/$defs/ReferenceNumeric"
            }
          ],
          "description": "The height of all rows in the range. If the row heights aren't uniform null will be returned."
        },
        "verticalAlignment": {
          "type": [
            "string",
            "null"
          ],
          "description": "The vertical alignment for the specified object. The possible values are: Top, Center, Bottom, Justify, Distributed."
        },
        "wrapText": {
          "type": [
            "boolean",
            "null"
          ],
          "description": "Indicates whether Excel wraps the text in the object. A null value indicates that the entire range doesn't have a uniform wrap setting."
        },
        "borders": {
          "type": "array",
          "items": {
            "$ref": "#/$defs/microsoft.graph.workbookRangeBorder"
          },
          "description": "Collection of border objects that apply to the overall range selected Read-only.",
          "x-ms-navigationProperty": true
        },
        "fill": {
          "anyOf": [
            {
              "$ref": "#/$defs/microsoft.graph.workbookRangeFill"
            },
            {
              "type": [
                "object",
                "null"
              ]
            }
          ],
          "description": "Returns the fill object defined on the overall range. Read-only.",
          "x-ms-navigationProperty": true
        },
        "font": {
          "anyOf": [
            {
              "$ref": "#/$defs/microsoft.graph.workbookRangeFont"
            },
            {
              "type": [
                "object",
                "null"
              ]
            }
          ],
          "description": "Returns the font object defined on the overall range selected Read-only.",
          "x-ms-navigationProperty": true
        },
        "protection": {
          "anyOf": [
            {
              "$ref": "#/$defs/microsoft.graph.workbookFormatProtection"
            },
            {
              "type": [
                "object",
                "null"
              ]
            }
          ],
          "description": "Returns the format protection object for a range. Read-only.",
          "x-ms-navigationProperty": true
        },
        "@odata.type": {
          "type": "string"
        }
      }
    }
  ],
  "x-ms-discriminator-value": "#microsoft.graph.workbookRangeFormat",
  "$defs": {
    "ReferenceNumeric": {
      "enum": [
        "-INF",
        "INF",
        "NaN"
      ],
      "type": [
        "string",
        "null"
      ]
    },
    "microsoft.graph.entity": {
      "title": "entity",
      "required": [
        "@odata.type"
      ],
      "type": "object",
      "properties": {
        "id": {
          "type": "string",
          "description": "The unique identifier for an entity. Read-only."
        },
        "@odata.type": {
          "type": "string"
        }
      }
    },
    "microsoft.graph.workbookFormatProtection": {
      "allOf": [
        {
          "$ref": "#/$defs/microsoft.graph.entity"
        },
        {
          "title": "workbookFormatProtection",
          "required": [
            "@odata.type"
          ],
          "type": "object",
          "properties": {
            "formulaHidden": {
              "type": [
                "boolean",
                "null"
              ],
              "description": "Indicates whether Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have uniform formula hidden setting."
            },
            "locked": {
              "type": [
                "boolean",
                "null"
              ],
              "description": "Indicates whether Excel locks the cells in the object. A null value indicates that the entire range doesn't have uniform lock setting."
            },
            "@odata.type": {
              "type": "string"
            }
          }
        }
      ],
      "x-ms-discriminator-value": "#microsoft.graph.workbookFormatProtection"
    },
    "microsoft.graph.workbookRangeBorder": {
      "allOf": [
        {
          "$ref": "#/$defs/microsoft.graph.entity"
        },
        {
          "title": "workbookRangeBorder",
          "required": [
            "@odata.type"
          ],
          "type": "object",
          "properties": {
            "color": {
              "type": [
                "string",
                "null"
              ],
              "description": "The HTML color code that represents the color of the border line. Can either be of the form #RRGGBB, for example 'FFA500', or a named HTML color, for example 'orange'."
            },
            "sideIndex": {
              "type": [
                "string",
                "null"
              ],
              "description": "Indicates the specific side of the border. The possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only."
            },
            "style": {
              "type": [
                "string",
                "null"
              ],
              "description": "Indicates the line style for the border. The possible values are: None, Continuous, Dash, DashDot, DashDotDot, Dot, Double, SlantDashDot."
            },
            "weight": {
              "type": [
                "string",
                "null"
              ],
              "description": "The weight of the border around a range. The possible values are: Hairline, Thin, Medium, Thick."
            },
            "@odata.type": {
              "type": "string"
            }
          }
        }
      ],
      "x-ms-discriminator-value": "#microsoft.graph.workbookRangeBorder"
    },
    "microsoft.graph.workbookRangeFill": {
      "allOf": [
        {
          "$ref": "#/$defs/microsoft.graph.entity"
        },
        {
          "title": "workbookRangeFill",
          "required": [
            "@odata.type"
          ],
          "type": "object",
          "properties": {
            "color": {
              "type": [
                "string",
                "null"
              ],
              "description": "HTML color code representing the color of the border line. Can either be of the form #RRGGBB, for example 'FFA500', or be a named HTML color, for example 'orange'."
            },
            "@odata.type": {
              "type": "string"
            }
          }
        }
      ],
      "x-ms-discriminator-value": "#microsoft.graph.workbookRangeFill"
    },
    "microsoft.graph.workbookRangeFont": {
      "allOf": [
        {
          "$ref": "#/$defs/microsoft.graph.entity"
        },
        {
          "title": "workbookRangeFont",
          "required": [
            "@odata.type"
          ],
          "type": "object",
          "properties": {
            "bold": {
              "type": [
                "boolean",
                "null"
              ],
              "description": "Inidicates whether the font is bold."
            },
            "color": {
              "type": [
                "string",
                "null"
              ],
              "description": "The HTML color code representation of the text color. For example, #FF0000 represents the color red."
            },
            "italic": {
              "type": [
                "boolean",
                "null"
              ],
              "description": "Inidicates whether the font is italic."
            },
            "name": {
              "type": [
                "string",
                "null"
              ],
              "description": "The font name. For example, 'Calibri'."
            },
            "size": {
              "oneOf": [
                {
                  "type": [
                    "number",
                    "null"
                  ],
                  "format": "double"
                },
                {
                  "type": [
                    "string",
                    "null"
                  ]
                },
                {
                  "$ref": "#/$defs/ReferenceNumeric"
                }
              ],
              "description": "The font size."
            },
            "underline": {
              "type": [
                "string",
                "null"
              ],
              "description": "The type of underlining applied to the font. The possible values are: None, Single, Double, SingleAccountant, DoubleAccountant."
            },
            "@odata.type": {
              "type": "string"
            }
          }
        }
      ],
      "x-ms-discriminator-value": "#microsoft.graph.workbookRangeFont"
    }
  }
}