Juniper-systems Allegro CX Manual Manual do Utilizador descarregar pdf (Página 179)

Allegro CX Owner’s Manual 179

Set(reference, value)

Sets cell speciﬁ ed by reference to the value.

Example:

Set(a1, 12.34)

SheetName(sheetNum)

Returns name of the speciﬁ ed sheet.

Example:

name = SheetName(1)

SheetsCount()

Returns a number of sheets in workbook.

Example:

MsgBox(“Sheets count is “&SheetsCount())

ShowPicture(pictureFile [,Time])

Shows a picture (ﬁ le of types: *.jpg, *.gif, *.bmp, *.2bp, *.xbm). Use

the second (optional) parameter to close a picture window after time

seconds. Without specifying the time parameter a picture can be

closed by tapping on it.

Example:

ShowPicture(“car.bmp”)

Sort(ﬁ rstBy[, ascending, secondBy, ascending, thirdBy,

ascending, headerRow, caseSensitive, sortRows] )

Sorts the current selection. FirstBy, secondBy, thirdBy - column

numbers (or row numbers if sortRows is true). Sorts ascending

(ascending = true) or descending (ascending = false). For more info see

Sort dialog in Tools menu.

Example:

Sel(a1:c20)

Sort(1)

TickCount()

Returns the number of seconds that have elapsed since the system

was started. This function has microsecond precision.

Example:

tm = TickCount()

1 2 ... 174 175 176 177 178 179 180 181 182 183 184 ... 303 304

Sem comentários

Juniper-systems Allegro CX Manual Manual do Utilizador Página 179