CellStyles
QuickLinks
Properties
| Property | Type | Access | Description |
|---|---|---|---|
| length | Long NothingEnum |
readonly | The number of objects in the collection. Can return: Long or NothingEnum enumerator. |
Methods
Instances
CellStyle add (name:
string[, basedOn:
string=[None]])
Create and return a new cell style
| Parameter | Type | Description |
|---|---|---|
| name | string | The cell style name |
| basedOn | string | The cell style to copy from (Optional) (default: [None]) |
CellStyle anyItem ()
Returns any CellStyle in the collection.
number count ()
Displays the number of elements in the CellStyle.
Array
of CellStyle everyItem ()
Returns every CellStyle in the collection.
CellStyle firstItem ()
Returns the first CellStyle in the collection.
CellStyle item (index:
any)
Returns the CellStyle with the specified index or name.
| Parameter | Type | Description |
|---|---|---|
| index | Long String | The index or name. Can accept: Long or String. |
CellStyle itemByID (id:
number)
Returns the CellStyle with the specified ID.
| Parameter | Type | Description |
|---|---|---|
| id | number | The ID. |
CellStyle itemByName (name:
string)
Returns the CellStyle with the specified name.
| Parameter | Type | Description |
|---|---|---|
| name | string | The name. |
Array
of CellStyle itemByRange (from:
any, to:
any)
Returns the CellStyles within the specified range.
| Parameter | Type | Description |
|---|---|---|
| from | CellStyle Long String | The CellStyle, index, or name at the beginning of the range. Can accept: CellStyle, Long or String. |
| to | CellStyle Long String | The CellStyle, index, or name at the end of the range. Can accept: CellStyle, Long or String. |
CellStyle lastItem ()
Returns the last CellStyle in the collection.
CellStyle middleItem ()
Returns the middle CellStyle in the collection.
CellStyle nextItem (obj:
CellStyle)
Returns the CellStyle whose index follows the specified CellStyle in the collection.
| Parameter | Type | Description |
|---|---|---|
| obj | CellStyle | The CellStyle whose index comes before the desired CellStyle. |
CellStyle previousItem (obj:
CellStyle)
Returns the CellStyle with the index previous to the specified index.
| Parameter | Type | Description |
|---|---|---|
| obj | CellStyle | The index of the CellStyle that follows the desired CellStyle. |
string toSource ()
Generates a string which, if executed, will return the CellStyle.
Element of
Application.cellStyles
Document.cellStyles
| Jongware, 27-Jun-2010 v3.0.3d | Contents :: Index |