Juniper-systems Allegro CX Manual Manual de usuario descargar pdf (Pagina 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 [,ﬁ lter])

Opens a ﬁ le dialog box with the title and the ﬁ le type ﬁ lter.

Example:

picture=FileBox(“Pictures”, *.jpg,*.gif,*.bmp,*.2bp,*.xbm”)

ShowPicture(picture)

Filter(onOff)

Sets auto ﬁ lter (true = autoﬁ lter on, false = autoﬁ lter off). Auto ﬁ lter

range is the current selection.

Example:

Filter(true)

1 2 ... 169 170 171 172 173 174 175 176 177 178 179 ... 303 304

Sin comentarios

Juniper-systems Allegro CX Manual Manual de usuario Pagina 174