Class
A cell style applycellstyle, applycellstyletocells, duplicate, extractLabel, getElements, insertLabel, remove, toSource, toSpecifier
CellStyle
QuickLinks
Hierarchy
Properties
| Property | Type | Access | Description |
|---|---|---|---|
| bottomEdgeStrokeColor | NothingEnumSwatch | r/w | The swatch (color, gradient, tint, or mixed ink) applied to the bottom edge border stroke. Can return: Swatch or NothingEnum enumerator. |
| bottomEdgeStrokeGapColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the gap of the bottom edge border stroke. Note: Not valid when bottom edge stroke type is solid. Can return: Swatch or NothingEnum enumerator. |
| bottomEdgeStrokeGapOverprint | Boolean NothingEnum |
r/w | If true, the gap color of the bottom edge border stroke will overprint. Note: Not valid when bottom edge stroke type is solid. Can return: Boolean or NothingEnum enumerator. |
| bottomEdgeStrokeGapTint | NothingEnum Real |
r/w | The tint (as a percentage) of the bottom edge border stroke gap color. (Range: 0 to 100) Note: Not valid when bottom edge stroke type is solid. Can return: Real or NothingEnum enumerator. |
| bottomEdgeStrokeOverprint | Boolean NothingEnum |
r/w | If true, the bottom edge border stroke will overprint. Can return: Boolean or NothingEnum enumerator. |
| bottomEdgeStrokePriority | Long NothingEnum |
r/w | The order in which to draw the bottom edge border stroke. Note: The value must be 1, 2, 3, or 4, with 1 indicating that the stroke is the first stroke drawn, and therefore overlapped by strokes with higher priority. Can return: Long or NothingEnum enumerator. |
| bottomEdgeStrokeTint | NothingEnum Real |
r/w | The tint (as a percentage) of the bottom edge border stroke. Can return: Real or NothingEnum enumerator. |
| bottomEdgeStrokeType | NothingEnum StrokeStyle |
r/w | The stroke type of the bottom edge. Can return: StrokeStyle or NothingEnum enumerator. |
| bottomEdgeStrokeWeight | NothingEnum Unit |
r/w | The stroke weight of the bottom edge border stroke. Can return: Unit or NothingEnum enumerator. |
| bottomInset | NothingEnum Unit |
r/w | The bottom inset of the cell. Can return: Unit or NothingEnum enumerator. |
| clipContentToCell | Boolean NothingEnum |
r/w | If true, clips the cell's content to width and height of the cell. Can return: Boolean or NothingEnum enumerator. |
| diagonalLineInFront | Boolean NothingEnum |
r/w | If true, draws the diagonal line in front of cell contents. Can return: Boolean or NothingEnum enumerator. |
| diagonalLineStrokeColor | NothingEnum Swatch |
r/w | The diagonal line color, specified as a swatch. Can return: Swatch or NothingEnum enumerator. |
| diagonalLineStrokeGapColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the gap of the diagonal line stroke. Note: Not valid when diagonal line stroke type is solid. Can return: Swatch or NothingEnum enumerator. |
| diagonalLineStrokeGapOverprint | Boolean NothingEnum |
r/w | If true, the stroke gap of the diagonal line will overprint. Note: Not valid when diagonal line stroke type is solid. Can return: Boolean or NothingEnum enumerator. |
| diagonalLineStrokeGapTint | NothingEnum Real |
r/w | The tint (as a percentage) of the diagonal line stroke gap color. Note: Not valid when diagonal line stroke type is solid. Can return: Real or NothingEnum enumerator. |
| diagonalLineStrokeOverprint | Boolean NothingEnum |
r/w | If true, the diagonal line stroke will overprint. Can return: Boolean or NothingEnum enumerator. |
| diagonalLineStrokeTint | NothingEnum Real |
r/w | The diagonal line tint (as a percentage). (Range: 0 to 100). Can return: Real or NothingEnum enumerator. |
| diagonalLineStrokeType | NothingEnum StrokeStyle |
r/w | The diagonal line stroke type. Can return: StrokeStyle or NothingEnum enumerator. |
| diagonalLineStrokeWeight | NothingEnum Unit |
r/w | The diagonal line stroke weight. Can return: Unit or NothingEnum enumerator. |
| fillColor | NothingEnum String Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the fill of the object. Can return: Swatch or NothingEnum enumerator. Can also accept: String. |
| fillTint | NothingEnum Real |
r/w | The tint (as a percentage) of the fill of the object. Can return: Real or NothingEnum enumerator. |
| firstBaselineOffset | FirstBaseline NothingEnum |
r/w | The distance between the baseline of the text and the top inset of the cell. Can return: FirstBaseline enumerator or NothingEnum enumerator. |
| gradientFillAngle | NothingEnum Real |
r/w | The angle of a linear gradient applied to the fill of the object. (Range: -180 to 180). Can return: Real or NothingEnum enumerator. |
| gradientFillLength | NothingEnum Real |
r/w | The length (of a linear gradient) or radius (of a radial gradient) applied to the fill of the object. Can return: Real or NothingEnum enumerator. |
| gradientFillStart | 2 Units NothingEnum |
r/w | The starting point (in page coordinates) of a gradient applied to the fill of the object, in the format [x, y]. Can return: Array of 2 Units or NothingEnum enumerator. |
| id | Long NothingEnum |
readonly | The unique ID of the CellStyle. Can return: Long or NothingEnum enumerator. |
| index | Long NothingEnum |
readonly | The index of the CellStyle within its containing object. Can return: Long or NothingEnum enumerator. |
| label | NothingEnum String |
r/w | A property that can be set to any string. Can return: String or NothingEnum enumerator. |
| leftEdgeStrokeColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the left edge border stroke. Can return: Swatch or NothingEnum enumerator. |
| leftEdgeStrokeGapColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the gap of the left edge border stroke. Note: Not valid when left edge stroke type is solid. Can return: Swatch or NothingEnum enumerator. |
| leftEdgeStrokeGapOverprint | Boolean NothingEnum |
r/w | If true, the gap color of the left edge border stroke will overprint. Note: Not valid when left edge stroke type is solid. Can return: Boolean or NothingEnum enumerator. |
| leftEdgeStrokeGapTint | NothingEnum Real |
r/w | The tint (as a percentage) of the left edge border stroke gap color. (Range: 0 to 100) Note: Not valid when left edge stroke type is solid. Can return: Real or NothingEnum enumerator. |
| leftEdgeStrokeOverprint | Boolean NothingEnum |
r/w | If true, the left edge border stroke will overprint. Can return: Boolean or NothingEnum enumerator. |
| leftEdgeStrokePriority | Long NothingEnum |
r/w | The order in which to draw the left edge border stroke. Note: The value must be 1, 2, 3, or 4, with 1 indicating that the stroke is the first stroke drawn, and therefore overlapped by strokes with higher priority. Can return: Long or NothingEnum enumerator. |
| leftEdgeStrokeTint | NothingEnum Real |
r/w | The tint (as a percentage) of the left edge border stroke. (Range: 0 to 100). Can return: Real or NothingEnum enumerator. |
| leftEdgeStrokeType | NothingEnum StrokeStyle |
r/w | The stroke type of the left edge border stroke. Can return: StrokeStyle or NothingEnum enumerator. |
| leftEdgeStrokeWeight | NothingEnum Unit |
r/w | The stroke weight of the left edge border stroke. Can return: Unit or NothingEnum enumerator. |
| leftInset | NothingEnum Unit |
r/w | The left inset of the cell. Can return: Unit or NothingEnum enumerator. |
| minimumFirstBaselineOffset | NothingEnum Unit (0 - 8640 points) |
r/w | The space between the baseline of the text and the top inset of the frame or cell. Can return: Unit (0 - 8640 points) or NothingEnum enumerator. |
| name | NothingEnum String |
r/w | The name of the CellStyle. Can return: String or NothingEnum enumerator. |
| overprintFill | Boolean NothingEnum |
r/w | If true, the fill of the object will overprint. Can return: Boolean or NothingEnum enumerator. |
| paraStyle | NothingEnum ParagraphStyle String |
r/w | The paragraph style associated with this cell style. Can return: ParagraphStyle or NothingEnum enumerator. Can also accept: String. |
| paragraphSpacingLimit | NothingEnum Unit |
r/w | The maximum space that can be added between paragraphs in a cell. Note: Valid only when vertical justification is justified. Can return: Unit or NothingEnum enumerator. |
| parent | Application Document |
readonly | The parent of the CellStyle (a Application or Document). |
| properties | Object | r/w | A property that allows setting of several properties at the same time. |
| rightEdgeStrokeColor | NothingEnum Swatch |
r/w | The color, specified as a swatch, of the right edge border stroke. Can return: Swatch or NothingEnum enumerator. |
| rightEdgeStrokeGapColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the gap of the right edge border stroke. Note: Not valid when right edge stroke type is solid. Can return: Swatch or NothingEnum enumerator. |
| rightEdgeStrokeGapOverprint | Boolean NothingEnum |
r/w | If true, the gap color of the right edge border stroke will overprint. Note: Not valid when right edge stroke type is solid. Can return: Boolean or NothingEnum enumerator. |
| rightEdgeStrokeGapTint | NothingEnum Real |
r/w | The tint (as a percentage) of the right edge border stroke gap color. (Range: 0 to 100) Note: Not valid when right edge stroke type is solid. Can return: Real or NothingEnum enumerator. |
| rightEdgeStrokeOverprint | Boolean NothingEnum |
r/w | If true, the right edge border stroke will overprint. Can return: Boolean or NothingEnum enumerator. |
| rightEdgeStrokePriority | Long NothingEnum |
r/w | The order in which to draw the right edge border stroke. Note: The value must be 1, 2, 3, or 4, with 1 indicating that the stroke is the first stroke drawn, and therefore overlapped by strokes with higher priority. Can return: Long or NothingEnum enumerator. |
| rightEdgeStrokeTint | NothingEnum Real |
r/w | The tint (as a percentage) of the right edge border stroke. (Range: 0 to 100). Can return: Real or NothingEnum enumerator. |
| rightEdgeStrokeType | NothingEnum StrokeStyle |
r/w | The stroke type of the right edge border stroke. Can return: StrokeStyle or NothingEnum enumerator. |
| rightEdgeStrokeWeight | NothingEnum Unit |
r/w | The stroke weight of the right edge border stroke. Can return: Unit or NothingEnum enumerator. |
| rightInset | NothingEnum Unit |
r/w | The right inset of the cell. Can return: Unit or NothingEnum enumerator. |
| rotationAngle | NothingEnum Real |
r/w | The rotation angle (in degrees) of the cell, specified as one of the following values: 0, 90, 180, or 270. Can return: Real or NothingEnum enumerator. |
| topEdgeStrokeColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the top edge border stroke. Can return: Swatch or NothingEnum enumerator. |
| topEdgeStrokeGapColor | NothingEnum Swatch |
r/w | The swatch (color, gradient, tint, or mixed ink) applied to the gap of the top edge border stroke. Note: Not valid when top edge stroke type is solid. Can return: Swatch or NothingEnum enumerator. |
| topEdgeStrokeGapOverprint | Boolean NothingEnum |
r/w | If true, the gap color of the top edge border stroke will overprint. Note: Not valid when top edge stroke type is solid. . Can return: Boolean or NothingEnum enumerator. |
| topEdgeStrokeGapTint | NothingEnum Real |
r/w | The tint (as a percentage) of the top edge border stroke gap color. (Range: 0 to 100) Note: Not valid when top edge stroke type is solid. Can return: Real or NothingEnum enumerator. |
| topEdgeStrokeOverprint | Boolean NothingEnum |
r/w | If true, the top edge border stroke will overprint. Can return: Boolean or NothingEnum enumerator. |
| topEdgeStrokePriority | Long NothingEnum |
r/w | The order in which to draw the top edge border stroke. Note: The value must be 1, 2, 3, or 4, with 1 indicating that the stroke is the first stroke drawn. Can return: Long or NothingEnum enumerator. |
| topEdgeStrokeTint | NothingEnum Real |
r/w | The tint (as a percentage) of the top edge border stroke. (Range: 0 to 100). Can return: Real or NothingEnum enumerator. |
| topEdgeStrokeType | NothingEnum StrokeStyle |
r/w | The stroke type of the top edge border stroke. Can return: StrokeStyle or NothingEnum enumerator. |
| topEdgeStrokeWeight | NothingEnum Unit |
r/w | The stroke weight of the top edge border stroke. Can return: Unit or NothingEnum enumerator. |
| topInset | NothingEnum Unit |
r/w | The top inset of the cell. Can return: Unit or NothingEnum enumerator. |
| topLeftDiagonalLine | Boolean NothingEnum |
r/w | If true, draws a diagonal line starting from the top left. Can return: Boolean or NothingEnum enumerator. |
| topRightDiagonalLine | Boolean NothingEnum |
r/w | If true, draws a diagonal line starting from the top right. Can return: Boolean or NothingEnum enumerator. |
| verticalJustification | NothingEnum VerticalJustification |
r/w | The vertical alignment of cell. Can return: VerticalJustification enumerator or NothingEnum enumerator. |
Methods
Instances
void applycellstyle ([removeOverrides:
bool=false])
Used to apply a cell style to the selected cells
| Parameter | Type | Description |
|---|---|---|
| removeOverrides | bool | True to remove overrides, false to keep them (Optional) (default: false) |
void applycellstyletocells (to:
Array
of any[, removeOverrides:
bool=false])
Used to apply a cell style to the specified cells
| Parameter | Type | Description |
|---|---|---|
| to |
Array
of : Array of Cells Columns Rows Tables | The cells to apply the style to. Can accept: Array of Cells, Columns, Rows or Tables. |
| removeOverrides | bool | True to remove overrides, false to keep them (Optional) (default: false) |
CellStyle duplicate ()
Used to copy a cell style
string extractLabel (key:
string)
Gets the label value associated with the specified key.
| Parameter | Type | Description |
|---|---|---|
| key | string | The key. |
Array
of Object getElements ()
Resolves the object specifier, creating an array of object references.
void insertLabel (key:
string, value:
string)
Sets the label to the value associated with the specified key.
| Parameter | Type | Description |
|---|---|---|
| key | string | The key. |
| value | string | The value. |
void remove ([replacingWith:
string=[None]])
Delete the cell style object
| Parameter | Type | Description |
|---|---|---|
| replacingWith | string | The cell style to replace the style with (Optional) (default: [None]) |
string toSource ()
Generates a string which, if executed, will return the CellStyle.
Element of
Cell.appliedCellStyle
Used in:
array of CellStyle CellStyles.itemByRange (from: any, to: any)
CellStyle CellStyles.nextItem (obj: CellStyle)
CellStyle CellStyles.previousItem (obj: CellStyle)
Return
CellStyle CellStyle.duplicate ()
CellStyle CellStyles.add (name: string[, basedOn: string=[None]])
CellStyle CellStyles.anyItem ()
Array of CellStyle CellStyles.everyItem ()
CellStyle CellStyles.firstItem ()
CellStyle CellStyles.item (index: any)
CellStyle CellStyles.itemByID (id: number)
CellStyle CellStyles.itemByName (name: string)
Array of CellStyle CellStyles.itemByRange (from: any, to: any)
CellStyle CellStyles.lastItem ()
CellStyle CellStyles.middleItem ()
CellStyle CellStyles.nextItem (obj: CellStyle)
CellStyle CellStyles.previousItem (obj: CellStyle)
| Jongware, 27-Jun-2010 v3.0.3d | Contents :: Index |