Juniper Systems Allegro DOS Manual User Manual

Page 151

Windows CE Page 4-85

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([magnification])
Returns current value of zoom magnification and sets it to magnification
if specified.
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 first 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))

Get current selection coordinates:
col = Col(Sel())
row = Row(Sel())
numCols = Cols(Sel())
numRows = Rows(Sel())

Keyboard Shortcuts
Format Cells

Ctrl+1

Fill Right

Ctrl+R

Select All

Ctrl+A

File Save

Ctrl+S

Copy

Ctrl+C

Paste

Ctrl+V

Fill Down

Ctrl+D

Ctrl+W

Find

Ctrl+F

Cut

Ctrl+X

Goto

Ctrl+G

Redo

Ctrl+Y

Replace

Ctrl+H

Undo

Ctrl+Z

File New

Ctrl+N

Clear Contents Del

File Open

Ctrl+O