TablesCellStyles

A collection of cell styles.

Instance Properties

Name Description Access
length The number of objects in the collection. Can return: Long Integer or NothingEnum enumerator. read-only

Methods

add(
[withProperties])
 → CellStyle
anyItem(
)
 → CellStyle
count(
)
 → number
everyItem(
)
 → CellStyle
firstItem(
)
 → CellStyle
item(
index)
 → CellStyle
itemByID(
id)
 → CellStyle
itemByName(
name)
 → CellStyle
itemByRange(
from, to)
 → CellStyle
lastItem(
)
 → CellStyle
nextItem(
obj)
 → CellStyle
previousItem(
obj)
 → CellStyle
toSource(
)
 → string
add(
[withProperties])
 → CellStyle
Creates a new CellStyle.
withProperties Object Initial values for properties of the new CellStyle (Optional)
anyItem(
)
 → CellStyle
Returns any CellStyle in the collection.
count(
)
 → number
Displays the number of elements in the CellStyle.
everyItem(
)
 → CellStyle
Returns every CellStyle in the collection.
firstItem(
)
 → CellStyle
Returns the first CellStyle in the collection.
item(
index)
 → CellStyle
Returns the CellStyle with the specified index or name.
index The index or name. Can accept: Long Integer or String.
itemByID(
id)
 → CellStyle
Returns the CellStyle with the specified ID.
id number The ID.
itemByName(
name)
 → CellStyle
Returns the CellStyle with the specified name.
name string The name.
itemByRange(
from, to)
 → CellStyle
Returns the CellStyles within the specified range.
from The CellStyle, index, or name at the beginning of the range. Can accept: CellStyle, Long Integer or String.
to The CellStyle, index, or name at the end of the range. Can accept: CellStyle, Long Integer or String.
lastItem(
)
 → CellStyle
Returns the last CellStyle in the collection.
middleItem(
)
 → CellStyle
Returns the middle CellStyle in the collection.
nextItem(
obj)
 → CellStyle
Returns the CellStyle whose index follows the specified CellStyle in the collection.
obj CellStyle The CellStyle whose index comes before the desired CellStyle.
previousItem(
obj)
 → CellStyle
Returns the CellStyle with the index previous to the specified index.
obj CellStyle The index of the CellStyle that follows the desired CellStyle.
toSource(
)
 → string
Generates a string which, if executed, will return the CellStyle.