Juniper Systems Allegro DOS Manual - Manual (Page 130)

Page 4-64 Windows CE
- Boolean: True or false
- Formula: Formulas begin with an equal sign (=). PTab evaluates the
value. (Example: =A5+2, =Sum(B2:C7)). Formulas can contain:
Number, text, date/time, Boolean values
Cell references (examples: A4, $B7, $C$3,
Sheet1!A3,’2ndSheet’!$C$7)
Cell ranges (examples: A1:B4, 'Year 1999'!C5:D7)
Arithmetic operations: +, -, /, *, %, ^ (examples: A1*B5%, C7*100-5)
Comparative operators: =, <, <>, >, <=, >= (example: if(A1>B1, A1,
B1))
Text joining operators: & (example: A1 & "years")
Functions
▲ ▲ ▲ ▲ ▲ PTab Menu Options
The PTab pull-down menu options include: File, Edit, Insert, Format,
Tools, and Task. Each menu option is described in detail on the
following pages. On-line help is accessed by pressing the [?] in the
upper right- hand corner of the screen.
File Menu Options
The following functions are available from the File Menu option:
- File|New: Creates a new workbook.
- File|Open: Opens an existing workbook. You can open a PTab file (.pt),
a Microsoft Pocket Excel file (.pxl) or a CSV file (.csv). Microsoft Excel
files (.xls) are converted to PTab files during the desktop PC to Allegro
file transfer. CSV files are ASCII text files containing values separated
by a separator taken from the Allegro’s regional settings. Select
Start|Settings|Control Panel|Regional Settings, then choose the Number
tab and the List separators combo box. To open a CSV file select Text
Files (*.csv) from the Type combo box.
- File|Save: Saves the current workbook. If you have not previously
saved the workbook, Save works the same as Save As.
- File|Save As: Saves the current workbook with a specified name.
- File|Delete: Deletes the specified file.
- File|Recent Files: Displays a list of recently opened files.
- File|Password: Sets or changes the password.
- File|Close: Closes the current workbook.