Spread.Sheets Documentation
Spread Schema

This is the Spread full version JSON Schema.

Schema
Copy Code
    {
  "$schema": "http://json-schema.org/draft-04/schema#",
  "title": "Spread",
  "description": "Represents a spreadsheet.",
  "type": "object",
  "properties": {
    "version": {
      "type": "string"
    },
    "sheets": {
      "type": "object",
      "patternProperties": {
        ".+": {
          "$ref": "#/definitions/Sheet"
        }
      }
    },
    "namedStyles": {
      "type": "array",
      "description": "The name property of the Style in namedStyles. The name cannot be null, undefined, or ''; it must be set a value.",
      "items": {
        "$ref": "#/definitions/Style"
      }
    },
    "names": {
      "type": "array",
      "items": {
        "$ref": "#/definitions/NameInfo"
      }
    },
    "activeSheetIndex": {
      "type": "integer"
    },
    "sheetCount": {
      "type": "integer",
      "minimum": 0
    },
    "startSheetIndex": {
      "type": "integer",
      "default": 0
    },
    "sparklineExs": {
      "type": "array",
      "items": {
        "$ref": "#/definitions/SparklineEx"
      }
    },
    "customFunctions": {
      "type": "object",
      "patternProperties": {
        ".+": {
          "$ref": "#/definitions/Function"
        }
      }
    },
    "canUserDragDrop": {
      "type": "boolean",
      "default": true
    },
    "canUserDragFill": {
      "type": "boolean",
      "default": true
    },
    "allowUserZoom": {
      "type": "boolean",
      "default": true
    },
    "allowUserResize": {
      "type": "boolean",
      "default": true
    },
    "allowUndo": {
      "type": "boolean",
      "default": true
    },
    "allowSheetReorder": {
      "type": "boolean",
      "default": true
    },
    "defaultDragFillType": {
      "$ref": "#/definitions/AutoFillType",
      "default": 5
    },
    "showDragFillSmartTag": {
      "type": "boolean",
      "default": true
    },
    "showHorizontalScrollbar": {
      "type": "boolean",
      "default": true
    },
    "showVerticalScrollbar": {
      "type": "boolean",
      "default": true
    },
    "scrollbarShowMax": {
      "type": "boolean",
      "default": true
    },
    "scrollbarMaxAlign": {
      "type": "boolean",
      "default": false
    },
    "tabStripVisible": {
      "type": "boolean",
      "default": true
    },
    "tabStripRatio": {
      "type": "number",
      "default": 0.5
    },
    "tabEditable": {
      "type": "boolean",
      "default": true
    },
    "newTabVisible": {
      "type": "boolean",
      "default": true
    },
    "cutCopyIndicatorVisible": {
      "type": "boolean",
      "default": "true"
    },
    "cutCopyIndicatorBorderColor": {
      "type": "string",
      "default": "#217346"
    },
    "tabNavigationVisible": {
      "type": "boolean",
      "default": true
    },
    "backColor": {
      "type": "string",
      "default": "white"
    },
    "backgroundImage": {
      "type": "string"
    },
    "backgroundImageLayout": {
      "$ref": "#/definitions/ImageLayout",
      "default": 0
    },
    "showResizeTip": {
      "$ref": "#/definitions/ShowResizeTip",
      "default": 0
    },
    "showDragDropTip": {
      "type": "boolean",
      "default": true
    },
    "showDragFillTip": {
      "type": "boolean",
      "default": true
    },
    "scrollIgnoreHidden": {
      "type": "boolean",
      "default": false
    },
    "highlightInvalidData": {
      "type": "boolean",
      "default": false
    },
    "showScrollTip": {
      "$ref": "#/definitions/ShowScrollTip",
      "default": 0
    },
    "grayAreaBackColor": {
      "type": "string"
    },
    "useTouchLayout": {
      "type": "boolean",
      "default": false
    },
    "hideSelection": {
      "type": "boolean",
      "default": false
    },
    "resizeZeroIndicator": {
      "$ref": "#/definitions/ResizeZeroIndicator",
      "default": 1
    },
    "canUserEditFormula": {
      "type": "boolean",
      "default": true
    },
    "enableFormulaTextbox": {
      "type": "boolean",
      "default": true
    },
    "referenceStyle": {
      "$ref": "#/definitions/ReferenceStyle",
      "default": 0
    },
    "autoFitType": {
      "$ref": "#/definitions/AutoFitType",
      "default": 0
    },
    "font": {
      "type": "string"
    }
  },
  "definitions": {
    "NameInfo": {
      "title": "NameInfo",
      "description": "Represents a custom named expression that can be used by formulas.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "row": {
          "type": "integer",
          "minimum": 0
        },
        "col": {
          "type": "integer",
          "minimum": 0
        },
        "formula": {
          "type": "string"
        }
      }
    },
    "Style": {
      "title": "Style",
      "description": " Represents the style for a cell, row, or column.",
      "type": "object",
      "properties": {
        "backColor": {
          "type": "string"
        },
        "foreColor": {
          "type": "string"
        },
        "hAlign": {
          "$ref": "#/definitions/HorizontalAlign"
        },
        "vAlign": {
          "$ref": "#/definitions/VerticalAlign"
        },
        "font": {
          "type": "string"
        },
        "themeFont": {
          "type": "string"
        },
        "formatter": {
          "oneOf": [
            {
              "type": "string"
            },
            {
              "$ref": "#/definitions/GeneralFormatter"
            },
            {
              "$ref": "#/definitions/CustomFormatter"
            }
          ]
        },
        "borderLeft": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderTop": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderRight": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderBottom": {
          "$ref": "#/definitions/LineBorder"
        },
        "locked": {
          "type": "boolean"
        },
        "textIndent": {
          "type": "number"
        },
        "wordWrap": {
          "type": "boolean"
        },
        "shrinkToFit": {
          "type": "boolean"
        },
        "backgroundImage": {
          "type": "string"
        },
        "backgroundImageLayout": {
          "$ref": "#/definitions/ImageLayout"
        },
        "cellType": {
          "$ref": "#/definitions/CellType"
        },
        "tabStop": {
          "type": "boolean"
        },
        "name": {
          "type": "string"
        },
        "parentName": {
          "type": "string"
        },
        "textDecoration": {
          "$ref": "#/definitions/TextDecorationType",
          "default": 0
        },
        "imeMode": {
          "$ref": "#/definitions/ImeMode"
        },
        "watermark": {
          "type": "string"
        },
        "validator": {
          "$ref": "#/definitions/DefaultDataValidator"
        }
      }
    },
    "CellType": {
      "title": "CellType",
      "oneOf": [
        {
          "$ref": "#/definitions/CornerCellType"
        },
        {
          "$ref": "#/definitions/RowHeaderCellType"
        },
        {
          "$ref": "#/definitions/ColumnHeaderCellType"
        },
        {
          "$ref": "#/definitions/TextCellType"
        },
        {
          "$ref": "#/definitions/ButtonCellType"
        },
        {
          "$ref": "#/definitions/CheckBoxCellType"
        },
        {
          "$ref": "#/definitions/ComboBoxCellType"
        },
        {
          "$ref": "#/definitions/HyperLinkCellType"
        },
        {
          "$ref": "#/definitions/BaseCellType"
        }
      ]
    },
    "BaseCellType": {
      "title": "BaseCellType",
      "description": "Represents the base class for the other cell type classes.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '0'.",
          "type": "string"
        }
      }
    },
    "CornerCellType": {
      "title": "CornerCellType",
      "description": "Represents the painter of the corner cell.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '4'.",
          "type": "string"
        }
      }
    },
    "RowHeaderCellType": {
      "title": "RowHeaderCellType",
      "description": "Represents the painter of the row header cells.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '3'.",
          "type": "string"
        }
      }
    },
    "ColumnHeaderCellType": {
      "title": "ColumnHeaderCellType",
      "description": "Represents the painter of the column header cells.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '2'.",
          "type": "string"
        }
      }
    },
    "TextCellType": {
      "title": "TextCellType",
      "description": "Represents a text cell type.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '1'.",
          "type": "string"
        }
      }
    },
    "ButtonCellType": {
      "title": "ButtonCellType",
      "description": " Represents a button cell.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '6'.",
          "type": "string"
        },
        "marginTop": {
          "type": "number",
          "default": 2
        },
        "marginRight": {
          "type": "number",
          "default": 2
        },
        "marginBottom": {
          "type": "number",
          "default": 2
        },
        "marginLeft": {
          "type": "number",
          "default": 2
        },
        "text": {
          "type": "string",
          "default": ""
        },
        "buttonBackColor": {
          "type": "string"
        }
      }
    },
    "CheckBoxCellType": {
      "title": "CheckBoxCellType",
      "description": "Represents a check box cell.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '5'.",
          "type": "string"
        },
        "caption": {
          "type": "string",
          "default": ""
        },
        "textTrue": {
          "type": "string",
          "default": ""
        },
        "textIndeterminate": {
          "type": "string",
          "default": ""
        },
        "textFalse": {
          "type": "string",
          "default": ""
        },
        "textAlign": {
          "$ref": "#/definitions/CheckBoxAlign",
          "default": 3
        },
        "isThreeState": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "ComboBoxCellType": {
      "title": "ComboBoxCellType",
      "description": "Represents an ordinary combo box cell.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '7'.",
          "type": "string"
        },
        "editorValueType": {
          "$ref": "#/definitions/EditorValueType",
          "default": 0
        },
        "items": {
          "type": "array",
          "items": {
            "type": [
              "array",
              "boolean",
              "number",
              "null",
              "object",
              "string"
            ]
          }
        },
        "itemHeight": {
          "type": "integer",
          "default": 22
        },
        "editable": {
          "type": "boolean",
          "default": false
        },
        "maxDropDownItems": {
          "type": "integer",
          "default": 20
        }
      }
    },
    "HyperLinkCellType": {
      "title": "HyperLinkCellType",
      "description": "Represents the hyperlink cell.",
      "type": "object",
      "properties": {
        "typeName": {
          "description": "The value is a fixed value '8'.",
          "type": "string"
        },
        "linkColor": {
          "type": "string",
          "default": "#0066cc"
        },
        "visitedLinkColor": {
          "type": "string",
          "default": "#3399ff"
        },
        "text": {
          "type": "string",
          "default": ""
        },
        "linkToolTip": {
          "type": "string",
          "default": ""
        },
        "target": {
          "$ref": "#/definitions/HyperLinkTargetType",
          "default": 0
        },
        "link": {
          "type": "string",
          "default": ""
        }
      }
    },
    "CheckBoxAlign": {
      "title": "CheckBoxAlign",
      "description": "Specifies the text alignment for check box cells. top:0, bottom:1, left:2, right:3.",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "EditorValueType": {
      "title": "EditorValueType",
      "description": "Specifies what is written out to the data model for a selected item from certain cell types that offer a selection of multiple values. text:0, index:1, value:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "HyperLinkTargetType": {
      "title": "HyperLinkTargetType",
      "description": "Specifies the hyperlink's target type. blank:0, self:1, parent:2, top:3.",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "GeneralFormatter": {
      "title": "GeneralFormatter",
      "description": "Represents a formatter with the specified format mode and format string.",
      "type": "object",
      "properties": {
        "formatCached": {
          "type": "string",
          "default": "General"
        },
        "customerCultureName": {
          "type": "string"
        }
      }
    },
    "CustomFormatter": {
      "title": "CustomFormatter",
      "description": "Represents a custom formatter with the specified format string.",
      "type": "object",
      "properties": {
        "formatCached": {
          "type": "string"
        },
        "cultureName": {
          "type": "string"
        },
        "typeName": {
          "type": "string",
          "default": ""
        }
      }
    },
    "HorizontalAlign": {
      "title": "HorizontalAlign",
      "description": "Indicates the horizontal alignment. left:0, center:1, right:2, general:3.",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "VerticalAlign": {
      "title": "VerticalAlign",
      "description": "Indicates the vertical alignment. top:0, center:1, bottom:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "DefaultDataValidator": {
      "title": "DefaultDataValidator",
      "description": "Represents a data validator.",
      "type": "object",
      "properties": {
        "errorStyle": {
          "$ref": "#/definitions/ErrorStyle",
          "default": 0
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": true
        },
        "inCellDropdown": {
          "type": "boolean",
          "default": true
        },
        "showInputMessage": {
          "type": "boolean",
          "default": true
        },
        "showErrorMessage": {
          "type": "boolean",
          "default": true
        },
        "inputTitle": {
          "type": "string",
          "default": ""
        },
        "errorTitle": {
          "type": "string",
          "default": ""
        },
        "inputMessage": {
          "type": "string",
          "default": ""
        },
        "errorMessage": {
          "type": "string",
          "default": ""
        },
        "comparisonOperator": {
          "$ref": "#/definitions/ComparisonOperator",
          "default": 6
        },
        "type": {
          "$ref": "#/definitions/CriteriaType",
          "default": 7
        },
        "condition": {
          "$ref": "#/definitions/Condition"
        }
      }
    },
    "ErrorStyle": {
      "title": "ErrorStyle",
      "description": "Indicates the data validation error style. stop:0, warning:1, information:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "CriteriaType": {
      "title": "CriteriaType",
      "description": "Indicates the data validator criteria type. anyValue:0, wholeNumber:1, decimalValues:2,list:3,date:4,time:5,textLength:6,custom:7.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7
      ]
    },
    "Condition": {
      "title": "Condition",
      "description": "Represents a condition.",
      "type": "object",
      "anyOf": [
        {
          "$ref": "#/definitions/RelationCondition"
        },
        {
          "$ref": "#/definitions/NumberCondition"
        },
        {
          "$ref": "#/definitions/TextCondition"
        },
        {
          "$ref": "#/definitions/ColorCondition"
        },
        {
          "$ref": "#/definitions/FormulaCondition"
        },
        {
          "$ref": "#/definitions/DateCondition"
        },
        {
          "$ref": "#/definitions/DateExCondition"
        },
        {
          "$ref": "#/definitions/TextLengthCondition"
        },
        {
          "$ref": "#/definitions/Top10Condition"
        },
        {
          "$ref": "#/definitions/UniqueCondition"
        },
        {
          "$ref": "#/definitions/AverageCondition"
        },
        {
          "$ref": "#/definitions/CellValueCondition"
        },
        {
          "$ref": "#/definitions/AreaCondition"
        }
      ]
    },
    "RelationCondition": {
      "title": "RelationCondition",
      "description": "Represents a relation condition with a specified relation type.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "relationCondition:0.",
          "enum": [
            0
          ]
        },
        "compareType": {
          "$ref": "#/definitions/LogicalOperators"
        },
        "item1": {
          "$ref": "#/definitions/Condition"
        },
        "item2": {
          "$ref": "#/definitions/Condition"
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "NumberCondition": {
      "title": "NumberCondition",
      "description": "Represents a number condition of the specified type with the specified expected value.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "numberCondition:1.",
          "enum": [
            1
          ]
        },
        "compareType": {
          "$ref": "#/definitions/GeneralComparisonOperators"
        },
        "integerValue": {
          "type": "boolean",
          "default": false
        },
        "expected": {
          "type": "number"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "TextCondition": {
      "title": "TextCondition",
      "description": "Represents a text condition with the specified text comparison type based on the specified cell.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "textCondition:2.",
          "enum": [
            2
          ]
        },
        "compareType": {
          "$ref": "#/definitions/TextCompareType"
        },
        "ignoreCase": {
          "type": "boolean",
          "default": false
        },
        "useWildCards": {
          "type": "boolean",
          "default": true
        },
        "forceValue2Text": {
          "type": "boolean",
          "default": false
        },
        "expected": {
          "type": "string"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "regex": {
          "$ref": "#/definitions/RegExp"
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "ColorCondition": {
      "title": "ColorCondition",
      "description": "Represents a style condition with the specified comparison type and expected color.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "colorCondition:3.",
          "enum": [
            3
          ]
        },
        "compareType": {
          "$ref": "#/definitions/ColorCompareType"
        },
        "expected": {
          "type": "string"
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "FormulaCondition": {
      "title": "FormulaCondition",
      "description": "Represents a custom condition with a specified formula or expression.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "formulaCondition:4.",
          "enum": [
            4
          ]
        },
        "customValueType": {
          "$ref": "#/definitions/CustomValueType"
        },
        "expected": {
          "type": "string"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "DateCondition": {
      "title": "DateCondition",
      "description": "Represents a date condition with the specified comparison type, expected date condition, and formula.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "dateCondition:5.",
          "enum": [
            5
          ]
        },
        "compareType": {
          "$ref": "#/definitions/DateCompareType"
        },
        "expected": {
          "type": "string"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "DateExCondition": {
      "title": "DateExCondition",
      "description": "Represents a date condition with the specified comparison type, expected date condition, and formula.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "dateExCondition:6.",
          "enum": [
            6
          ]
        },
        "expectTypeId": {
          "type": "integer",
          "default": 0
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "expected": {
          "$ref": "#/definitions/DateOccurringType"
        }
      }
    },
    "TextLengthCondition": {
      "title": "TextLengthCondition",
      "description": "Represents a text length condition with the specified comparison type, expected number, and formula.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "textLengthCondition:7.",
          "enum": [
            7
          ]
        },
        "compareType": {
          "$ref": "#/definitions/GeneralComparisonOperators"
        },
        "expected": {
          "type": "string"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "Top10Condition": {
      "title": "Top10Condition",
      "description": "Represents a top 10 condition with the specified type and rank, for the specified cell ranges.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "top10Condition:8.",
          "enum": [
            8
          ]
        },
        "type": {
          "$ref": "#/definitions/Top10ConditionType"
        },
        "isPercent": {
          "type": "boolean",
          "default": false
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "expected": {
          "type": "number"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "UniqueCondition": {
      "title": "UniqueCondition",
      "description": " Represents a unique condition and sets whether to check for duplicate data.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "uniqueCondition:9.",
          "enum": [
            9
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "expected": {
          "type": "boolean"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "AverageCondition": {
      "title": "AverageCondition",
      "description": "Represents a new average condition of the specified type for the specified cell ranges.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "averageCondition:10.",
          "enum": [
            10
          ]
        },
        "type": {
          "$ref": "#/definitions/AverageConditionType"
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "CellValueCondition": {
      "title": "CellValueCondition",
      "description": "Represents a cell value condition with a specified compare type, expected value, and formula.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "cellValueCondition:11.",
          "enum": [
            11
          ]
        },
        "compareType": {
          "$ref": "#/definitions/GeneralComparisonOperators"
        },
        "treatNullValueAsZero": {
          "type": "boolean",
          "default": false
        },
        "expected": {
          "type": "string"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        }
      }
    },
    "AreaCondition": {
      "title": "AreaCondition",
      "description": "Represents an area condition using the expected source or formula.",
      "type": "object",
      "properties": {
        "conType": {
          "description": "areaConditon:12.",
          "enum": [
            12
          ]
        },
        "expected": {
          "type": "string"
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        },
        "ignoreBlank": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "GeneralComparisonOperators": {
      "title": "GeneralComparisonOperators",
      "description": "Specifies the general operator. equalsTo:0, notEqualsTo:1, greaterThan:2, greaterThanOrEqualsTo:3, lessThan:4, lessThanOrEqualsTo:5.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5
      ]
    },
    "LogicalOperators": {
      "title": "LogicalOperators",
      "description": "Specifies the relation operator. or:0, and:1.",
      "enum": [
        0,
        1
      ]
    },
    "ComparisonOperator": {
      "title": "ComparisonOperator",
      "description": "Specifies the comparison operator. equalsTo:0, notEqualsTo:1, greaterThan:2, greaterThanOrEqualsTo:3, lessThan:4, lessThanOrEqualsTo:5, between:6, notBetween:7.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7
      ]
    },
    "TextComparisonOperator": {
      "title": "TextComparisonOperator",
      "description": "Specifies the text comparison operator. contains:0, doesNotContain:1, beginsWith:2, endsWith:3.",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "TextCompareType": {
      "title": "TextCompareType",
      "description": "Specifies the text compare type. 0:equalsTo, 1:notEqualsTo, 2:beginsWith, 3:doesNotBeginWith, 4:endsWith, 5:doesNotEndWith, 6:contains, 7:doesNotContain.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7
      ]
    },
    "ColorCompareType": {
      "title": "ColorCompareType",
      "description": "Specifies the color compare type. backgroundColor:0, foregroundColor:1.",
      "enum": [
        0,
        1
      ]
    },
    "CustomValueType": {
      "title": "CustomValueType",
      "description": "Specifies the custom value type. empty:0, nonEmpty:1, error:2, nonError:3, formula:4.",
      "enum": [
        0,
        1,
        2,
        3,
        4
      ]
    },
    "DateCompareType": {
      "title": "DateCompareType",
      "description": "Specifies the date compare type. equalsTo:0, notEqualsTo:1, before:2, beforeEqualsTo:3, after:4, afterEqualsTo:5.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5
      ]
    },
    "DateOccurringType": {
      "title": "DateOccurringType",
      "description": "Specifies the date occurring type. today:0, yesterday:1, tomorrow:2, last7Days:3, thisMonth:4, lastMonth:5, nextMonth:6, thisWeek:7, lastWeek:8, nextWeek:9.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9
      ]
    },
    "Top10ConditionType": {
      "title": "Top10ConditionType",
      "description": "Specifies the top 10 condition type. top:0, bottom:1.",
      "enum": [
        0,
        1
      ]
    },
    "AverageConditionType": {
      "title": "AverageConditionType",
      "description": "Specifies the average condition type. above:0, below:1, equalOrAbove:2, equalOrBelow:3, above1StdDev:4, below1StdDev:5, above2StdDev:6, below2StdDev:7, above3StdDev:8, below3StdDev:9.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9
      ]
    },
    "Rule": {
      "title": "Rule",
      "type": "object",
      "anyOf": [
        {
          "$ref": "#/definitions/CellValueRule"
        },
        {
          "$ref": "#/definitions/SpecificTextRule"
        },
        {
          "$ref": "#/definitions/FormulaRule"
        },
        {
          "$ref": "#/definitions/DateOccurringRule"
        },
        {
          "$ref": "#/definitions/Top10Rule"
        },
        {
          "$ref": "#/definitions/UniqueRule"
        },
        {
          "$ref": "#/definitions/DuplicateRule"
        },
        {
          "$ref": "#/definitions/AverageRule"
        },
        {
          "$ref": "#/definitions/TwoScaleRule"
        },
        {
          "$ref": "#/definitions/ThreeScaleRule"
        },
        {
          "$ref": "#/definitions/DataBarRule"
        },
        {
          "$ref": "#/definitions/IconSetRule"
        }
      ]
    },
    "CellValueRule": {
      "title": "CellValueRule",
      "description": "Represents a cell value conditional rule.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "cellValueRule:1.",
          "enum": [
            1
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "operator": {
          "$ref": "#/definitions/ComparisonOperator"
        },
        "value1": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "value2": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        }
      }
    },
    "SpecificTextRule": {
      "title": "SpecificTextRule",
      "description": "Represents a specific text rule based on the specified cell.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "specificTextRule:2.",
          "enum": [
            2
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "operator": {
          "$ref": "#/definitions/TextComparisonOperator"
        },
        "text": {
          "type": "string"
        }
      }
    },
    "FormulaRule": {
      "title": "FormulaRule",
      "description": "Represents a formula rule with the specified formula and style.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "formulaRule:3.",
          "enum": [
            3
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "formula": {
          "type": [
            "string",
            "null"
          ]
        }
      }
    },
    "DateOccurringRule": {
      "title": "DateOccurringRule",
      "description": "Represents a DateOccurringRule with the specified type and style.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "dateOccurringRule:4.",
          "enum": [
            4
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "type": {
          "$ref": "#/definitions/DateOccurringType"
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "Top10Rule": {
      "title": "Top10Rule",
      "description": "Represents a formula rule with the specified formula and style.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "top10Rule:5.",
          "enum": [
            5
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "type": {
          "$ref": "#/definitions/Top10ConditionType"
        },
        "rank": {
          "type": "integer"
        }
      }
    },
    "UniqueRule": {
      "title": "UniqueRule",
      "description": "",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "uniqueRule:6.",
          "enum": [
            6
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        }
      }
    },
    "DuplicateRule": {
      "title": "DuplicateRule",
      "description": "Represents a duplicate conditional rule.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "duplicateRule:7.",
          "enum": [
            7
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        }
      }
    },
    "AverageRule": {
      "title": "AverageRule",
      "description": "Represents an average conditional rule.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "averageRule:8.",
          "enum": [
            8
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "style": {
          "$ref": "#/definitions/Style"
        },
        "stopIfTrue": {
          "type": "boolean",
          "default": false
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "type": {
          "$ref": "#/definitions/AverageConditionType"
        }
      }
    },
    "TwoScaleRule": {
      "title": "TwoScaleRule",
      "description": " Represents a two-color conditional scale rule with the specified parameters.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "twoScaleRule:10.",
          "enum": [
            10
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "minType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "minValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "minColor": {
          "type": "string"
        },
        "maxType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "maxValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "maxColor": {
          "type": "string"
        }
      }
    },
    "ThreeScaleRule": {
      "title": "ThreeScaleRule",
      "description": "Represents a three-color scale conditional rule with the specified parameters.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "threeScaleRule:11.",
          "enum": [
            11
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "minType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "minValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "minColor": {
          "type": "string"
        },
        "midType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "midValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "midColor": {
          "type": "string"
        },
        "maxType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "maxValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "maxColor": {
          "type": "string"
        }
      }
    },
    "DataBarRule": {
      "title": "DataBarRule",
      "description": " Represents a data bar conditional rule with the specified parameters.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "dataBarRule:12.",
          "enum": [
            12
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "minType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "minValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "maxType": {
          "$ref": "#/definitions/ScaleValueType"
        },
        "maxValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "gradient": {
          "type": "boolean",
          "default": true
        },
        "color": {
          "type": "string"
        },
        "showBorder": {
          "type": "boolean",
          "default": false
        },
        "borderColor": {
          "type": "string",
          "default": "black"
        },
        "dataBarDirection": {
          "$ref": "#/definitions/BarDirection",
          "default": 0
        },
        "negativeFillColor": {
          "type": "string",
          "default": "red"
        },
        "useNegativeFillColor": {
          "type": "boolean",
          "default": true
        },
        "negativeBorderColor": {
          "type": "string",
          "default": "black"
        },
        "useNegativeBorderColor": {
          "type": "boolean",
          "default": false
        },
        "axisPosition": {
          "$ref": "#/definitions/DataBarAxisPosition",
          "default": 0
        },
        "axisColor": {
          "type": "string",
          "default": "black"
        },
        "showBarOnly": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "IconSetRule": {
      "title": "IconSetRule",
      "description": "Represents an icon set rule with the specified parameters.",
      "type": "object",
      "properties": {
        "ruleType": {
          "description": "iconSetRule:13.",
          "enum": [
            13
          ]
        },
        "ranges": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Range"
          }
        },
        "priority": {
          "type": "integer",
          "default": 1
        },
        "iconSetType": {
          "$ref": "#/definitions/IconSetType"
        },
        "iconCriteria": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/IconCriterion"
          }
        },
        "showIconOnly": {
          "type": "boolean",
          "default": false
        },
        "reverseIconOrder": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "IconCriterion": {
      "title": "IconCriterion",
      "description": "Represents an icon criteria with the specified parameters.",
      "type": "object",
      "properties": {
        "isGreaterThanOrEqualTo": {
          "type": "boolean"
        },
        "iconValueType": {
          "$ref": "#/definitions/IconValueType"
        },
        "iconValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        }
      }
    },
    "IconValueType": {
      "title": "IconValueType",
      "description": "Indicates whether to return a specified number directly. number:1, percent:4, percentile:5, formula:7.",
      "enum": [
        1,
        4,
        5,
        7
      ]
    },
    "ScaleValueType": {
      "title": "ScaleValueType",
      "description": "Specifies the scale value type. number:0, lowestValue:1, highestValue:2, percent:3, percentile:4, automin:5, formula:6, automax:7.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7
      ]
    },
    "BarDirection": {
      "title": "BarDirection",
      "description": "Specifies the data bar direction. leftToRight:0, rightToLeft:1.",
      "enum": [
        0,
        1
      ]
    },
    "DataBarAxisPosition": {
      "title": "DataBarAxisPosition",
      "description": "Specifies the position of the data bar's axis. automatic:0, cellMidPoint:1, none:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "IconSetType": {
      "title": "IconSetType",
      "description": "Specifies the icon set. threeArrowsColored:0, threeArrowGray:1, threeTriangles:2, threeStars:3, threeFlags:4, threeTrafficLightsUnrimmed:5, threeTrafficLightsRimmed:6, threeSigns:7, threeSymbolsCircled:8, threeSymbolsUncircled:9, fourArrowsColored:10, fourArrowGray:11, fourRedToBlack:12, fourRatings:13, fourTrafficLights:14, fiveArrowsColored:15, fiveArrowsGray:16, fiveRatings:17, fiveQuarters:18, fiveBoxes:19.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        10,
        11,
        12,
        13,
        14,
        15,
        16,
        17,
        18,
        19
      ]
    },
    "RegExp": {
      "title": "RegExp",
      "description": "A built-in JavaScript object, represents a RegExp",
      "type": "object",
      "properties": {
        "source": {
          "type": "string"
        },
        "global": {
          "type": "boolean",
          "default": false
        },
        "ignoreCase": {
          "type": "boolean",
          "default": false
        },
        "multiline": {
          "type": "boolean",
          "default": false
        },
        "lastIndex": {
          "type": "integer"
        }
      }
    },
    "LineBorder": {
      "title": "LineBorder",
      "description": "Indicates the color of the border line. Use a known color name or HEX style color value. The default value is black.",
      "type": "object",
      "properties": {
        "color": {
          "type": "string",
          "default": "black"
        },
        "style": {
          "$ref": "#/definitions/LineStyle",
          "default": 0
        }
      }
    },
    "LineStyle": {
      "title": "LineStyle",
      "description": "Specifies the line drawing style for the border. empty:0, thin:1, medium:2, dashed:3, dotted:4, thick:5, double:6, hair:7, mediumDashed:8, dashDot:9, mediumDashDot:10, dashDotDot:11, mediumDashDotDot:12, slantedDashDot:13.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        10,
        11,
        12,
        13
      ]
    },
    "TextDecorationType": {
      "title": "TextDecorationType",
      "description": "Defines the type of the text decoration. none:0, underline:1, lineThrough:2, overline:4.",
      "enum": [
        0,
        1,
        2,
        4
      ]
    },
    "ImeMode": {
      "title": "ImeMode",
      "description": "Defines the IME mode to control the state of the Input Method Editor (IME). disabled:0, auto:1, active:2, inactive:4.",
      "enum": [
        0,
        1,
        2,
        4
      ]
    },
    "ReferenceStyle": {
      "title": "ReferenceStyle",
      "description": "Specifies the formula reference style. a1:0, r1c1:1.",
      "enum": [
        0,
        1
      ]
    },
    "AutoFillType": {
      "title": "AutoFillType",
      "description": "Represents the type of drag fill. copyCells:0, fillSeries:1, fillFormattingOnly:2, fillWithoutFormatting:3, flearValues:4, auto:5.",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5
      ]
    },
    "AutoFitType": {
      "title": "AutoFitType",
      "description": "Represents whether the component autofits cells or headers. cell:0, cellWithHeader:1.",
      "enum": [
        0,
        1
      ]
    },
    "ShowScrollTip": {
      "title": "ShowScrollTip",
      "description": "Specifies how the scroll tip is displayed. none:0, horizontal:1, vertical:2, both:3",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "ShowResizeTip": {
      "title": "ShowResizeTip",
      "description": "Defines how the resize tip is displayed. none:0, column:1, row:2, both:3",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "ImageLayout": {
      "title": "ImageLayout",
      "description": "Defines the background image layout. stretch:0, center:1, zoom:2, none:3.",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "Sheet": {
      "title": "Sheet",
      "description": "Represents a sheet",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "defaults": {
          "$ref": "#/definitions/SheetDefaultOption"
        },
        "frozenRowCount": {
          "type": "integer",
          "default": 0
        },
        "frozenColCount": {
          "type": "integer",
          "default": 0
        },
        "frozenTrailingRowCount": {
          "type": "integer",
          "default": 0
        },
        "frozenTrailingColCount": {
          "type": "integer",
          "default": 0
        },
        "rowCount": {
          "type": "integer"
        },
        "columnCount": {
          "type": "integer"
        },
        "activeRow": {
          "type": "integer",
          "default": 0
        },
        "activeCol": {
          "type": "integer",
          "default": 0
        },
        "zoomFactor": {
          "type": "number",
          "minimum": 0.25,
          "maximum": 4.0,
          "default": 1.0
        },
        "rowHeaderColCount": {
          "type": "integer",
          "default": 1
        },
        "colHeaderRowCount": {
          "type": "integer",
          "default": 1
        },
        "visible": {
          "type": "boolean",
          "default": true
        },
        "tag": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        },
        "spans": {
          "$ref": "#/definitions/SpanModel"
        },
        "rowHeaderSpan": {
          "$ref": "#/definitions/SpanModel"
        },
        "colHeaderSpan": {
          "$ref": "#/definitions/SpanModel"
        },
        "data": {
          "$ref": "#/definitions/SheetModel"
        },
        "rowHeaderData": {
          "$ref": "#/definitions/SheetModel"
        },
        "colHeaderData": {
          "$ref": "#/definitions/SheetModel"
        },
        "selections": {
          "$ref": "#/definitions/SelectionModel"
        },
        "theme": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "$ref": "#/definitions/SpreadTheme"
            }
          ]
        },
        "rows": {
          "type": "array",
          "items": {
            "anyOf": [
              {
                "type": "null"
              },
              {
                "$ref": "#/definitions/RowColInfo"
              }
            ]
          }
        },
        "columns": {
          "type": "array",
          "items": {
            "anyOf": [
              {
                "type": "null"
              },
              {
                "$ref": "#/definitions/RowColInfo"
              }
            ]
          }
        },
        "rowHeaderColInfos": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/RowColInfo"
          }
        },
        "colHeaderRowInfos": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/RowColInfo"
          }
        },
        "namedStyles": {
          "type": "array",
          "description": "The name property of the Style in namedStyles cannot be null, undefined, or ''; it must be set to a value.",
          "items": {
            "$ref": "#/definitions/Style"
          }
        },
        "names": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/NameInfo"
          }
        },
        "rowFilter": {
          "anyOf": [
            {
              "$ref": "#/definitions/HideRowFilter"
            },
            {
              "$ref": "#/definitions/RowFilterBase"
            }
          ]
        },
        "autoGenerateColumns": {
          "type": "boolean",
          "default": true
        },
        "sparklineGroups": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/SparklineGroup"
          }
        },
        "comments": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Comment"
          }
        },
        "showRowOutline": {
          "type": "boolean",
          "default": true
        },
        "showColumnOutline": {
          "type": "boolean",
          "default": true
        },
        "rowOutlines": {
          "$ref": "#/definitions/Outline"
        },
        "columnOutlines": {
          "$ref": "#/definitions/Outline"
        },
        "conditionalFormats": {
          "type": "object",
          "properties": {
            "rules": {
              "type": "array",
              "items": {
                "$ref": "#/definitions/Rule"
              }
            }
          }
        },
        "tables": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/SheetTable"
          }
        },
        "floatingObjects": {
          "type": "array",
          "items": {
            "anyOf": [
              {
                "$ref": "#/definitions/FloatingObject"
              },
              {
                "$ref": "#/definitions/Picture"
              }
            ]
          }
        },
        "customFunctions": {
          "type": "object",
          "patternProperties": {
            ".+": {
              "$ref": "#/definitions/Function"
            }
          }
        },
        "printInfo": {
          "$ref": "#/definitions/PrintInfo"
        },
        "slicers": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Slicer"
          }
        },
        "allowCellOverflow": {
          "type": "boolean",
          "default": false
        },
        "sheetTabColor": {
          "type": "string"
        },
        "frozenlineColor": {
          "type": "string",
          "default": "black"
        },
        "clipBoardOptions": {
          "$ref": "#/definitions/ClipboardPasteOptions",
          "default": 0
        },
        "gridline": {
          "$ref": "#/definitions/SheetGridlineOption"
        },
        "rowHeaderVisible": {
          "type": "boolean",
          "default": true
        },
        "colHeaderVisible": {
          "type": "boolean",
          "default": true
        },
        "rowHeaderAutoText": {
          "$ref": "#/definitions/HeaderAutoText",
          "default": 1
        },
        "colHeaderAutoText": {
          "$ref": "#/definitions/HeaderAutoText",
          "default": 2
        },
        "rowHeaderAutoTextIndex": {
          "type": "integer",
          "default": -1
        },
        "colHeaderAutoTextIndex": {
          "type": "integer",
          "default": -1
        },
        "isProtected": {
          "type": "boolean",
          "default": false
        },
        "protectionOptions": {
          "$ref": "#/definitions/ProtectionOption"
        },
        "selectionBackColor": {
          "type": "string",
          "default": "rgba(180,180,200,0.2)"
        },
        "selectionBorderColor": {
          "type": "string",
          "default": "black"
        },
        "borderColor": {
          "type": "string",
          "default": "black"
        },
        "borderWidth": {
          "type": "integer",
          "minimum": 0,
          "default": 0
        }
      }
    },
    "SelectionModel": {
      "title": "SelectionModel",
      "description": "Represent a data model for cell selection.",
      "type": "object",
      "properties": {
        "selectionPolicy": {
          "$ref": "#/definitions/SelectionPolicy",
          "default": 2
        },
        "selectionUnit": {
          "$ref": "#/definitions/SelectionUnit",
          "default": 0
        },
        "activeSelectedRangeIndex": {
          "type": "integer"
        },
        "length": {
          "type": "integer",
          "minimum": 0
        }
      },
      "patternProperties": {
        "[0-9]+": {
          "$ref": "#/definitions/Range"
        }
      }
    },
    "SelectionPolicy": {
      "title": "SelectionPolicy",
      "description": "Specifies how users can select items in the control. single:0, range:1, multiRange:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "SelectionUnit": {
      "title": "SelectionUnit",
      "description": "Specifies the smallest unit users or the application can select. cell:0, row:1, column:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "SheetModel": {
      "title": "SheetModel",
      "description": "Represents a data model for the worksheet.",
      "type": "object",
      "properties": {
        "dataTable": {
          "type": "object",
          "patternProperties": {
            "[0-9]+": {
              "type": "object",
              "patternProperties": {
                "[0-9]+": {
                  "type": "object",
                  "properties": {
                    "value": {
                      "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                      ]
                    },
                    "style": {
                      "anyOf": [
                        {
                          "type": "string"
                        },
                        {
                          "$ref": "#/definitions/Style"
                        }
                      ]
                    },
                    "tag": {
                      "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                      ]
                    },
                    "formula": {
                      "type": [
                        "string",
                        "null"
                      ]
                    },
                    "bindingPath": {
                      "type": "string"
                    }
                  }
                }
              }
            }
          }
        },
        "rowDataArray": {
          "type": "array",
          "items": {
            "type": [
              "object",
              "null"
            ],
            "properties": {
              "style": {
                "anyOf": [
                  {
                    "type": "string"
                  },
                  {
                    "$ref": "#/definitions/Style"
                  }
                ]
              },
              "tag": {
                "type": [
                  "array",
                  "boolean",
                  "number",
                  "null",
                  "object",
                  "string"
                ]
              }
            }
          }
        },
        "columnDataArray": {
          "type": "array",
          "items": {
            "type": [
              "object",
              "null"
            ],
            "properties": {
              "style": {
                "anyOf": [
                  {
                    "type": "string"
                  },
                  {
                    "$ref": "#/definitions/Style"
                  }
                ]
              },
              "tag": {
                "type": [
                  "array",
                  "boolean",
                  "number",
                  "null",
                  "object",
                  "string"
                ]
              }
            }
          }
        },
        "defaultDataNode": {
          "type": "object",
          "properties": {
            "style": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "$ref": "#/definitions/Style"
                }
              ]
            }
          }
        }
      }
    },
    "SheetGridlineOption": {
      "title": "SheetGridlineOption",
      "description": "Represents a sheet gridline option.",
      "type": "object",
      "properties": {
        "color": {
          "type": "string"
        },
        "showVerticalGridline": {
          "type": "boolean"
        },
        "showHorizontalGridline": {
          "type": "boolean"
        }
      }
    },
    "SpreadTheme": {
      "title": "SpreadTheme",
      "description": "Represents an expression with a named variable as the expression.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "themeColor": {
          "$ref": "#/definitions/ThemeColor"
        },
        "headingFont": {
          "type": "string"
        },
        "bodyFont": {
          "type": "string"
        }
      }
    },
    "ThemeColor": {
      "title": "ThemeColor",
      "description": " Creates a ThemeColor instance.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "text1": {
          "$ref": "#/definitions/Color"
        },
        "text2": {
          "$ref": "#/definitions/Color"
        },
        "background1": {
          "$ref": "#/definitions/Color"
        },
        "background2": {
          "$ref": "#/definitions/Color"
        },
        "accent1": {
          "$ref": "#/definitions/Color"
        },
        "accent2": {
          "$ref": "#/definitions/Color"
        },
        "accent3": {
          "$ref": "#/definitions/Color"
        },
        "accent4": {
          "$ref": "#/definitions/Color"
        },
        "accent5": {
          "$ref": "#/definitions/Color"
        },
        "accent6": {
          "$ref": "#/definitions/Color"
        },
        "hyperlink": {
          "$ref": "#/definitions/Color"
        },
        "followedHyperlink": {
          "$ref": "#/definitions/Color"
        }
      }
    },
    "Color": {
      "title": "Color",
      "description": "Represents an argb(alpha,red, green, blue) color.",
      "type": "object",
      "properties": {
        "a": {
          "type": "number",
          "minimum": 0,
          "maximum": 255
        },
        "r": {
          "type": "number",
          "minimum": 0,
          "maximum": 255
        },
        "g": {
          "type": "number",
          "minimum": 0,
          "maximum": 255
        },
        "b": {
          "type": "number",
          "minimum": 0,
          "maximum": 255
        }
      }
    },
    "Function": {
      "title": "Function",
      "description": "Represents an abstract base class for defining functions.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "minArgs": {
          "type": "number"
        },
        "maxArgs": {
          "type": "number"
        },
        "typeName": {
          "type": "string",
          "default": ""
        }
      }
    },
    "Range": {
      "title": "Range",
      "description": "Represents a range, which is described by the row index, column index, row count, and column count.",
      "type": "object",
      "properties": {
        "row": {
          "type": "integer"
        },
        "col": {
          "type": "integer"
        },
        "rowCount": {
          "type": "integer",
          "minimum": 0
        },
        "colCount": {
          "type": "integer",
          "minimum": 0
        }
      }
    },
    "RowFilterBase": {
      "title": "RowFilterBase",
      "description": "Represents a row filter base that supports row filters for filtering rows in a sheet.",
      "type": "object",
      "properties": {
        "typeName": {
          "type": "string",
          "default": ""
        },
        "range": {
          "$ref": "#/definitions/Range"
        },
        "filterItemMap": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "index": {
                "type": "integer",
                "minimum": 0
              },
              "conditions": {
                "type": "array",
                "items": {
                  "$ref": "#/definitions/Condition"
                }
              }
            }
          }
        },
        "filteredColumns": {
          "type": "array",
          "items": {
            "type": "integer",
            "minimum": 0
          }
        },
        "sortInfo": {
          "$ref": "#/definitions/SortInfo"
        },
        "showFilterButton": {
          "type": "boolean"
        },
        "filterButtonVisibleInfo": {
          "type": "object",
          "patternProperties": {
            "[0-9]+": {
              "description": "The property name is the column's index that is relative to the sheet.",
              "type": "boolean"
            }
          }
        }
      }
    },
    "HideRowFilter": {
      "title": "HideRowFilter",
      "description": "Represents a default row filter.",
      "type": "object",
      "properties": {
        "range": {
          "$ref": "#/definitions/Range"
        },
        "filterItemMap": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "index": {
                "type": "integer",
                "minimum": 0
              },
              "conditions": {
                "type": "array",
                "items": {
                  "$ref": "#/definitions/Condition"
                }
              }
            }
          }
        },
        "filteredColumns": {
          "type": "array",
          "items": {
            "type": "integer",
            "minimum": 0
          }
        },
        "sortInfo": {
          "$ref": "#/definitions/SortInfo"
        },
        "showFilterButton": {
          "type": "boolean"
        },
        "filterButtonVisibleInfo": {
          "type": "object",
          "patternProperties": {
            "[0-9]+": {
              "description": "The property name is the column index that is relative to the sheet.",
              "type": "boolean"
            }
          }
        }
      }
    },
    "TableFilter": {
      "title": "TableFilter",
      "description": "Represents a table filter.",
      "type": "object",
      "properties": {
        "range": {
          "$ref": "#/definitions/Range"
        },
        "filterItemMap": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "index": {
                "type": "integer",
                "minimum": 0
              },
              "conditions": {
                "type": "array",
                "items": {
                  "$ref": "#/definitions/Condition"
                }
              }
            }
          }
        },
        "filteredColumns": {
          "type": "array",
          "items": {
            "type": "integer",
            "minimum": 0
          }
        },
        "sortInfo": {
          "$ref": "#/definitions/SortInfo"
        },
        "showFilterButton": {
          "type": "boolean"
        },
        "filterButtonVisibleInfo": {
          "type": "object",
          "patternProperties": {
            "[0-9]+": {
              "description": "The property name is the column index that is relative to the table.",
              "type": "boolean"
            }
          }
        }
      }
    },
    "SortInfo": {
      "title": "SortInfo",
      "description": "",
      "type": "object",
      "properties": {
        "index": {
          "type": "integer"
        },
        "ascending": {
          "type": "boolean"
        }
      }
    },
    "SheetDefaultOption": {
      "title": "SheetDefaultOption",
      "description": "",
      "type": "object",
      "properties": {
        "rowHeight": {
          "type": "number",
          "minimum": 0,
          "default": 20
        },
        "colHeaderRowHeight": {
          "type": "number",
          "minimum": 0,
          "default": 20
        },
        "colWidth": {
          "type": "number",
          "minimum": 0,
          "default": 62
        },
        "rowHeaderColWidth": {
          "type": "number",
          "minimum": 0,
          "default": 40
        }
      }
    },
    "RowColInfo": {
      "title": "RowColInfo",
      "description": "Represents a row or column.",
      "type": "object",
      "properties": {
        "size": {
          "type": "number",
          "minimum": 0
        },
        "visible": {
          "type": "boolean"
        },
        "resizable": {
          "type": "boolean"
        },
        "pageBreak": {
          "type": "boolean"
        }
      }
    },
    "SparklineGroup": {
      "title": "SparklineGroup",
      "description": "Represents a sparkline group.",
      "type": "object",
      "properties": {
        "setting": {
          "$ref": "#/definitions/SparklineSetting",
          "default": null
        },
        "displayDateAxis": {
          "type": "boolean",
          "default": false
        },
        "sparklineType": {
          "$ref": "#/definitions/SparklineType"
        },
        "axisReference": {
          "$ref": "#/definitions/Range",
          "default": null
        },
        "axisOrientation": {
          "$ref": "#/definitions/DataOrientation",
          "default": 1
        },
        "sparklines": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/Sparkline"
          }
        }
      }
    },
    "SparklineSetting": {
      "title": "SparklineSetting",
      "description": "Represents the sparkline settings.",
      "type": "object",
      "properties": {
        "axisColor": {
          "type": "string",
          "default": "Black"
        },
        "firstMarkerColor": {
          "type": "string",
          "default": "rgba(149,179,215,255)"
        },
        "highMarkerColor": {
          "type": "string",
          "default": "Blue"
        },
        "lastMarkerColor": {
          "type": "string",
          "default": "rgba(149,179,215,255)"
        },
        "lowMarkerColor": {
          "type": "string",
          "default": "Blue"
        },
        "markersColor": {
          "type": "string",
          "default": "rgba(36,64,98,255)"
        },
        "negativeColor": {
          "type": "string",
          "default": "Brown"
        },
        "seriesColor": {
          "type": "string",
          "default": "rgba(36,64,98,255)"
        },
        "displayEmptyCellsAs": {
          "$ref": "#/definitions/EmptyValueStyle",
          "default": 0
        },
        "rightToLeft": {
          "type": "boolean",
          "default": false
        },
        "displayHidden": {
          "type": "boolean",
          "default": false
        },
        "displayXAxis": {
          "type": "boolean",
          "default": false
        },
        "showFirst": {
          "type": "boolean",
          "default": false
        },
        "showHigh": {
          "type": "boolean",
          "default": false
        },
        "showLast": {
          "type": "boolean",
          "default": false
        },
        "showLow": {
          "type": "boolean",
          "default": false
        },
        "showNegative": {
          "type": "boolean",
          "default": false
        },
        "showMarkers": {
          "type": "boolean",
          "default": false
        },
        "manualMax": {
          "type": "number",
          "default": 0.0
        },
        "manualMin": {
          "type": "number",
          "default": 0.0
        },
        "maxAxisType": {
          "$ref": "#/definitions/SparklineAxisMinMax",
          "default": 0
        },
        "minAxisType": {
          "$ref": "#/definitions/SparklineAxisMinMax",
          "default": 0
        },
        "lineWeight": {
          "type": "number",
          "default": 1
        }
      }
    },
    "Sparkline": {
      "title": "Sparkline",
      "description": "Represents a Sparkline.",
      "type": "object",
      "properties": {
        "row": {
          "type": "integer",
          "minimum": 0
        },
        "col": {
          "type": "integer",
          "minimum": 0
        },
        "orientation": {
          "$ref": "#/definitions/DataOrientation"
        },
        "data": {
          "$ref": "#/definitions/Range"
        }
      }
    },
    "SparklineType": {
      "title": "SparklineType",
      "description": "Represents the sparkline type. line:0, column:1, winloss:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "SparklineAxisMinMax": {
      "title": "SparklineAxisMinMax",
      "description": "An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group. individual:0, group:1, custom:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "EmptyValueStyle": {
      "title": "EmptyValueStyle",
      "description": "Specifies how to show an empty value from a data series in the chart. gaps:0, zero:1, connect:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "DataOrientation": {
      "title": "DataOrientation",
      "description": "Represents the orientation of the range. vertical:0, horizontal:1.",
      "enum": [
        0,
        1
      ]
    },
    "Comment": {
      "title": "Comment",
      "description": "Represents a comment.",
      "type": "object",
      "properties": {
        "text": {
          "type": "string",
          "default": ""
        },
        "location": {
          "$ref": "#/definitions/Point"
        },
        "width": {
          "type": "number",
          "minimum": 0,
          "exclusiveMinimum": true,
          "default": 160
        },
        "height": {
          "type": "number",
          "minimum": 0,
          "exclusiveMinimum": true,
          "default": 100
        },
        "fontFamily": {
          "type": "string",
          "default": "Arial"
        },
        "fontStyle": {
          "type": "string",
          "default": "normal"
        },
        "fontSize": {
          "type": "string",
          "default": "9pt"
        },
        "fontWeight": {
          "type": "string",
          "default": "normal"
        },
        "textDecoration": {
          "$ref": "#/definitions/TextDecorationType",
          "default": 0
        },
        "foreColor": {
          "type": "string",
          "default": "black"
        },
        "backColor": {
          "type": "string",
          "default": "#FFFFE1"
        },
        "locked": {
          "type": "boolean",
          "default": true
        },
        "lockText": {
          "type": "boolean",
          "default": true
        },
        "horizontalAlign": {
          "$ref": "#/definitions/HorizontalAlign",
          "default": 0
        },
        "autoSize": {
          "type": "boolean",
          "default": false
        },
        "dynamicMove": {
          "type": "boolean",
          "default": true
        },
        "dynamicSize": {
          "type": "boolean",
          "default": true
        },
        "opacity": {
          "type": "number",
          "minimum": 0,
          "maximum": 1,
          "default": 1
        },
        "borderWidth": {
          "type": "number",
          "default": 1
        },
        "borderStyle": {
          "type": "string",
          "default": "solid"
        },
        "borderColor": {
          "type": "string",
          "default": "black"
        },
        "padding": {
          "$ref": "#/definitions/Padding"
        },
        "showShadow": {
          "type": "boolean",
          "default": false
        },
        "displayMode": {
          "$ref": "#/definitions/DisplayMode",
          "default": 2
        },
        "commentState": {
          "$ref": "#/definitions/CommentState",
          "default": 3
        },
        "zIndex": {
          "type": "integer",
          "default": -1
        },
        "ignoreDefaultLocation": {
          "type": "boolean",
          "default": false
        },
        "rowIndex": {
          "type": "integer",
          "default": -1
        },
        "colIndex": {
          "type": "integer",
          "default": -1
        }
      }
    },
    "Padding": {
      "title": "Padding",
      "description": "Represents the padding.",
      "type": "object",
      "properties": {
        "left": {
          "type": "number",
          "default": 0
        },
        "top": {
          "type": "number",
          "default": 0
        },
        "right": {
          "type": "number",
          "default": 0
        },
        "bottom": {
          "type": "number",
          "default": 0
        }
      }
    },
    "Point": {
      "title": "Point",
      "description": "Represents an x and y coordinate pair in two-dimensional space.",
      "type": "object",
      "properties": {
        "x": {
          "type": "number"
        },
        "y": {
          "type": "number"
        }
      }
    },
    "CommentState": {
      "title": "CommentState",
      "description": "Defines the comment state. active:1, edit:2, normal:3",
      "enum": [
        1,
        2,
        3
      ]
    },
    "DisplayMode": {
      "title": "DisplayMode",
      "description": "Defines when the comment is displayed. alwaysShown:1, hoverShown:2.",
      "enum": [
        1,
        2
      ]
    },
    "SheetTable": {
      "title": "SheetTable",
      "description": "Represents a table that can be added in a sheet.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "row": {
          "type": "integer",
          "default": -1
        },
        "col": {
          "type": "integer",
          "default": -1
        },
        "rowCount": {
          "type": "integer",
          "default": -1
        },
        "colCount": {
          "type": "integer",
          "default": -1
        },
        "showHeader": {
          "type": "boolean",
          "default": true
        },
        "showFooter": {
          "type": "boolean",
          "default": false
        },
        "highlightFirstColumn": {
          "type": "boolean",
          "default": false
        },
        "highlightLastColumn": {
          "type": "boolean",
          "default": false
        },
        "bandRows": {
          "type": "boolean",
          "default": true
        },
        "bandColumns": {
          "type": "boolean",
          "default": false
        },
        "style": {
          "$ref": "#/definitions/TableTheme"
        },
        "autoGenerateColumns": {
          "type": "boolean",
          "default": true
        },
        "bindingPath": {
          "type": "string"
        },
        "columns": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/TableColumnInfo"
          }
        },
        "rowFilter": {
          "$ref": "#/definitions/TableFilter"
        }
      }
    },
    "TableColumnInfo": {
      "title": "TableColumnInfo",
      "description": "Represents the table column.",
      "type": "object",
      "properties": {
        "id": {
          "type": "integer"
        },
        "name": {
          "type": "string"
        },
        "dataField": {
          "type": [
            "string",
            "null"
          ]
        },
        "footerFormula": {
          "type": "string"
        },
        "dataAreaFormula": {
          "type": "string"
        },
        "footerValue": {
          "type": [
            "array",
            "boolean",
            "number",
            "null",
            "object",
            "string"
          ]
        }
      }
    },
    "TableTheme": {
      "title": "TableTheme",
      "anyOf": [
        {
          "$ref": "#/definitions/BuildInTableTheme"
        },
        {
          "$ref": "#/definitions/CustomTableTheme"
        }
      ]
    },
    "BuildInTableTheme": {
      "title": "BuildInTableTheme",
      "description": "Represents a built-in table style setting.",
      "type": "object",
      "properties": {
        "buildInName": {
          "type": "string"
        }
      }
    },
    "CustomTableTheme": {
      "title": "CustomTableTheme",
      "description": "Represents a custom table style setting.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "wholeTableStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "headerRowStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "footerRowStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "firstRowStripStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "secondRowStripStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "firstRowStripSize": {
          "type": "number",
          "default": 1
        },
        "secondRowStripSize": {
          "type": "number",
          "default": 1
        },
        "firstColumnStripStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "secondColumnStripStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "firstColumnStripSize": {
          "type": "number",
          "default": 1
        },
        "secondColumnStripSize": {
          "type": "number",
          "default": 1
        },
        "highlightFirstColumnStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "highlightLastColumnStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "firstHeaderCellStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "lastHeaderCellStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "firstFooterCellStyle": {
          "$ref": "#/definitions/TableStyle"
        },
        "lastFooterCellStyle": {
          "$ref": "#/definitions/TableStyle"
        }
      }
    },
    "TableStyle": {
      "title": "TableStyle",
      "description": "Represents table style information.",
      "type": "object",
      "properties": {
        "backColor": {
          "type": "string"
        },
        "foreColor": {
          "type": "string"
        },
        "font": {
          "type": "string"
        },
        "borderLeft": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderTop": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderRight": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderBottom": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderHorizontal": {
          "$ref": "#/definitions/LineBorder"
        },
        "borderVertical": {
          "$ref": "#/definitions/LineBorder"
        },
        "textDecoration": {
          "$ref": "#/definitions/TextDecorationType",
          "default": 0
        }
      }
    },
    "FloatingObject": {
      "title": "FloatingObject",
      "description": "Represents a custom floating object.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "x": {
          "type": "number",
          "default": 0
        },
        "y": {
          "type": "number",
          "default": 0
        },
        "width": {
          "type": "number",
          "default": 0
        },
        "height": {
          "type": "number",
          "default": 0
        },
        "canPrint": {
          "type": "boolean",
          "default": true
        },
        "isSelected": {
          "type": "boolean",
          "default": false
        },
        "isLocked": {
          "type": "boolean",
          "default": true
        },
        "isVisible": {
          "type": "boolean",
          "default": true
        },
        "dynamicMove": {
          "type": "boolean",
          "default": true
        },
        "dynamicSize": {
          "type": "boolean",
          "default": true
        },
        "fixedPosition": {
          "type": "boolean"
        },
        "allowResize": {
          "type": "boolean",
          "default": true
        },
        "allowMove": {
          "type": "boolean",
          "default": true
        },
        "typeName": {
          "type": "string"
        },
        "content": {
          "type": "string"
        }
      }
    },
    "Picture": {
      "title": "Picture",
      "description": "Represents a picture.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "x": {
          "type": "number",
          "default": 0
        },
        "y": {
          "type": "number",
          "default": 0
        },
        "width": {
          "type": "number",
          "default": 0
        },
        "height": {
          "type": "number",
          "default": 0
        },
        "canPrint": {
          "type": "boolean",
          "default": true
        },
        "isSelected": {
          "type": "boolean",
          "default": false
        },
        "isLocked": {
          "type": "boolean",
          "default": true
        },
        "isVisible": {
          "type": "boolean",
          "default": true
        },
        "dynamicMove": {
          "type": "boolean",
          "default": true
        },
        "dynamicSize": {
          "type": "boolean",
          "default": true
        },
        "fixedPosition": {
          "type": "boolean"
        },
        "allowResize": {
          "type": "boolean",
          "default": true
        },
        "allowMove": {
          "type": "boolean",
          "default": true
        },
        "typeName": {
          "type": "string"
        },
        "src": {
          "type": "string"
        },
        "backColor": {
          "type": "string"
        },
        "borderRadius": {
          "type": "number",
          "default": -1
        },
        "borderWidth": {
          "type": "number",
          "default": 1
        },
        "borderStyle": {
          "type": "string",
          "default": "none"
        },
        "borderColor": {
          "type": "string"
        },
        "pictureStretch": {
          "$ref": "#/definitions/ImageLayout",
          "default": 0
        }
      }
    },
    "SpanModel": {
      "title": "SpanModel",
      "description": "Represents a data model for cell spans.",
      "type": "array",
      "items": {
        "$ref": "#/definitions/Range"
      }
    },
    "HeaderAutoText": {
      "title": "HeaderAutoText",
      "description": "Specifies which default labels are displayed in headers. blank:0, numbers:1, letters:2.",
      "enum": [
        0,
        1,
        2
      ]
    },
    "ClipboardPasteOptions": {
      "title": "ClipboardPasteOptions",
      "description": "Specifies what data is pasted from the Clipboard. all:0, values:1, formatting:2, formulas:3.",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "ProtectionOption": {
      "title": "ProtectionOption",
      "description": "Specifies the elements that you want users to be able to change.",
      "type": "object",
      "properties": {
        "allowSelectLockedCells": {
          "type": "boolean"
        },
        "allowSelectUnlockedCells": {
          "type": "boolean"
        },
        "allowSort": {
          "type": "boolean"
        },
        "allowFilter": {
          "type": "boolean"
        },
        "allowEditObjects": {
          "type": "boolean"
        },
        "allowResizeRows": {
          "type": "boolean"
        },
        "allowResizeColumns": {
          "type": "boolean"
        }
      }
    },
    "Outline": {
      "title": "Outline",
      "description": "Represents an outline for the worksheet.",
      "type": "object",
      "properties": {
        "head": {
          "$ref": "#/definitions/OutlineItemInfo"
        },
        "tail": {
          "$ref": "#/definitions/OutlineItemInfo"
        },
        "direction": {
          "$ref": "#/definitions/OutlineDirection",
          "default": 1
        },
        "itemsData": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "index": {
                "type": "integer"
              },
              "count": {
                "type": "integer"
              },
              "info": {
                "$ref": "#/definitions/OutlineItemInfo"
              }
            }
          }
        }
      }
    },
    "OutlineItemInfo": {
      "title": "OutlineItemInfo",
      "description": "Represents an outline item information.",
      "type": "object",
      "properties": {
        "level": {
          "type": "integer",
          "default": 0
        },
        "collapsed": {
          "type": "boolean",
          "default": false
        }
      }
    },
    "OutlineDirection": {
      "title": "OutlineDirection",
      "description": "Specifies the status of an outline summary row or column position. backward:0, forward:1.",
      "enum": [
        0,
        1
      ]
    },
    "SparklineEx": {
      "title": "SparklineEx",
      "description": "Represents the base class for the other SparklineEx classes.",
      "type": "object",
      "properties": {
        "typeName": {
          "type": "string",
          "default": ""
        }
      }
    },
    "ResizeZeroIndicator": {
      "title": "ResizeZeroIndicator",
      "description": "Specifies the drawing policy of the row or column when it is resized to zero. default:0, enhanced:1.",
      "enum": [
        0,
        1
      ]
    },
    "PrintInfo": {
      "title": "PrintInfo",
      "description": "Represents the information to use when printing a sheet.",
      "type": "object",
      "properties": {
        "bestFitRows": {
          "type": "boolean",
          "default": false
        },
        "bestFitColumns": {
          "type": "boolean",
          "default": false
        },
        "columnStart": {
          "type": "number",
          "default": -1
        },
        "columnEnd": {
          "type": "number",
          "default": -1
        },
        "rowStart": {
          "type": "number",
          "default": -1
        },
        "rowEnd": {
          "type": "number",
          "default": -1
        },
        "repeatColumnStart": {
          "type": "number",
          "default": -1
        },
        "repeatColumnEnd": {
          "type": "number",
          "default": -1
        },
        "repeatRowStart": {
          "type": "number",
          "default": -1
        },
        "repeatRowEnd": {
          "type": "number",
          "default": -1
        },
        "showBorder": {
          "type": "boolean",
          "default": true
        },
        "showGridLine": {
          "type": "boolean",
          "default": false
        },
        "showColumnHeader": {
          "$ref": "#/definitions/PrintVisibilityType",
          "default": 0
        },
        "showRowHeader": {
          "$ref": "#/definitions/PrintVisibilityType",
          "default": 0
        },
        "useMax": {
          "type": "boolean",
          "default": true
        },
        "centering": {
          "$ref": "#/definitions/PrintCentering",
          "default": 0
        },
        "firstPageNumber": {
          "type": "number",
          "default": 1
        },
        "headerLeft": {
          "type": "string"
        },
        "headerCenter": {
          "type": "string"
        },
        "headerRight": {
          "type": "string"
        },
        "footerLeft": {
          "type": "string"
        },
        "footerCenter": {
          "type": "string"
        },
        "footerRight": {
          "type": "string"
        },
        "headerLeftImage": {
          "type": "string"
        },
        "headerCenterImage": {
          "type": "string"
        },
        "headerRightImage": {
          "type": "string"
        },
        "footerLeftImage": {
          "type": "string"
        },
        "footerCenterImage": {
          "type": "string"
        },
        "footerRightImage": {
          "type": "string"
        },
        "margin": {
          "$ref": "#/definitions/PrintMargins"
        },
        "orientation": {
          "$ref": "#/definitions/PrintPageOrientation",
          "default": 1
        },
        "pageRange": {
          "type": "string"
        },
        "pageOrder": {
          "$ref": "#/definitions/PrintPageOrder",
          "default": 0
        },
        "blackAndWhite": {
          "type": "boolean",
          "default": false
        },
        "zoomFactor": {
          "type": "number",
          "default": 1
        },
        "fitPagesTall": {
          "type": "number",
          "default": -1
        },
        "fitPagesWide": {
          "type": "number",
          "default": -1
        },
        "paperSize": {
          "$ref": "#/definitions/PaperSize"
        }
      }
    },
    "PrintVisibilityType": {
      "title": "PrintVisibilityType",
      "description": "Specifies whether the area is visible. inherit:0, hide:1, show:2, showOnce:3",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "PrintCentering": {
      "title": "PrintCentering",
      "description": "Specifies the type of centering for the printed page. none:0, horizontal:1, vertical:2, both:3",
      "enum": [
        0,
        1,
        2,
        3
      ]
    },
    "PrintPageOrientation": {
      "title": "PrintPageOrientation",
      "description": "Specifies the page orientation used for printing. portrait:1, landscape:2",
      "enum": [
        1,
        2
      ]
    },
    "PrintPageOrder": {
      "title": "PrintPageOrder",
      "description": "Specifies the order in which pages are printed. auto:0, downThenOver:1, overThenDown:2",
      "enum": [
        0,
        1,
        2
      ]
    },
    "PaperKind": {
      "title": "PaperKind",
      "description": "Specifies the paper kind for the printed page. 0 : custom, 1 : letter, 2 : letterSmall, 3 : tabloid, 4 : ledger, 5 : legal, 6 : statement, 7 : executive, 8 : a3, 9 : a4, 10 : a4Small, 11 : a5, 12 : b4, 13 : b5, 14 : folio, 15 : quarto, 16 : standard10x14, 17 : standard11x17, 18 : note, 19 : number9Envelope, 20 : number10Envelope, 21 : number11Envelope, 22 : number12Envelope, 23 : number14Envelope, 24 : cSheet, 25 : dSheet, 26 : eSheet, 27 : dLEnvelope, 28 : c5Envelope, 29 : c3Envelope, 30 : c4Envelope, 31 : c6Envelope, 32 : c65Envelope, 33 : b4Envelope, 34 : b5Envelope, 35 : b6Envelope, 36 : italyEnvelope, 37 : monarchEnvelope, 38 : personalEnvelope, 39 : uSStandardFanfold, 40 : germanStandardFanfold, 41 : germanLegalFanfold, 42 : isoB4, 43 : japanesePostcard, 44 : standard9x11, 45 : standard10x11, 46 : standard15x11, 47 : inviteEnvelope, 50 : letterExtra, 51 : legalExtra, 52 : tabloidExtra, 53 : a4Extra, 54 : letterTransverse, 55 : a4Transverse, 56 : letterExtraTransverse, 57 : aPlus, 58 : bPlus, 59 : letterPlus, 60 : a4Plus, 61 : a5Transverse, 62 : b5Transverse, 63 : a3Extra, 64 : a5Extra, 65 : b5Extra, 66 : a2, 67 : a3Transverse, 68 : a3ExtraTransverse, 69 : japaneseDoublePostcard, 70 : a6, 71 : japaneseEnvelopeKakuNumber2, 72 : japaneseEnvelopeKakuNumber3, 73 : japaneseEnvelopeChouNumber3, 74 : japaneseEnvelopeChouNumber4, 75 : letterRotated, 76 : a3Rotated, 77 : a4Rotated, 78 : a5Rotated, 79 : b4JisRotated, 80 : b5JisRotated, 81 : japanesePostcardRotated, 82 : japaneseDoublePostcardRotated, 83 : a6Rotated, 84 : japaneseEnvelopeKakuNumber2Rotated, 85 : japaneseEnvelopeKakuNumber3Rotated, 86 : japaneseEnvelopeChouNumber3Rotated, 87 : japaneseEnvelopeChouNumber4Rotated, 88 : b6Jis, 89 : b6JisRotated, 90 : standard12x11, 91 : japaneseEnvelopeYouNumber4, 92 : japaneseEnvelopeYouNumber4Rotated, 93 : prc16K, 94 : prc32K, 95 : prc32KBig, 96 : prcEnvelopeNumber1, 97 : prcEnvelopeNumber2, 98 : prcEnvelopeNumber3, 99 : prcEnvelopeNumber4, 100 : prcEnvelopeNumber5, 101 : prcEnvelopeNumber6,102 : prcEnvelopeNumber7,103 : prcEnvelopeNumber8,104 : prcEnvelopeNumber9,105 : prcEnvelopeNumber10,106: prc16KRotated,107: prc32KRotated,108: prc32KBigRotated,109: prcEnvelopeNumber1Rotated,110: prcEnvelopeNumber2Rotated,111: prcEnvelopeNumber3Rotated,112: prcEnvelopeNumber4Rotated,113: prcEnvelopeNumber5Rotated,114: prcEnvelopeNumber6Rotated,115: prcEnvelopeNumber7Rotated,116: prcEnvelopeNumber8Rotated,117: prcEnvelopeNumber9Rotated,118: prcEnvelopeNumber10Rotated",
      "enum": [
        0,
        1,
        2,
        3,
        4,
        5,
        6,
        7,
        8,
        9,
        10,
        11,
        12,
        13,
        14,
        15,
        16,
        17,
        18,
        19,
        20,
        21,
        22,
        23,
        24,
        25,
        26,
        27,
        28,
        29,
        30,
        31,
        32,
        33,
        34,
        35,
        36,
        37,
        38,
        39,
        40,
        41,
        42,
        43,
        44,
        45,
        46,
        47,
        50,
        51,
        52,
        53,
        54,
        55,
        56,
        57,
        58,
        59,
        60,
        61,
        62,
        63,
        64,
        65,
        66,
        67,
        68,
        69,
        70,
        71,
        72,
        73,
        74,
        75,
        76,
        77,
        78,
        79,
        80,
        81,
        82,
        83,
        84,
        85,
        86,
        87,
        88,
        89,
        90,
        91,
        92,
        93,
        94,
        95,
        96,
        97,
        98,
        99,
        100,
        101,
        102,
        103,
        104,
        105,
        106,
        107,
        108,
        109,
        110,
        111,
        112,
        113,
        114,
        115,
        116,
        117,
        118
      ]
    },
    "PrintMargins": {
      "title": "PrintMargins",
      "description": "Specifies the dimensions of the printed page margins.",
      "type": "object",
      "properties": {
        "top": {
          "type": "number",
          "default": 75
        },
        "bottom": {
          "type": "number",
          "default": 75
        },
        "left": {
          "type": "number",
          "default": 70
        },
        "right": {
          "type": "number",
          "default": 70
        },
        "header": {
          "type": "number",
          "default": 30
        },
        "footer": {
          "type": "number",
          "default": 30
        }
      }
    },
    "PaperSize": {
      "title": "PaperSize",
      "description": "Specifies the paper size.",
      "properties": {
        "height": {
          "type": "number"
        },
        "width": {
          "type": "number"
        },
        "kind": {
          "$ref": "#/definitions/PaperKind"
        }
      }
    },
    "Slicer": {
      "title": "Slicer",
      "description": "Represents a slicer.",
      "type": "object",
      "properties": {
        "x": {
          "type": "number",
          "default": 100
        },
        "y": {
          "type": "number",
          "default": 100
        },
        "width": {
          "type": "number",
          "default": 192
        },
        "height": {
          "type": "number",
          "default": 250
        },
        "dynamicMove": {
          "type": "boolean",
          "default": false
        },
        "dynamicSize": {
          "type": "boolean",
          "default": false
        },
        "isLocked": {
          "type": "boolean",
          "default": true
        },
        "fixedPosition": {
          "type": "boolean",
          "default": false
        },
        "sourceName": {
          "type": "string"
        },
        "tableName": {
          "type": "string"
        },
        "name": {
          "type": "string"
        },
        "captionName": {
          "type": "string"
        },
        "columnCount": {
          "type": "number",
          "default": 1
        },
        "itemHeight": {
          "type": "number",
          "default": 21
        },
        "showHeader": {
          "type": "boolean",
          "default": true
        },
        "sortState": {
          "$ref": "#/definitions/SortState",
          "default": 1
        },
        "disableResizingAndMoving": {
          "type": "boolean",
          "default": false
        },
        "showNoDataItems": {
          "type": "boolean",
          "default": true
        },
        "showNoDataItemsInLast": {
          "type": "boolean",
          "default": true
        },
        "visuallyNoDataItems": {
          "type": "boolean",
          "default": true
        },
        "style": {
          "$ref": "#/definitions/SlicerStyle"
        },
        "columnName": {
          "type": "string"
        },
        "nameInFormula": {
          "type": "string"
        }
      }
    },
    "SlicerStyle": {
      "title": "SlicerStyle",
      "description": "Represents the slicer style settings.",
      "type": "object",
      "properties": {
        "name": {
          "type": "string",
          "default": ""
        },
        "wholeSlicerStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "headerStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "selectedItemWithDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "selectedItemWithNoDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "unSelectedItemWithDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "unSelectedItemWithNoDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "hoveredSelectedItemWithDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "hoveredSelectedItemWithNoDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "hoveredUnSelectedItemWithDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        },
        "hoveredUnSelectedItemWithNoDataStyle": {
          "$ref": "#/definitions/SlicerStyleInfo"
        }
      }
    },
    "SlicerStyleInfo": {
      "title": "SlicerStyleInfo",
      "description": "Represents slicer style information.",
      "type": "object",
      "properties": {
        "backColor": {
          "type": "string",
          "default": "white"
        },
        "foreColor": {
          "type": "string",
          "default": "black"
        },
        "font": {
          "type": "string",
          "default": "normal 11pt calibri"
        },
        "borderLeft": {
          "$ref": "#/definitions/SlicerBorder"
        },
        "borderTop": {
          "$ref": "#/definitions/SlicerBorder"
        },
        "borderRight": {
          "$ref": "#/definitions/SlicerBorder"
        },
        "borderBottom": {
          "$ref": "#/definitions/SlicerBorder"
        },
        "textDecoration": {
          "$ref": "#/definitions/TextDecorationType",
          "default": 0
        }
      }
    },
    "SlicerBorder": {
      "title": "SlicerBorder",
      "description": "Represents the slicer border.",
      "type": "object",
      "properties": {
        "borderWidth": {
          "type": "number",
          "default": 0
        },
        "borderStyle": {
          "type": "number",
          "default": ""
        },
        "borderColor": {
          "type": "number",
          "default": ""
        }
      }
    },
    "SortState": {
      "title": "SortState",
      "description": "Specifies the type of sorting to perform. none:0, ascending:1, descending:2.",
      "enum": [
        0,
        1,
        2
      ]
    }
  }
}

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.