Automating task examples, Keyboard shortcuts – Juniper Systems Allegro CE Manual User Manual
Page 199
Windows CE Page 4-139
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
Close
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
- Allegro 2 Quick Start (1 page)
- Allegro 2 User Guide (119 pages)
- I/O module Allegro 2 (1 page)
- A2 Ethernet Dock (2 pages)
- A2 Ethernet Multi Dock (2 pages)
- Allegro MX User Guide (96 pages)
- Allegro MX Quick Start (1 page)
- AMXU GPS Expansion Pod (12 pages)
- Allegro Top Mounting Bracket (4 pages)
- Holux M-215+ for Allegro (2 pages)
- Holux GR-213 for Allegro (2 pages)
- Trimble Lassen GPS Expansion Pod (11 pages)
- Barcode Expansion Pod (22 pages)
- USB/Power Dock Pogo Pin (1 page)
- 12449 Alkaline (1 page)
- Allegro DAQ (28 pages)
- Allegro Desiccant Kit (5 pages)
- Allegro CX and CE Bluetooth CF Card (32 pages)
- Allegro CX Manual (304 pages)
- Allegro CX Quick Start (6 pages)
- Allegro DOS Manual (166 pages)
- Allegro DOS Manual (274 pages)
- Allegro DOS Quick Start (4 pages)
- Allegro DOS Quick Start (2 pages)
- Allegro CE Quick Start (2 pages)
- Archer 2 User Guide (1 page)
- Archer 2 User Guide (133 pages)
- Archer 2 Quick Start (1 page)
- I/O module Archer 2 (1 page)
- Bumper kit Archer 2 (1 page)
- Handstrap kit Archer 2 (1 page)
- ikeGPS (16 pages)
- Archer Quick Start (2 pages)
- Archer Reference Guide (153 pages)
- Archer User Manual (384 pages)
- XF101 (2 pages)
- Travel Charger for the Ultra-Rugged Field PC (8 pages)
- Field PC Cap Replacement (1 page)
- Replacing the Communications Module on the Field PC (2 pages)
- ltra-Rugged Field PC Extended Caps (16 pages)
- Socket Bluetooth Card (6 pages)
- Mesa User Guide (112 pages)
- Mesa Addendum (1 page)
- Mesa Quick Start (2 pages)