Format
Format provides styling and display options for a cell, but can also be applied to rows, columns, sheets and the complete workbook.
Examples
"emphasize-blue": {
"italic": true,
"border": "double",
"alignH": 2,
"backgroundColor": {
"name": "aqua"
}
}
Implementations
Properties
name | type | description | ||||
---|---|---|---|---|---|---|
dataType | string | data type of cell possible values: string number date blank timestamp formula | ||||
alignH | integer | Horizontal alignment of text possible values: 0 general1 left2 center3 right4 full5 justify6 merge7 distributed | ||||
alignV | integer | Vertical alignment of text possible values: 0 Top1 Center2 Bottom3 Justify4 Distributed | ||||
backgroundColor | object | Contains color as Name, Ref or RGB Color | ||||
foregroundColor | object | |||||
borderColor | object | |||||
borderTopColor | object | |||||
borderBottomColor | object | |||||
borderRightColor | object | |||||
borderLeftColor | object | |||||
borderDiagonalColor | object | |||||
border | string | Sets the border style by ID or name. possible values: 0 None1 Thin2 Medium3 Dashed4 Dotted5 Thick6 Double7 Hair8 Medium dashed9 Dash dot10 Medium dash dot11 Dash Dot Dot12 Medium dash dot dot13 Slant dash dot | ||||
integer | ||||||
borderTop | string | |||||
integer | ||||||
borderRight | string | |||||
integer | ||||||
borderBottom | string | |||||
integer | ||||||
borderLeft | string | |||||
integer | ||||||
borderDiagonal | string | |||||
integer | ||||||
borderDiagonalMode | string | Puts diagonal strokes in a cell. possible values: none up down both | ||||
fontName | string | Font face name (e.g. 'Helvetica') | ||||
fontSize | integer | Font Size in pt | ||||
fontColor | object | Contains color as Name, Ref or RGB Color | ||||
fontRef | string | Name of a Font Definition | ||||
italic | boolean | Toggle for displaying text as italic. | ||||
bold | boolean | Toggle bold font style | ||||
underline | string | Sets the underline style of the font. possible values: single double acc single acc double | ||||
wrap | boolean | Toggle whether the cell text is wrapped. | ||||
pattern | integer | Background Pattern0 None1 Solid2 50% Gray3 75% Gray4 25% Gray5 Horizontal Stripes6 Vertical Stripes7 Reverse Diagonal Stripes8 Diagonal Stripes9 Diagonal Cross Hatch9 Thick Diagonal Stripe11 Thin Horizontal Stripe12 Thin Vertical Stripe13 Thin Reverse Diagonal Stripe14 Thin Diagonal Stripe15 Thin Horizontal Cross Hatch16 Thin Diagonal Cross Hatch17 Gray 12P518 Gray 6P25 | ||||
string | ||||||
shrinkToFit | boolean | |||||
formatRef | string | Reference to a named format. | ||||
numberFormat | integer | individual format options for numbers, dates, currencies, see www.mbsplugins.eu/XLFormatSetNumFormat</td> </tr> string | numberFormatCustom | string | custom format options for numbers, dates, currencies..., check www.mbsplugins.eu/XLBookAddCustomNumFormat | |