Juniper-systems Allegro DOS Manual Manual do Utilizador descarregar pdf (Página 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)

1 2 ... 145 146 147 148 149 150 151 152 153 154 155 ... 273 274

Sem comentários

Juniper-systems Allegro DOS Manual Manual do Utilizador Página 150