Juniper Systems Allegro CE Manual - Manual (Page 198)

Page 4-138 Windows CE
Set(reference, value)
Sets cell specified by reference to the value.
Example: Set(a1, 12.34)
SheetName(sheetNum)
Returns name of the specified 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 (file 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(firstBy[, 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)
TopLeftCell(reference)
Returns the top left cell on the screen and sets it if reference is
specified.
Example: TopLeftCell(A1)
YesNoBox(text)
Shows the box giving the choice yes or no and returns true if user
selects Yes.
Example: if YesNoBox("Stop") then
Return()
end
Zoom([magnification])
Returns current value of zoom magnification and sets it to
magnification if specified.
Example: Zoom(65)
Zoom(Zoom()-10)