Juniper Systems Allegro CX Manual - Manual (Page 180)

180 Allegro CX Owner’s Manual
TopLeftCell(reference)
Returns the top left cell on the screen and sets it if reference is
specifi ed.
Example:
TopLeftCell(A1)
WorkbookName()
Returns name of the opened workbook.
Example:
Save(WorkbookName())
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([magnifi cation])
Returns current value of zoom magnifi cation and sets it to
magnifi cation if specifi ed.
Example:
Zoom(65)
Zoom(Zoom()-10)
Automating Task Examples
Selecting cells from a2 to the last cell
Sel(RangeRef(1, 2, LastCol(), LastRow())
Selecting column by tapping the cell in the fi rst row (onTap:
$A$1:$A$255)
curCol = Column(ActiveCell())
Sel(RangeRef(curCol, 1, curCol, LastRow())
Entering a product name to the tapped cell in column B from
product table in Sheet2 (onTap:$B$1:$B$16384)
choice = ListBox(“Select a product”, Sheet2!a1:a16384)
Set(ActiveCell(), CellRef(1, choice, 2))