Juniper Systems Allegro DOS Manual - Manual (Page 150)

Page 4-84 Windows CE
RowHide([hideUnhide])
Returns whether the first row of current selection is hidden and hides
(true) or unhides (false) selected rows if hideUnhide is specified.
Example: Sel(A2:A5)
RowHide(true)
RunApp(application [,parameters])
Runs and application (program) with optional parameters.
Example: RunApp(“iexplore.exe”, “http://z4soft.com”)
Sel([range])
Returns the current selection and select the new one if range is specified.
Example: Sel(a2:c12)
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)