OPLDatabaseFile
General
File Menu
Sheet Menu
Help: Sheet
Help: General
Help: Cells Menu
Cells Menu
Number Format
Text Style
Help: Sheet Menu
Freeze Rows/Cols
1065	
Goto End
Goto Cell
Insert Rows/Cols
Delete Rows/Cols
Help: Number Format0
0224*
Select range or cell to format and choose$
   Number Format from the menu
Level:
Text:*
0424$
To show numbers in date format, the(
0524"   number must be in ddmmyyyy form#
Text fields are not affected
   E.g. 31011992
Help: Text Style0
0234*
Select range or cell to format and choose.
0334(   Text Style from the menu. To select a1
0534+   line. Styles already selected are tagged%
Number fields are not affected-
0434'   style press Enter on the appropriate/
0634)   Pressing Enter toggles style selection.
0244(
Select range or cell to copy and choose/
0344)   Copy from the menu. If copying a range3
0444-   of cells, move to the top left cell of the-
0544'   range to copy to and press Enter. If0
0644*   copying a single cell, select the range,
0744&   of cells to copy to and press Enter
Help: Copy I-
0254'
Cell references in formulae are offset%
Esc cancels the copy operation
Help: Copy II & Erase,
0554&
Select the range or cell to erase and#
   choose Erase from the menu
Copy I
Copy II & Erase,
0322&   Control+arrows page a whole screen.,
0222&
Navigate screen using the arrow keys.
1022	
Basics I
Selecting
Operators & Functions
Other
Basics II
Help: Other
See System Help for 
   information on Editing, 
   Dialogs, File selection#
   and other basic operations!
Help: Operators & Functions-
0252'
Operators: + - * / ** AND OR NOT % < >,
0352&
Functions: SIN COS TAN ASIN ACOS ATAN
   EXP LN LOG SQR
Constants: PI RND0
0652*
Conversion: RAD DEG ABS IABS INT INTF FLT/
0752)
List Functions: MAX MIN MEAN SUM STD VAR
Help: Selecting#
Move cell to corner of range#
   to be selected and press .'
0442!   (period), then use arrow keys,&
0542    Goto or Goto End menu options#
   to highlight desired range
Press Esc to deselect
Help: Basics I1
0432+   e.g.  'Sheet,  +sum(a1..d5)*c2-7,  3.945
Help: Basics II,
0232&
Press ' enter labels, + for formulae, 
   0 to 9 or - for numbers-
0532'
Press Enter to edit existing cell data(
0422"   Home, End and the menu commands.
0522(   Goto and Goto End move larger amounts
Help: Goto Cell%
Goto cell will move the cursor
   to the specified cell
   e.g. h18 or B3"
Can be used while selecting
   a range
Help: Insert Rows/Cols'
0235!
Enter a letter to insert columns#
   or a number to insert rows(
0435"
The number of rows/cols specified$
   will be inserted before the
   indicated row/col
Help: Delete Rows/Cols'
0245!
Enter a letter to delete columns#
   or a number to delete rows*
0445$
The data in the specified rows/cols
   will be erased
Help: Freeze Rows/Cols'
0255!
Enter a letter to freeze columns#
   or a number to freeze rows&
0455 
The specified rows/cols will be+
0555%   fixed to the top/left of the sheet(
0655"
To unfreeze rows/cols - specify 0.
0755(   for the number of rows/cols to freeze
Help: Goto End+
0265%
Selecting the last row/col will move*
0365$   the cursor to the last row/col in
   the current row/col,
0565&
Selecting the last cell will move the,
0665&   cursor to the last row, then column.
0765(   in the case of an elbow shapped sheet#
New - Close current file and
New, Open & Save as
Export to DIF
Import from DIF
Help: Export to DIF
A DIF file'
0333!   can be read by most popular PC+
0433%   Spreadsheets and Databases, either,
0533&   directly or via a translate program*
0633$
Formulae can be exported as text or/
0733)   the resulting value. See documentation
Help: Import from DIF
A DIF file,
0343&   can be imported into Sheet and then-
0443'   modified using Search and Replace to-
0543'   convert text into labels or formulae+
0643%
It is advisable to recalculate after
   importing a DIF file
Special Menu
Help: Special Menu
Recalculate
1037	
Load App
1047	
Compress
About
Help: Recalculate1
0227+
It should be necessary to recalculate only/
0327)   when changing cells affecting formulae.
0427(
Changing formulae, copying or inserting)
0527#   should not require recalculation-
0627'
Calculating is recursive and therefore+
0727%   necessary only once after a change
Help: Load App,
0237&
External applications compatible with.
0337(   Sheet can be loaded with the Load App
   menu option,
0537&
The assigned hot key will display the"
   menu for that application0
0737*
Upto 4 applications can be loaded at once
Help: Compress)
0247#
If short on disk space (see About),
0347&   and after a lot of entry, deleting,)
0447#   copying or erasing, use compress)
0547#   to minimize the size of the file(
0647"
Compressing is automatically done 
   on Exit and Recalculate
Help: About(
0257"
About displays the amount of free"
   space on the current disk)
0457#
If an Out of Memory error occurs, )
0557#   no data is lost but the sheet is(
0657"   exited without being compressed
Help: Exit.
0267(
Exit will compress and save the current.
0367(   sheet and return to the System screen)
0467#
If the Delete key is used from the*
0567$   System screen to exit the program.
0667(   the file will be compressed and saved
   in the background
   work with a new sheet$
Open - Close current file and$
   work with an existing sheet$
Save as - Saves a copy of the'
0723!   current sheet under a new name
Help: File Menu
Help: New, Open & Save as
Help: Search Menu
Fine Again
Replace I
Replace II
Help: Find)
0226#
The text to search for can be upto
Help: Find Again%
Find Again will search for the%
   next occurance of the search%
   text, wrapping around to the!
   begining of the sheet if
   necessary
Help: Replace I)
0246#
The text to replace can be upto 32,
0346&   characters long, and include spaces/
0326)   32 characters long, and include spaces*
0426$
The search begins at the cell after-
0526'   the current one and will wrap around/
0626)   to end on the current cell if the text
   is not found+
0446%
If the search text is found a window,
0546&   is displayed highlighting the found 
   text in the cell string
Help: Replace II)
0256#
Options to End the search, Replace*
0356$   the text and continue the search,'
0456!   Skip the current occurance and+
0556%   continue the search or replace All,
0656&   occurances of the text in the sheet
   are given
Search Menu+
0233%
A DIF (Data Interchange Format) file+
0243%
A DIF (Data Interchange Format) file