Juniper Systems Allegro CX Manual - Manual (Page 179)

Allegro CX Owner’s Manual 179
Set(reference, value)
Sets cell specifi ed by reference to the value.
Example:
Set(a1, 12.34)
SheetName(sheetNum)
Returns name of the specifi 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 (fi 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(fi 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()