CellStyles

All cell styles

Methods:

add, anyItem, count, everyItem, firstItem, item, itemByID, itemByName, itemByRange, lastItem, middleItem, nextItem, previousItem, toSource

Property Listing

Property

Type

Access

Description

length

Long

NothingEnum.NOTHING

readonly

The number of objects in the collection. Can return: Long or NothingEnum enumerator.

Method Listing

CellStyle add (name:String, [basedOn:String=String])

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.

CellStyle everyItem ()

Returns every CellStyle in the collection.

CellStyle firstItem ()

Returns the first CellStyle in the collection.

CellStyle item (index:Varies Long String)

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.

CellStyle itemByRange (from:Varies CellStyle Long String, to:Varies CellStyle Long String)

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.

Object of

Application.cellStyles

Document.cellStyles