| SpreadJS Documentation > Developer's Guide > Managing Data > Using JSON Schema with SpreadJS > Spread Schema |
This is the Spread full version JSON Schema.
| Schema |
Copy Code
|
|---|---|
{
"$schema" : "http://json-schema.org/draft-04/schema#",
"title" : "Spread",
"description" : "Represent 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 cannot be null, undefined, or '', it must be a value.",
"items" : {
"$ref" : "#/definitions/Style"
}
},
"names" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/NameInfo"
}
},
"activeSheetIndex" : {
"type" : "integer"
},
"sheetCount" : {
"type" : "integer",
"minimum" : 0
},
"tabStripRatio" : {
"type" : "number",
"default" : 0.5
},
"tabStripVisible" : {
"type" : "boolean",
"default" : true
},
"tabNavigationVisible" : {
"type" : "boolean",
"default" : true
},
"tabEditable" : {
"type" : "boolean",
"default" : true
},
"newTabVisible" : {
"type" : "boolean",
"default" : true
},
"referenceStyle" : {
"$ref" : "#/definitions/ReferenceStyle",
"default" : 0
},
"canUserEditFormula" : {
"type" : "boolean",
"default" : true
},
"startSheetIndex" : {
"type" : "integer",
"default" : 0
},
"allowUndo" : {
"type" : "boolean",
"default" : true
},
"allowUserZoom" : {
"type" : "boolean",
"default" : true
},
"allowUserResize" : {
"type" : "boolean",
"default" : true
},
"allowDragDrop" : {
"type" : "boolean",
"default" : true
},
"allowDragFill" : {
"type" : "boolean",
"default" : true
},
"showDragFillSmartTag" : {
"type" : "boolean",
"default" : true
},
"defaultDragFillType" : {
"$ref" : "#/definitions/AutoFillType",
"default" : 5
},
"allowSheetReorder" : {
"type" : "boolean",
"default" : true
},
"highlightInvalidData" : {
"type" : "boolean",
"default" : false
},
"autoFitType" : {
"$ref" : "#/definitions/AutoFitType",
"default" : 0
},
"showScrollTip" : {
"$ref" : "#/definitions/ShowScrollTip",
"default" : 0
},
"showResizeTip" : {
"$ref" : "#/definitions/ShowResizeTip",
"default" : 0
},
"showDragDropTip" : {
"type" : "boolean",
"default" : true
},
"showDragFillTip" : {
"type" : "boolean",
"default" : true
},
"showHorizontalScrollbar" : {
"type" : "boolean",
"default" : true
},
"showVerticalScrollbar" : {
"type" : "boolean",
"default" : true
},
"scrollbarMaxAlign" : {
"type" : "boolean",
"default" : false
},
"scrollbarShowMax" : {
"type" : "boolean",
"default" : true
},
"backColor" : {
"type" : "string",
"default" : "white"
},
"backgroundImage" : {
"type" : "string"
},
"backgroundImageLayout" : {
"$ref" : "#/definitions/ImageLayout",
"default" : 0
},
"grayAreaBackColor" : {
"type" : "string",
"default" : "gray"
},
"cutCopyIndicatorVisible" : {
"type" : "boolean",
"default" : "true"
},
"cutCopyIndicatorBorderColor" : {
"type" : "string",
"default" : "#217346"
},
"useTouchLayout" : {
"type" : "boolean",
"default" : false
},
"hideSelection" : {
"type" : "boolean",
"default" : false
},
"sparklineExs" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/SparklineEx"
}
},
"customFunctions" : {
"type" : "object",
"patternProperties" : {
".+" : {
"$ref" : "#/definitions/Function"
}
}
},
"resizeZeroIndicator" : {
"$ref" : "#/definitions/ResizeZeroIndicator",
"default" : 1
}
},
"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, and column.",
"type" : "object",
"properties" : {
"backgroundImage" : {
"type" : "string"
},
"backgroundImageLayout" : {
"$ref" : "#/definitions/ImageLayout"
},
"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"
},
"validator" : {
"$ref" : "#/definitions/DefaultDataValidator"
},
"cellType" : {
"$ref" : "#/definitions/CellType"
},
"name" : {
"type" : "string"
},
"parentName" : {
"type" : "string"
},
"tabStop" : {
"type" : "boolean"
},
"textDecoration" : {
"$ref" : "#/definitions/TextDecorationType"
},
"imeMode" : {
"$ref" : "#/definitions/ImeMode"
},
"watermark" : {
"type" : "string"
}
}
},
"CellType" : {
"title" : "CellType",
"allOf" : [{
"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/CustomCellType"
}
]
}, {
"$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 of '0'.",
"type" : "string"
}
}
},
"CornerCellType" : {
"title" : "CornerCellType",
"description" : "Represents the painter for the corner cell.",
"type" : "object",
"properties" : {
"typeName" : {
"description" : "The value is a fixed value of '4'.",
"type" : "string"
}
}
},
"RowHeaderCellType" : {
"title" : "RowHeaderCellType",
"description" : "Represents the painter for the row header cells.",
"type" : "object",
"properties" : {
"typeName" : {
"description" : "The value is a fixed value of '3'.",
"type" : "string"
}
}
},
"ColumnHeaderCellType" : {
"title" : "ColumnHeaderCellType",
"description" : "Represents the painter for the column header cells.",
"type" : "object",
"properties" : {
"typeName" : {
"description" : "The value is a fixed value of '2'.",
"type" : "string"
}
}
},
"TextCellType" : {
"title" : "TextCellType",
"description" : "Represents a text cell type.",
"type" : "object",
"properties" : {
"typeName" : {
"description" : "The value is a fixed value of '1'.",
"type" : "string"
}
}
},
"ButtonCellType" : {
"title" : "ButtonCellType",
"description" : " Represents a button cell.",
"type" : "object",
"properties" : {
"typeName" : {
"description" : "The value is a fixed value of '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 of '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 of '7'.",
"type" : "string"
},
"editorValueType" : {
"$ref" : "#/definitions/EditorValueType",
"default" : 0
},
"items" : {
"type" : "array",
"items" : {
"type" : ["array", "boolean", "number", "null", "object", "string"]
}
}
}
},
"HyperLinkCellType" : {
"title" : "HyperLinkCellType",
"description" : "Represents the hyperlink cell.",
"type" : "object",
"properties" : {
"typeName" : {
"description" : "The value is a fixed value of '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
}
}
},
"CustomCellType" : {
"title" : "CustomCellType",
"description" : "Represents the custom cell.",
"type" : "object",
"properties" : {
"typeName" : {
"type" : "string",
"default" : ""
}
}
},
"CellTypeKind" : {
"title" : "CellTypeKind",
"description" : "Specific the cellType kind. BaseCellType:0,TextCellType:1,ColumnHeaderCellType:2,RowHeaderCellType:3,CornerCellType:4,CheckBoxCellType:5,ButtonCellType:6,ComboBoxCellType:7,HyperLinkCellType:8.",
"enum" : [0, 1, 2, 3, 4, 5, 6, 7, 8]
},
"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" : {
"formatModeType" : {
"$ref" : "#/definitions/FormatMode",
"default" : 0
},
"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" : ""
}
}
},
"FormatMode" : {
"title" : "FormatMode",
"description" : "Represents the format mode. CustomMode:0,StandardDateTimeMode:1,StandardNumbericMode:2.",
"enum" : [0, 1, 2]
},
"ImageLayout" : {
"title" : "ImageLayout",
"description" : " Defines the background image layout. Stretch:0,Center:1,Zoom:2,None:3.",
"enum" : [0, 1, 2, 3]
},
"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/RelationCompareType"
},
"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/GeneralCompareType"
},
"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/GeneralCompareType"
},
"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/GeneralCompareType"
},
"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
}
}
},
"RegExp" : {
"title" : "RegExp",
"description" : "A javaScript built-in 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"
}
}
},
"RelationCompareType" : {
"title" : "RelationCompareType",
"description" : "Specifies the relation operator. Or:0,And:1.",
"enum" : [0, 1]
},
"GeneralCompareType" : {
"title" : "GeneralCompareType",
"description" : "Specifies the general operator. EqualsTo:0,NotEqualsTo:1,GreaterThan:2,GreaterThanOrEqualsTo:3,LessThan:4,LessThanOrEqualsTo:5.",
"enum" : [0, 1, 2, 3, 4, 5]
},
"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]
},
"LineBorder" : {
"title" : "LineBorder",
"description" : "Indicates the color of the border line. Uses 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:3.",
"enum" : [0, 1, 2, 3]
},
"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,ClearValues: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"
},
"namedStyles" : {
"type" : "array",
"description" : "The name property of the Style in namedStyles cannot be null, undefined or '', it must be set a value.",
"items" : {
"$ref" : "#/definitions/Style"
}
},
"names" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/NameInfo"
}
},
"selections" : {
"$ref" : "#/definitions/SelectionModel"
},
"rowFilter" : {
"anyOf" : [{
"$ref" : "#/definitions/HideRowFilter"
}, {
"$ref" : "#/definitions/RowFilterBase"
}
]
},
"defaults" : {
"$ref" : "#/definitions/SheetDefaultOption"
},
"columns" : {
"type" : "array",
"items" : {
"anyOf" : [{
"type" : "null"
}, {
"$ref" : "#/definitions/RowColInfo"
}
]
}
},
"rows" : {
"type" : "array",
"items" : {
"anyOf" : [{
"type" : "null"
}, {
"$ref" : "#/definitions/RowColInfo"
}
]
}
},
"autoGenerateColumns" : {
"type" : "boolean",
"default" : true
},
"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"
},
"sparklineGroups" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/SparklineGroup"
}
},
"comments" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/Comment"
}
},
"spans" : {
"$ref" : "#/definitions/SpanModel"
},
"selectionBackColor" : {
"type" : "string",
"default" : "rgba(180,180,200,0.2)"
},
"selectionBorderColor" : {
"type" : "string",
"default" : "black"
},
"activeRow" : {
"type" : "integer",
"default" : 0
},
"activeCol" : {
"type" : "integer",
"default" : 0
},
"gridline" : {
"$ref" : "#/definitions/SheetGridlineOption"
},
"allowCellOverflow" : {
"type" : "boolean",
"default" : false
},
"referenceStyle" : {
"$ref" : "#/definitions/ReferenceStyle",
"default" : 0
},
"zoomFactor" : {
"type" : "number",
"minimum" : 0.25,
"maximum" : 4.0,
"default" : 1.0
},
"theme" : {
"anyOf" : [{
"type" : "string"
}, {
"$ref" : "#/definitions/SpreadTheme"
}
]
},
"showRowRangeGroup" : {
"type" : "boolean",
"default" : true
},
"showColumnRangeGroup" : {
"type" : "boolean",
"default" : true
},
"conditionalFormats" : {
"type" : "object",
"properties" : {
"rules" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/Rule"
}
}
}
},
"sheetTabColor" : {
"type" : "string"
},
"frozenlineColor" : {
"type" : "string",
"default" : "black"
},
"rowHeaderAutoText" : {
"$ref" : "#/definitions/HeaderAutoText",
"default" : 1
},
"colHeaderAutoText" : {
"$ref" : "#/definitions/HeaderAutoText",
"default" : 2
},
"rowHeaderAutoTextIndex" : {
"type" : "integer",
"default" : -1
},
"colHeaderAutoTextIndex" : {
"type" : "integer",
"default" : -1
},
"rowHeaderVisible" : {
"type" : "boolean",
"default" : true
},
"colHeaderVisible" : {
"type" : "boolean",
"default" : true
},
"rowHeaderColCount" : {
"type" : "integer",
"default" : 1
},
"colHeaderRowCount" : {
"type" : "integer",
"default" : 1
},
"rowHeaderSpan" : {
"$ref" : "#/definitions/SpanModel"
},
"colHeaderSpan" : {
"$ref" : "#/definitions/SpanModel"
},
"rowHeaderColInfos" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/RowColInfo"
}
},
"colHeaderRowInfos" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/RowColInfo"
}
},
"clipBoardOptions" : {
"$ref" : "#/definitions/ClipboardPasteOptions",
"default" : 0
},
"isProtected" : {
"type" : "boolean",
"default" : false
},
"protectionOption" : {
"$ref" : "#/definitions/ProtectionOption"
},
"borderColor" : {
"type" : "string",
"default" : "black"
},
"borderWidth" : {
"type" : "integer",
"minimum" : 0,
"default" : 0
},
"allowUndo" : {
"type" : "boolean",
"default" : true
},
"allowEditorReservedLocations" : {
"type" : "boolean",
"default" : true
},
"tables" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/SheetTable"
}
},
"floatingObjects" : {
"type" : "array",
"items" : {
"anyOf" : [{
"$ref" : "#/definitions/CustomFloatingObject"
}, {
"$ref" : "#/definitions/Picture"
}
]
}
},
"visible" : {
"type" : "boolean",
"default" : true
},
"rowHeaderData" : {
"$ref" : "#/definitions/SheetModel"
},
"colHeaderData" : {
"$ref" : "#/definitions/SheetModel"
},
"data" : {
"$ref" : "#/definitions/SheetModel"
},
"rowRangeGroup" : {
"$ref" : "#/definitions/RangeGroup"
},
"colRangeGroup" : {
"$ref" : "#/definitions/RangeGroup"
},
"tag" : {
"type" : ["array", "boolean", "number", "null", "object", "string"]
},
"customFunctions" : {
"type" : "object",
"patternProperties" : {
".+" : {
"$ref" : "#/definitions/Function"
}
}
},
"printInfo" : {
"$ref" : "#/definitions/PrintInfo"
},
"slicers" : {
"type" : "array",
"items" : {
"$ref" : "#/definitions/Slicer"
}
}
}
},
"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" : ""
}
}
},
"SelectionModel" : {
"title" : "SelectionModel",
"description" : "Represents 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]
},
"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]+" : {
"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's index that realtive to the table.",
"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]+" : {
"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"
},
"name" : {
"type" : "string"
},
"displayName" : {
"type" : "string"
}
}
},
"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"
},
"displayMode" : {
"$ref" : "#/definitions/DisplayMode",
"default" : 2
},
"commentState" : {
"$ref" : "#/definitions/CommentState",
"default" : 3
},
"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"
},
"opacity" : {
"type" : "number",
"minimum" : 0,
"maximum" : 1,
"default" : 1
},
"locked" : {
"type" : "boolean",
"default" : true
},
"lockText" : {
"type" : "boolean",
"default" : true
},
"dynamicMove" : {
"type" : "boolean",
"default" : true
},
"dynamicSize" : {
"type" : "boolean",
"default" : true
},
"horizontalAlign" : {
"$ref" : "#/definitions/HorizontalAlign",
"default" : 0
},
"autoSize" : {
"type" : "boolean",
"default" : false
},
"borderWidth" : {
"type" : "number",
"default" : 1
},
"borderStyle" : {
"type" : "string",
"default" : "solid"
},
"borderColor" : {
"type" : "string",
"default" : "black"
},
"padding" : {
"$ref" : "#/definitions/Padding"
},
"zIndex" : {
"type" : "integer",
"default" : -1
},
"showShadow" : {
"type" : "boolean",
"default" : false
},
"rowIndex" : {
"type" : "integer",
"default" : -1
},
"colIndex" : {
"type" : "integer",
"default" : -1
}
}
},
"Padding" : {
"title" : "Padding",
"description" : "Represents 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 state of Comment. 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/TableStyle"
},
"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"]
}
}
},
"TableStyle" : {
"title" : "TableStyle",
"description" : " Represents the table style settings.",
"type" : "object",
"properties" : {
"name" : {
"type" : "string"
},
"buildInName" : {
"type" : "string"
},
"wholeTableStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"headerRowStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"footerRowStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"firstRowStripStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"secondRowStripStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"firstRowStripSize" : {
"type" : "number",
"default" : 1
},
"secondRowStripSize" : {
"type" : "number",
"default" : 1
},
"firstColumnStripStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"secondColumnStripStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"firstColumnStripSize" : {
"type" : "number",
"default" : 1
},
"secondColumnStripSize" : {
"type" : "number",
"default" : 1
},
"highlightFirstColumnStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"highlightLastColumnStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"firstHeaderCellStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"lastHeaderCellStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"firstFooterCellStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
},
"lastFooterCellStyle" : {
"$ref" : "#/definitions/TableStyleInfo"
}
}
},
"TableStyleInfo" : {
"title" : "TableStyleInfo",
"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"
}
}
},
"CustomFloatingObject" : {
"title" : "CustomFloatingObject",
"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
},
"floatingObjectType" : {
"$ref" : "#/definitions/FloatingObjectType"
},
"content" : {
"type" : "string"
},
"fixedPosition" : {
"type" : "boolean"
}
}
},
"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
},
"src" : {
"type" : "string"
},
"floatingObjectType" : {
"$ref" : "#/definitions/FloatingObjectType"
},
"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
},
"fixedPosition" : {
"type" : "boolean"
}
}
},
"FloatingObjectType" : {
"title" : "FloatingObjectType",
"description" : "Represents a floatingObject type. CustomFloatingObject:0,Picture:1.",
"enum" : [0, 1]
},
"SpanModel" : {
"title" : "SpanModel",
"description" : "Represents a data model for cell spans.",
"type" : "array",
"items" : {
"$ref" : "#/definitions/Range"
}
},
"SheetModel" : {
"title" : "",
"description" : "",
"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"]
},
"formula" : {
"type" : ["string", "null"]
},
"style" : {
"anyOf" : [{
"type" : "string"
}, {
"$ref" : "#/definitions/Style"
}
]
},
"visualstate" : {
"$ref" : "#/definitions/VisualState"
},
"bindingPath" : {
"type" : "string"
},
"tag" : {
"type" : ["array", "boolean", "number", "null", "object", "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"
}
]
}
}
}
}
},
"VisualState" : {
"title" : "VisualState",
"description" : " Specifies the visual state. Normal:0,Highlight:1,Selected:2,Active:3,Hover:4.",
"enum" : [0, 1, 2, 3, 4]
},
"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
}
}
},
"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 a 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:0,Percent:4,Percentile:5,Formula:7.",
"enum" : [1, 4, 5, 7]
},
"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]
},
"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]
},
"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]
},
"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"
}
}
},
"RangeGroup" : {
"title" : "RangeGroup",
"description" : "Represents a range group for the worksheet.",
"type" : "object",
"properties" : {
"head" : {
"$ref" : "#/definitions/RangeGroupItemInfo"
},
"tail" : {
"$ref" : "#/definitions/RangeGroupItemInfo"
},
"direction" : {
"$ref" : "#/definitions/RangeGroupDirection",
"default" : 1
},
"itemsData" : {
"type" : "array",
"items" : {
"type" : "object",
"properties" : {
"index" : {
"type" : "integer"
},
"count" : {
"type" : "integer"
},
"info" : {
"$ref" : "#/definitions/RangeGroupItemInfo"
}
}
}
}
}
},
"RangeGroupItemInfo" : {
"title" : "RangeGroupItemInfo",
"description" : " ",
"type" : "object",
"properties" : {
"level" : {
"type" : "integer"
},
"collapsed" : {
"type" : "boolean"
}
}
},
"GroupState" : {
"title" : "GroupState",
"description" : "Specifies the status of an outline (range group). Expanded:0,Collapsed:1.",
"enum" : [0, 1]
},
"RangeGroupDirection" : {
"title" : "RangeGroupDirection",
"description" : "Specifies the status of a range group 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"
},
"bestFitColumns" : {
"type" : "boolean"
},
"columnStart" : {
"type" : "number"
},
"columnEnd" : {
"type" : "number"
},
"rowStart" : {
"type" : "number"
},
"rowEnd" : {
"type" : "number"
},
"repeatColumnStart" : {
"type" : "number"
},
"repeatColumnEnd" : {
"type" : "number"
},
"repeatRowStart" : {
"type" : "number"
},
"repeatRowEnd" : {
"type" : "number"
},
"showBorder" : {
"type" : "boolean"
},
"showGridLine" : {
"type" : "boolean"
},
"showColumnHeader" : {
"$ref" : "#/definitions/PrintVisibilityType"
},
"showRowHeader" : {
"$ref" : "#/definitions/PrintVisibilityType"
},
"useMax" : {
"type" : "boolean"
},
"centering" : {
"$ref" : "#/definitions/Centering"
},
"firstPageNumber" : {
"type" : "number"
},
"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/Margins"
},
"orientation" : {
"$ref" : "#/definitions/PrintPageOrientation"
},
"pageRange" : {
"type" : "string"
},
"pageOrder" : {
"$ref" : "#/definitions/PrintPageOrder"
},
"blackAndWhite" : {
"type" : "boolean"
},
"zoomFactor" : {
"type" : "number"
},
"fitPagesTall" : {
"type" : "number"
},
"fitPagesWide" : {
"type" : "number"
},
"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]
},
"Centering" : {
"title" : "Centering",
"description" : "Specifics 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"
},
"bottom" : {
"type" : "number"
},
"left" : {
"type" : "number"
},
"right" : {
"type" : "number"
},
"header" : {
"type" : "number"
},
"footer" : {
"type" : "number"
}
}
},
"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" : {
"name" : {
"type" : "string"
},
"x" : {
"type" : "number",
"default" : 100
},
"y" : {
"type" : "number",
"default" : 100
},
"width" : {
"type" : "number",
"default" : 192
},
"height" : {
"type" : "number",
"default" : 250
},
"sourceName" : {
"type" : "string"
},
"nameInFormula" : {
"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
},
"visuallyNoDataItems" : {
"type" : "boolean",
"default" : true
},
"showNoDataItemsInLast" : {
"type" : "boolean",
"default" : true
},
"style" : {
"$ref" : "#/definitions/SlicerStyle"
},
"dynamicMove" : {
"type" : "boolean",
"default" : false
},
"dynamicSize" : {
"type" : "boolean",
"default" : false
},
"isLocked" : {
"type" : "boolean",
"default" : true
},
"fixedPosition" : {
"type" : "boolean",
"default" : false
},
"tableName" : {
"type" : "string"
},
"dataName" : {
"type" : "string"
}
}
},
"SlicerStyle" : {
"title" : "SlicerStyle",
"description" : "Represents the slicer style settings.",
"type" : "object",
"properties" : {
"name" : {
"type" : "string",
"default" : ""
},
"wholeSlicerStyle" : {
"type" : "object"
},
"headerStyle" : {
"type" : "object"
},
"selectedItemWithDataStyle" : {
"type" : "object"
},
"selectedItemWithNoDataStyle" : {
"type" : "object"
},
"unSelectedItemWithDataStyle" : {
"type" : "object"
},
"unSelectedItemWithNoDataStyle" : {
"type" : "object"
},
"hoveredSelectedItemWithDataStyle" : {
"type" : "object"
},
"hoveredSelectedItemWithNoDataStyle" : {
"type" : "object"
},
"hoveredUnSelectedItemWithDataStyle" : {
"type" : "object"
},
"hoveredUnSelectedItemWithNoDataStyle" : {
"type" : "object"
}
}
},
"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"
}
}
},
"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]
}
}
}
|
|