Juniper Systems Allegro CX Manual - Manual (Page 174)

174 Allegro CX Owner’s Manual
ComboBox(“list”)
Creates combo box in the current cell. See also Tools | Data Validation
menu item for more info. Use function ClearValidation() to clear
combo boxes in the current selection. Use Run on “New value in”
workbook task event to run a task every time value in a cell is
changed.
Example:
Sel(A1)
ComboBox(“BMW,Jaguar,Volvo”)
Copy()
Copies the current selection to the clipboard.
Example:
Sel(A1:A5)
Copy()
Sel(B1)
Paste()
DeleteCells(colsRows)
Deletes cells (true - columns, false - rows).
Example:
DeleteCells(true)
DeleteSheet(worksheet)
Removes worksheet.
Example:
DeleteSheet(“Sheet2”)
FileBox(title [,fi lter])
Opens a fi le dialog box with the title and the fi le type fi lter.
Example:
picture=FileBox(“Pictures”, *.jpg,*.gif,*.bmp,*.2bp,*.xbm”)
ShowPicture(picture)
Filter(onOff)
Sets auto fi lter (true = autofi lter on, false = autofi lter off). Auto fi lter
range is the current selection.
Example:
Filter(true)