@database FinalCalc.hyper
@font topaz.font 8                                                                                                              

@remark Warning!  Do not edit this file!

@index Main

@$VER: FinalCalc.part3.guide 1.04 (14 February 1996)
@author "Khalid Aldoseri"
@(c) "Copyright © 1995-1996 Khalid Aldoseri"

@node Main "Using FinalCalc..."
@toc "FinalCalc:guide/main.guide/Main"
@{b}@{u}
	Using FinalCalc:
@{uu}@{fg highlight}
	@{" > " link part2.1} Projects
	@{" > " link part2.2} The Sheet
	@{" > " link part2.3} Views
	@{" > " link part2.4} Entering and editing cell data
	@{" > " link part2.5} Cell Format
	@{" > " link part2.6} Cell Editing Tools
	@{" > " link part2.7} Lines and Borders
	@{" > " link part2.8} Undo/Redo System
	@{" > " link part2.9} The Filing System
	@{" > " link part2.10} The Help System
	@{" > " link part2.11} Requesters
@endnode

@node part2.1 "Projects..."
@toc "Main"
@{b}@{u}Projects:@{ub}@{uu}

A FinalCalc Project is a collection of sheets, print jobs, graphs, and
animations that describe an entire 'user project'.  A project is normally
stored on disk as a single file.

@{b}@{u}@{fg highlight}Starting a new project:@{ub}@{uu}@{fg text}
When FinalCalc first starts, it automatically shows a fresh project that
contains a single sheet.  You can immediately start entering data into that
project.

To start another project, use the 'Project - New' menu.  A new project will
be started and made the currently active project.

FinalCalc can have multiple projects open at the same time.  Each can have
its own views, so you can work on more than one project.  To jump between
projects, use the 'Project - Projects List' menu (or the 'Project' icon).
This will bring up a list of active projects, and you can select one to move to.

@{b}@{u}@{fg highlight}Loading an existing project:@{ub}@{uu}@{fg text}
To load a previously saved project from disk.  Use the 'Project - Load' menu.
A file requester will come up asking you to select the file to load.  If you
select a valid project file, the current project will be shut down, and the
selected project will be loaded.

If you need to load a project from disk without replacing the current project,
use the 'Project - Open' menu.  This will start a new project and load the
selected project into it.  However, if the current project is totally empty
(fresh, no cells, no changes, and named "Untitled"), that project is closed
and a new one is loaded in its place.

@{b}@{u}@{fg highlight}Saving a project:@{ub}@{uu}@{fg text}
To save a project to disk for the first time, use the 'Project - Save As' menu.
A file requester will come up asking you to select where to save the project
and what to name it.

Once you have saved a project, or if it was a loaded project, you can use the
'Project - Save' menu.  This immediately saves the current project in the same
file name it was last saved as, or was loaded from.

@{b}@{u}@{fg highlight}Closing a project:@{ub}@{uu}@{fg text}
To close a project, use the 'Project - Quit' menu, or simply close all its
views.  If the project was changed since it was last saved, FinalCalc will
warn you, telling you what has changed in the project, and ask you if you are
sure you want to quit.

@{b}@{u}@{fg highlight}The Project List:@{ub}@{uu}@{fg text}
The Project List shows all the projects currently active in FinalCalc.  To
view it, use the 'Project - Project - Project List' menu.  This will bring up
a list of the active projects, and you can select one of them to go to.
@endnode

@node part2.2 "Sheets..."
@toc "Main"
@{b}@{u}
	The Sheet:
@{uu}@{fg highlight}
	@{" > " link part2.2.1 } Identifying Sheets, Columns, Rows and Cells
	@{" > " link part2.2.2 } The Cell
	@{" > " link part2.2.3 } The Cell Format
	@{" > " link part2.2.4 } The Range
	@{" > " link part2.2.5 } Moving Around a project: The Cursor
	@{" > " link part2.2.6 } Selecting a range
	@{" > " link part2.2.7 } Handling multiple sheets in a project
	@{" > " link part2.2.8 } Column Widths
	@{" > " link part2.2.9 } Hiding Columns
	@{" > " link part2.2.10} Column Titles
	@{" > " link part2.2.11} Default Column Widths
	@{" > " link part2.2.12} Row Heights
@endnode

@node part2.2.1 "Sheets, Columns, Rows and Cells..."
@toc "part2.2"
@{b}@{u}Sheets, Columns, Rows and Cells:@{ub}@{uu}

The basic object in a FinalCalc Project is the @{fg highlight}@{b}spreadsheet@{fg text}@{ub} (or sheet).  The
sheet is used to store data in a project in the form of numbers and text.  Each
data object stored in a sheet gets stored in an area called a @{fg highlight}@{b}cell@{fg text}@{ub}.  A cell
can contain many different types of objects, or can even be empty.

A sheet is made up of many cells, arranged in a two-dimensional table format,
made up of columns and rows.

A @{fg highlight}@{b}column@{fg text}@{ub} is a vertical line of cells in a sheet.  The first column in a sheet
is named column A, the second one column B, and so on until column ZZZ.

A @{fg highlight}@{b}row@{fg text}@{ub} is a horizontal line of cells in a sheet.  The first row in a sheet is
row 1, the second one is row 2, and the last one is row 65000.

A project contains a minimum of one sheet, and up to a maximum of 254 sheets.
The first sheet in a project is named sheet 'A'.  Sheets after that are named
B, C, D, ..., Z, AA, AB, AC, and so on until sheet number 254, named 'IT'.

A sheet contains 65000 rows, numbered from row 1 to row 65000, and contains
18277 columns, named from column A to column ZZZ.

A cell is basically the intersection of a column and a row.  The first cell
in the sheet is named A1, i.e. the cell at column A, row 1.  Cell names range
from A1 to ZZZ65000, allowing a maximum of 1.18 billion cells per sheet, and
301 billion cells per project.

For example:

     A1       the cell on column A, row 1 in the current sheet
     D12      the cell on column D, row 12 in the current sheet
     B_C10    the cell on column C, row 10 in sheet B

If you need to reference a cell from another sheet in the current project, you
should use its 3-dimensional name, e.g. A_A1, (sheet name, '_' character,
column and row) as shown in the example above.
@endnode


@node part2.2.2 "The Cell..."
@toc "part2.2"
@{b}@{u}The Cell:@{ub}@{uu}

A cell is shown as a simple box in the display.  That box is the intersection
of a column and a row in a sheet.

A cell can be in one of many states:

@{fg highlight}@{b}Clear:@{fg text}@{ub}
The cell is empty and has no contents.  It shows up as blank on the display.

@{fg highlight}@{b}Numeric:@{fg text}@{ub}
The cell contains a decimal number.  It shows the number on the display in the
@{"cell format" link part2.2.3} selected.  This includes Date and Time cells.

@{fg highlight}@{b}String:@{fg text}@{ub}
The cell contains a string of characters.  It shows the string on the display.

@{fg highlight}@{b}Formula:@{fg text}@{ub}
The cell contains a math expression.  It shows the resulting value of the
formula in the display.
@endnode


@node part2.2.3 "The Cell Format..."
@toc "part2.2"
@{b}@{u}The Cell Format:@{ub}@{uu}

The cell format defines how a cell is shown on the display.  This includes
the cell's color, style and font, as well as numeric display format.

The display format can often effect the visible accuracy of a numeric cell
on the display.  For example, if a cell contains the number 12.2731, and it
is set to a format of showing 2 decimal places only, it will be shown as 12.27.
This does not affect the actual value of the cell, only how it is shown on the
display.

See the @{"Cell Format" link part2.5} section for details.
@endnode


@node part2.2.4 "The Range..."
@toc "part2.2"
@{b}@{u}The Range:@{ub}@{uu}

A @{fg highlight}@{b}range@{fg text}@{ub} is a rectangular group of cells defined by their top left and bottom
right cells.  A range is described using the top left cell, a ':' colon, and
the bottom right cell.

For example:

    A1:B2       includes the cells A1, A2, B1, B2
    C10:G10     includes the cells C10, D10, E10, F10, G10

You can also define a range that will scope multiple sheets in a project.
That is called a 3-dimensional (3D) range.  It is described by the top left
cell in the first sheet and the bottom right cell in the last sheet.

For example:

    A_A1:B_A2   includes the cells A_A1, A_A2, B_A1, B_A2
@endnode


@node part2.2.5 "Moving around a project:  The Cursor..."
@toc "part2.2"
@{b}@{u}Moving around a project:  The Cursor:@{ub}@{uu}

The cursor is a rectangular highlight over a single cell in the sheet display.
That cell is called the 'current cell'.  Most operations will operate on the
current cell.  (like cut, copy, paste, edit, etc.)

The name of the current cell is shown in the 'cell contents line'.  The cell
contents line is at the top of the display, above the sheet display itself.
It shows the name of the current cell, some information about its format,
and its contents.

The cell contents line can consist of one or two lines.  It can be expanded
to two lines by using the 'Settings - View - Toggle Error Line' menu, or using
the Amiga-E hotkey.

@{fg highlight}@{b}@{u}Moving the cursor using the mouse:@{fg text}@{ub}@{uu}
To move the cursor to a different cell, simply click on that cell with the left
mouse button.  The scroll bars on the right and bottom of the window allows you
to scroll into other areas of the current sheet.

@{fg highlight}@{b}@{u}Moving the cursor using the keyboard:@{fg text}@{ub}@{uu}
The keyboard @{b}cursor keys@{ub} move the cursor up, down, left and right one step at a
time.  If you hold a cursor key down, the cursor will keep on moving until you
let go of the key.

If you hold down the @{b}shift@{ub} key and use a cursor key, the cursor will move one
entire 'page' (the number of columns or rows in the current display) at a time.

The cursor keys repeat their action if you hold them down.  You can control how
the keys repeat by using the 'Settings - Project - Cursor Movement Speed' menu.
This brings up a requester allowing you to set the delay between first holding the
key and the repeat starting, and the speed rate of the repeat.

The @{b}alt-cursor keys@{ub} move the cursor all the way to the top, bottom, left or
right of a sheet's limits.

You can also move between sheets in the current project by using the Amiga key
and the left or right cursor keys.  The right key takes you to the next sheet
in the current project, and the left key takes you to the previous sheet in the
current project.  The sheet name letter is shown at the top right of the window.

The @{b}Control key@{ub} also modifies the way the cursor keys operate.  If the cell
under the cursor before the move is empty, the cursor will move to the first
cell with contents in the direction selected.  If the cell under the cursor
before the move is not empty, the cursor will move in the selected direction
until it hits an empty cell, and it will stop at the last cell with contents.
This basically allows you to move to the end of block, where a block is a group
of cells next to each other.  It is most useful in @{"highlighting ranges" link part2.2.6}.

@{fg highlight}@{b}@{u}Going directly to a cell or range:@{fg text}@{ub}@{uu}
Use the 'Actions - Select - Range/Cell'.  You will be asked to enter a cell or a
range.  Simply enter the cell name as normal, (e.g. A1 or B12) and hit return.
 The cursor will be moved to that cell.  If you entered the name of a cell in
another sheet, that sheet (if it exists) will be shown.

@{fg highlight}@{b}@{u}Movement Limits:@{fg text}@{ub}@{uu}
Your movements around a sheet are limited to the current sheet's Movement
Limits.  These default to a range of A1 to ZZ2000.  You can change these limits
to any range by using the 'Settings - Sheet - Movement Limits'.  This will
bring up a requester that allows you to change the movement limits for the
current sheet.  Each sheet in the project can have different movement limits.
@endnode

@node part2.2.6 "Selecting a range..."
@toc "part2.2"
@{b}@{u}Selecting a range:@{ub}@{uu}

You can select a rectangular range of cells on the current sheet.  This is
highlighted by a shaded rectangle and is the @{fg highlight}@{b}current range@{fg text}@{ub}.  Most operations
that work on the current cell will work on all the cells in the current range
if one is selected.

A range can be selected in many ways:

@{fg highlight}@{b}@{u}Selecting a range using the keyboard:@{fg text}@{ub}@{uu}

The TAB key activates the Range mode.  You can then move the cursor normally to
expand the range as you like.  Hitting the TAB key again reverts back to normal
single-cell mode.  Shift-TAB switches on the range mode but also restores the
previously selected range.

For example, you can use the @{"control-cursor keys" link part2.2.5 19}
to highlight a block of cells.  Move the cursor to any cell in the first column,
hit the Tab key to activate the range, then hit the control-cursor-up key and
then control-cursor-down key.  This will select the entire column block.  If you
want to highlight multiple columns in a block, next hit control-cursor-left and
then control-cursor-right.

When a range is active, you can also use the numeric keypad keys to control the
current range:

Keypads 2, 4, 6 and 8 expand the range down, left, right and up.
Shift-Keypads 2, 4, 6 and 8 shrink the range down, left, right and up.
Keypads 1, 3, 7 and 9 move to the corners of the range.
Keypad 5 moves to the center of the range.


@{fg highlight}@{b}@{u}Selecting a range using the mouse:@{fg text}@{ub}@{uu}

@{b}@{u}General range select:@{ub}@{uu}
Click and hold down the left mouse button, hightlight the range you want
and then let go of the mouse button.  If you go outside the borders of the
displayed rows/columns, the sheet will scroll in the opposite direction.
The highlighted range will shrink and expand as you move the mouse pointer.
If you hold down the keyboard shift key	while highlighting a range, the
mouse pointer will continuously expand the range as you move range without
shrinking it.

@{b}@{u}Column Select:@{ub}@{uu}
Clicking on a column title will highlight that column's contents, from the
first row to the last row with any contents.  Clicking on another column
title after that will expand the range to fit both columns and whatever is
between them.  Double-clicking on a column will cancel the expanded range
of multiple columns and highlight only that column.

@{b}@{u}Row Select:@{ub}@{uu}
Same as Column Select.  Note that if you click on a column and then a row,
the whole rectangular area from A1 to the column and row you selected will
become the current range.


@{fg highlight}@{b}@{u}Auto-Block Range:@{fg text}@{ub}@{uu}

The Auto-Block-Range feature allows you to quickly range a block of cells
in a column, a row, or across columns and rows.  A block is defined as
adjacent cells of the same type (numbers or strings).  Numbers include
numeric cells and formulas with numeric results.  Strings include string
cells and formulas with string results.

@{b}@{u}Using the mouse:@{ub}@{uu}
Simply double-click on a cell.  If that cell has contents, all similar
adjacent cells above and below it (i.e. column-block) will be ranged.
If you double-click again, a row-block will be selected, and if you
double-click yet again, the whole block around the cell will be selected.

You can also triple-click instead of double-clicking twice, or quadruple-
click instead of double-clicking three times.

@{b}@{u}Using the keyboard:@{ub}@{uu}
Alt-Tab key does the same as double-clicking the cell.
Control-Tab key directly highlights the whole block.


@{fg highlight}@{b}@{u}Direct range entry:@{fg text}@{ub}@{uu}
Use the 'Actions - Select - Range/Cell'.  You will be asked to enter the range
to highlight.  Simply enter it as normal, (e.g. "A1:B10") and hit return.  The
range will then be highlighted.  If you entered the name of a range in another
sheet, that sheet (if it exists) will be shown.

@{fg highlight}@{b}@{u}Select All:@{fg text}@{ub}@{uu}
The Select All selects a range from A1 to the last row and column used in the
sheet, covering all cells used in the sheet.  It is called by the 'Actions -
Select - All' menu, or the Amiga-TAB key.

@{fg highlight}@{b}@{u}Select Last Column:@{fg text}@{ub}@{uu}
The 'Actions - Select - Last Column' menu selects a range of all the cells in
the last column in the sheet.

@{fg highlight}@{b}@{u}Select Last Row:@{fg text}@{ub}@{uu}
The 'Actions - Select - Last Row' menu selects a range of all the cells in the
last row in the sheet.

@{fg highlight}@{b}@{u}Select Last Cell:@{fg text}@{ub}@{uu}
The 'Actions - Select - Last Cell' menu selects the at the last column and
last row in the sheet.

@{fg highlight}@{b}@{u}Select Range Name:@{fg text}@{ub}@{uu}
The 'Actions - Select - Range Name' menu brings up a list of defined range
names in the current project and allows you to select a range name to go to.
@endnode


@node part2.2.7 "Handling multiple sheets in a project..."
@toc "part2.2"
@{b}@{u}Handling multiple sheets in a project:@{ub}@{uu}

When a new project is started, it comes up with a single sheet: sheet A.  You
can then add, insert and delete sheets, save a single sheet to disk, load a
single sheet to disk and other actions:

@{fg highlight}@{b}@{u}Add Sheet:@{fg text}@{ub}@{uu}
Adding a sheet to the current project is easy.  Use the 'Project - Sheet - Add'
menu.  A new blank sheet will be built and added to the end of the project, and
then will be shown on the display.

@{fg highlight}@{b}@{u}Insert Sheet:@{fg text}@{ub}@{uu}
To insert a sheet between other sheets, use the 'Project - Sheet - Insert' menu.
When this is used, a new sheet will be be inserted in the place of the current
sheet and will get its name.  The current sheet, and all sheets after it, will
have their names increased by one.

For example, if you have a project made up of sheets A, B, and C, and you insert
a new sheet at sheet B, the project will then change to A, B (new), C (old B),
and D (old C).

@{fg highlight}@{b}@{u}Delete Sheet:@{fg text}@{ub}@{uu}
Deleting a sheet will remove the current sheet and bring all sheets after it
down by one step.  For example, if you have a project made up of three sheets:
A, B and C; deleting sheet B will result in sheet A, and sheet B (old C).

FinalCalc performs a lot of @{"repair work" link "FinalCalc:guide/part3.guide/part3.1.10"} on formulas and range names after
inserting or deleting a sheet.

@{fg highlight}@{b}@{u}Save Single Sheet:@{fg text}@{ub}@{uu}
You can save the current sheet to disk as an individual sheet, not the entire
project.  Use the 'Project - Sheet - Save Single' menu.  You will get a file
requester that will ask you where to save the sheet.

The sheet is saved as a single sheet project, so you can then load it back as a
normal project if you like.

@{fg highlight}@{b}@{u}Load Single Sheet:@{fg text}@{ub}@{uu}
You can load a sheet into the current sheet.  Simply use the 'Project - Sheet -
Load Single' menu.  You will be asked to select a file to load.  The sheet in
the selected project to load will be loaded in place of the current sheet.  If
the file selected has a project with more than one sheet, only the first sheet
in it will be used.

@{fg highlight}@{b}@{u}Hide Sheet:@{fg text}@{ub}@{uu}
The 'Project - Sheet - Hide Sheet' feature closes all views on the current
sheet.  If no other views are open on the current project, FinalCalc will
complain and refuse to do this.

@{fg highlight}@{b}@{u}Clear Sheet:@{fg text}@{ub}@{uu}
The Clear Sheet feature removes all cells in the current sheet, as well as all
column and row settings.  It effectively deletes the sheet and inserts a new one
in its place.

@{fg highlight}@{b}@{u}Sheet Title:@{fg text}@{ub}@{uu}
You can also change the title of a sheet by using the 'Settings - Sheet -
Title' menu which allows edit the title of the sheet.  This is a simple text
string, and is used for identifying the sheet by the user.

@{fg highlight}@{b}@{u}Selecting a sheet to view:@{fg text}@{ub}@{uu}
You can use the 'Project - Sheet - View' menu to bring up the 'Select Sheet To
View' requester, which shows all the sheets active in the current project, and
how many views are open on each sheet.  From this requester, you can select a
sheet to move to by highlighting and using the 'View' button.  The current sheet
view will be moved to that sheet.
@endnode


@node part2.2.8 "Column Widths..."
@toc "part2.2"
@{b}@{u}Column Widths:@{ub}@{uu}

All the cells under a single column have the same width.  You can control a
column's width to make it bigger in order to fit larger text in the cells in
that column, or make it smaller, to make it use less space on the display and
printing.

A column's width can be set to any of the following:

a.	Custom Width:
	This is any width the user likes.

b.	Default Size:  
	The default size a column comes up in.  This is normally 10 characters wide.

c.	Narrow:
	The default Narrow width. (normally 5 characters wide)

d.	Wide:
	The default Wide width. (normally 15 characters wide)

e.	User:
	The default User width. (normally 12 characters wide)

The last 4 width settings are 'Default' widths.  Any column set to one of them
is said to save a 'default' width.  These Default Widths can be edited, making
all columns that use a default width change along with it in one go.

@{fg highlight}@{b}@{u}Chaning a column's width using the mouse:@{fg text}@{ub}@{uu}
Move the pointer to the small vertical line between the column titles in the
column title bar.  Click and hold the left mouse button there.  A tall marker
will appear across the screen.  Move the pointer left or right to change the
column width, release the mouse button when done.  You can abort the width
change by hitting any key on the keyboard.

@{fg highlight}@{b}@{u}The Column Width Requester:@{fg text}@{ub}@{uu}
The Column Width requester is called by the 'Settings - Sheet - Edit Column
Width' menu.  From it you can set the width to a custom width or a default
width.  You can also set it to one of two other settings:

a.	Current Cell:
	Set the column width to the width of the current cell's text.

b.	Biggest Cell:
	Set the column width to the width of the largest cell text in this column.

Both those are set as a custom width.


@{fg highlight}@{b}@{u}Change a column's width using the keyboard:@{fg text}@{ub}@{uu}
Use the 'Settings - Sheet - Set Column Width' menu (or the Amiga-W hotkey).
You will be asked to enter a width from the keyboard.  Just enter the width
you like (e.g. 10) and hit return.  You can also enter any of the following:

   d	Default width
   n	Narrow
   w	Wide
   u	User width
   c	Current Cell
   d	Biggest Cell

The Control-Keypad 4 key shrinks a column's width by one character, and the
Control-Keypad 6 key increases it by one.
@endnode

@node part2.2.9 "Hiding Columns..."
@toc "part2.2"
@{b}@{u}Hiding Columns:@{ub}@{uu}

A column can be hidden from view.  This will make it disappear from the
display.  The cursor will skip a hidden column when the cursor is moved around.

You might want to hide a column from display because it has intermediate
calculations that you don't want to see or print.

To hide a column, use the 'Settings - Sheet - Edit Width' menu, and set the
column to 'Hidden' in the @{"Width requester" link part 2.2.8 34}.

Once a column is hidden, the only way to get it back is to temporarily disable
hidden columns.  To do this, use the 'Settings - View - Settings' menu, and
then turn on the 'Show Hidden Columns' option.  This will show all columns
in the current view.  Simply select the column and change it back to Visible
using the 'Settings - Sheet - Edit Width' menu.
@endnode


@node part2.2.10 "Column titles..."
@toc "part2.2"
@{b}@{u}Column titles:@{ub}@{uu}

Any column can have a user-defined title that will appear in the column border
instead of the normal column name.

To set a column's title, use the 'Settings - Sheet - Edit Width' menu, and
enter the title in the @{"Width requester" link part 2.2.8 34}.

To clear a column's title, simple clear it from the Width requester.

You can temoprarily hide all column titles from view by using the 'Settings -
View - Settings' menu, and then turning on the 'Hide Titles' option.
@endnode

@node part2.2.11 "Default Column Widths..."
@toc "part2.2"
@{b}@{u}Default Column Widths:@{ub}@{uu}

To edit the @{"Default Column Widths" link part2.2.8} for the current sheet, use the
'Settings - Sheet - Default Column Widths' menu.  This will bring up the 'Edit
Default Column Widths' requester.

Simply edit the number for each default width.  The Default Widths only apply
to the current sheet.  Each sheet in the current project can have its own
default widths.
@endnode

@node part2.2.12 "Row Heights..."
@toc "part2.2"
@{b}@{u}Row Heights:@{ub}@{uu}

The height of each row in the sheet is automatically adjusted to match the
tallest cell in that row.

You can, however, tell FinalCalc to make a row taller or shorter by a certain
number of pixels.  This can be done in one of the following methods:

@{fg highlight}@{b}@{u}Using the mouse:@{fg text}@{ub}@{uu}
Move the pointer to the small horizontal line between the row numbers in the
sheet display.  Click and hold the left mouse button there.  A long marker will
appear across the screen.  Move the pointer up or down to change the row height
offset, release the mouse button when done.  The current height offset is shown
in the display while you are moving the mouse.  You can abort the height change
y hitting any key on the keyboard.

@{fg highlight}@{b}@{u}Row Height Requester:@{fg text}@{ub}@{uu}
The Row Height requester is called by the 'Settings - Sheet - Edit Row
Height' menu.  It shows the current height offset.  The height offset
default to 0.  You can change it to any value from -100 to +500.

@{fg highlight}@{b}@{u}Using the keyboard:@{fg text}@{ub}@{uu}
The Control-Keypad 8 key shrinks a row's height by one pixel, and the Control-
Keypad 2 key increases it by one.
@endnode


@node part2.3 "Views..."
@toc "Main"
@{b}@{u}
	Views:
@{uu}@{fg highlight}
	@{" > " link part2.3.1} Opening views, moving between views, closing views
	@{" > " link part2.3.2} The Sheet View
	@{" > " link part2.3.3} View Settings
	@{" > " link part2.3.4} Screen Title Bar
	@{" > " link part2.3.5} Keyboard Menus
	@{" > " link part2.3.6} Titles Freeze
	@{" > " link part2.3.7} Zoom Display Mode
	@{" > " link part2.3.8} The Graph View
@endnode


@node part2.3.1 "Opening views, moving between views, closing views..."
@toc "part2.3"
@{b}@{u}Opening views, moving between views, closing views:@{ub}@{uu}

The way you interact with a project is through a 'view'.  A view is a window
on the screen in which FinalCalc shows project data or graphs.

When a new project is opened, you automatically get a view opened on the
first sheet in that project.  That is called a 'sheet view', and is the main
interface to the spreadsheet.

A project can have multiple views opened on it.  Each view can move around in
any sheet in the project.  As a change is made in one view, the other views are
automatically updated to reflect the changes.

FinalCalc has another type of view, a Graph View.  This can show a graph in a
window that is automatically updated as the project data changes.

To open a view on the current project.  Use the 'Project - View - New Sheet
View' menu to open a sheet view, or 'Project - View - New Graph View' menu to
open a graph view.  You can have as many views open as you like.

A view can be moved and resized, as well as moved in front of or behind other
views.

The 'Project - View - Next' menu selects the next view for the current project,
brings it to the front and activates it for user input.

You can also use the Amiga-Cursor Up and Down keys to move through the view
list for the current project.  Amiga-Cursor-Down does the same thing as
'Project - View - Next View'.  Amiga-Cursor-Up does the reverse, moving to
the previous view.

To expand a view to its maximum size by using the 'Project - View - Maximum
size' menu.

When a project with multiple views is saved, the current view is noted and
when the project is loaded, that view is made active and brought to the
front.

To close a view, either click on the view's 'close window' button (at the top
left of the window) or use the 'Project - View - Close' menu.
@endnode

@node part2.3.2 "The Sheet View..."
@toc "part2.3"
@{b}@{u}The Sheet View:@{ub}@{uu}

A sheet view contains many objects.  Its main purpose is to show the project
sheet data and allow you to interact with the project.

@{fg highlight}@{b}@{u}Sheet Data Area:@{fg text}@{ub}@{uu}
The sheet data area is the bulk of a sheet view.  It basically shows the
contents of the cells in the current sheet.

@{fg highlight}@{b}@{u}Cell Contents Line:@{fg text}@{ub}@{uu}
The cell contents line shows the current cell name, some information about its
@{"format" link part2.5} and the contents of the cell.  It consists of one or two lines.   It can
be toggled between one and two lines by using the 'Settings - View - Toggle
Error Line' menu, or using the Amiga-E hotkey.

The second line is generally called the 'Error Line' because it is used to show
the description of an error in a formula, however, if the cell is not a formula,
or it has no error, then the second line is used to show the cell contents if
they are longer than the first line.

@{fg highlight}@{b}@{u}Current Sheet Indicator:@{fg text}@{ub}@{uu}
The current sheet indicator simply show the name of the current sheet.
(e.g. 'A', 'B', 'AA')

@{fg highlight}@{b}@{u}Mode Indicator:@{fg text}@{ub}@{uu}
The mode indicator is the small box between the column and row titles.  It is
used to show what mode the user interface is currently in.  This can be any of
the following:

	Blank:
	The normal mode, allows moving around the sheet.

	Menu:
	Comes up when keyboard menus are active.

	Input:
	FinalCalc is waiting for input from the user.

	Roam:
	Indicates Roam mode is active during formula editing.

	Calc, Cut, Copy, Paste, Fill, etc.:
	Indicating FinalCalc is busy doing something right now.


@{fg highlight}@{b}@{u}Changes Indicator:@{fg text}@{ub}@{uu}
The changes indicator is a small box at the bottom right of the view.  It tells
you whether the project has been changed, and how many changes to the project data
have been done.

@{fg highlight}@{b}@{u}Window Title Bar:@{fg text}@{ub}@{uu}
The view's window title bar shows the file name of the current project, and the
title of the current sheet.

@{fg highlight}@{b}@{u}Icons Panel:@{fg text}@{ub}@{uu}
The icons panel consists of a set of icons.  Each icon does a certain
function.

@{fg highlight}@{b}@{u}Column and Row Headers:@{fg text}@{ub}@{uu}
The Column header is the row of boxes over the sheet data area showing the
size of each column of cells.  It shows the name of the column (A, B, AB)
or the @{"title" link part2.2.10 } of the column if it has one.

The Row header is the column of boxes to the left of the view.  It shows
the row numbers of the cells in the sheet data area.

@{fg highlight}@{b}@{u}The Cursor:@{fg text}@{ub}@{uu}
The Cursor is the rectanglar highlight over the current cell.

@{fg highlight}@{b}@{u}Scroll Bars:@{fg text}@{ub}@{uu}
The scroll bars are the sliders on the right and bottom of the view.  They
move the view around in the current sheet.  The sliders also show the size
of the current view size to the total data in the sheet.

At the bottom right corner, there are 4 small gadgets that do the same job
as the keyboard cursor keys.  They move the cursor one step at a time in the
selected direction and repeat if you hold them down.
@endnode

@node part2.3.3 "View Settings..."
@toc "part2.3"
@{b}@{u}View Settings:@{ub}@{uu}

You can control some of the objects described in 2.3.2 above.  Use the
'Settings - View - Settings' menu (or the Amiga-H hotkey) to bring up the 'Edit
View Settings' requester.

@{fg highlight}@{b}@{u}Cell Display Controls:@{fg text}@{ub}@{uu}

	@{b}Show hidden cells:@{ub}
	If this option is turned on, FinalCalc ignores the Hidden setting for
	cells in the current view.  All hidden cells will be shown.

	@{b}Show formulas:@{ub}
	By default, FinalCalc shows the result of a formula in the cell display.
	You can, however, see the actual formula itself in the cell display if you
	turn this option on.

	@{b}Hide zeros:@{ub}
	Hide zeros, when turned on, will hide all numeric cells that have a value
	of zero from the display.  They will still show up in the cell contents
	line, but not in the cell display.  This helps you hide large numbers of
	zeros from your view.

	@{b}Hide infinity:@{ub}
	FinalCalc shows cells that have an infinity value as 'oo'.  If you turn on
	this option, cells with an infinity value (negative or positive) will be
	shown as blank on the cell display.


@{fg highlight}@{b}@{u}Show Objects:@{fg text}@{ub}@{uu}

	@{b}Column header:@{ub}
	This is on by default.  If you turn it off, FinalCalc will not show the
	Column header in the sheet view.

	@{b}Row header:@{ub}
	This is on by default.  If you turn it off, FinalCalc will not show the
	Row header in the sheet view.

	@{b}Cell contents:@{ub}
	Turning this off will remove the cell contents line (and the error line)
	from the current sheet view.

	@{b}User icons:@{ub}
	Turning this off will remove all the icons from the current sheet view.


@{fg highlight}@{b}@{u}Columns Control:@{fg text}@{ub}@{uu}

	@{b}Lock All:@{ub}
	If you turn on the Lock All Columns option, you will not be able to change
	the size of the columns in the sheet view using the mouse.  This stops you
	from accidentally changing the width of a column.

	@{b}Show Hidden:@{ub}
	This option allows you to show all @{"hidden columns" link part2.2.9} in the current view.

	@{b}Hide Titles:@{ub}
	This option allows you to hide all @{"column titles" link part2.2.10} in the current view.
@endnode

@node part2.3.4 "Screen Title Bar..."
@toc "part2.3"
@{b}@{u}Screen Title Bar:@{ub}@{uu}

The screen title bar of a FinalCalc screen shows the current date and time.  By
default, the date is shown as "Monday, 28 November 1994" and the time is shown
as "10:29".  You can change this to any format by using the 'Settings - Global -
Clock Display Format'.  This brings up the 'Edit Clock Format' requester.

Simply enter the date and time format strings.  For full information on the
time format strings see @{"Appendix 2" link "FinalCalc:guide/appendix2.guide/Main"}, and for date format strings see @{"Appendix 3" link "FinalCalc:guide/appendix3.guide/Main"}.
You can also click on the [?] gadgets to get online help on the date and time
formats.

The screen title bar is normally updated once a minute.  If you enter a time
format that shows the current second, the title bar will be updated every
second.  On some systems, this may cause unwanted flickering on the title bar
every second.

The screen title bar also shows two indicators:

The 'Calc' indicator comes on when FinalCalc is currently calculating a project
in the @{"background" link "FinalCalc:guide/part3.guide/part3.3" 28}.

The 'Printing' indicator comes on when FinalCalc is currently printing a print
job in the background.
@endnode

@node part2.3.5 "Keyboard Menus..."
@toc "part2.3"
@{b}@{u}Keyboard Menus:@{ub}@{uu}

You can access all the FinalCalc menus from the keyboard if you are in a
sheet view.

The '/' key brings up the keyboard menus.  The menus show up in the box at
the bottom of the sheet view.

The menus are shown in a single line.  Each menu item is shown with one
letter of its text underlined.  That is the 'hotkey' for that item.
Hitting this hotkey immediately selects that item.

Also, the first item is highlighted.  You can move the highlight left and
right using the cursor keys.  Hitting the return key selects that item.
The space bar also moves the cursor to the right.

If you select an item that has a sub-menu.  That menu is then shown, and you
can navigate it in the same way.

If there are more menu items than can fit in the single line, a '»' marker is
shown to indicate that there are more selections available.  Simply use the
right cursor key to move to those items.

Below the menus line, the 'help line' shows a quick description of what the
currently highlighted item does.

The Escape key goes back up one level, or exits the keyboard menus if you
are at the top menu level.

Hitting the '/' key at any time goes back to the top menu level.

Hitting the Amiga-/ key at any time (even outside keyboard menus) repeats the
last menu you selected.  This works with both normal menus and keyboard menus.
@endnode

@node part2.3.6 "Titles Freeze..."
@toc "part2.3"
@{b}@{u}Titles Freeze:@{ub}@{uu}

You can 'freeze' the first several columns and/or rows of a sheet so that
they always show up in the display.  This allows you to scroll around in
big sheets and still see what each column or row represents.

To freeze columns or rows, use the 'Settings - Titles - Edit Titles' menu.
The 'Edit Titles Freeze' requester will come up.

You can define the start and end columns to freeze.  Enter the name of the
columns in the From and To entries.  You can use the 'Set To Current
Column' button to have FinalCalc fill the From and To entries for you from
column A to the current column in the sheet view.  The 'Clear' button
clears all the titles freeze.  The same applies for rows freeze.

You can also temporarily turn off the Titles Freeze by using the 'Settings
- Titles - Toggle Freeze' menu.  This hides the titles freeze temporarily
without clearing them.  To reactivate the titles freeze, use the Toggle
Freeze menu again.
@endnode

@node part2.3.7 "Zoom Display Mode..."
@toc "part2.3"
@{b}@{u}Zoom Display Mode:@{ub}@{uu}

The Zoom display mode changes the way a sheet view shows the cells.  Instead of
the actual cell contents shown, FinalCalc will show a single character telling
you the cell's type:

	@{fg highlight}=@{fg text}	Cell contains a Formula
	@{fg highlight}s@{fg text}	String cell
	@{fg highlight}d@{fg text}	Date cell
	@{fg highlight}t@{fg text}	Time cell
	@{fg highlight}%@{fg text}	Percent numeric cell
	@{fg highlight}e@{fg text}	Scientific numeric cell 
	@{fg highlight}b@{fg text}	Bool numeric cell
	@{fg highlight}n@{fg text}	General numeric cell

In Zoom mode all the usual cursor and range selection methods work, so you can
quickly highlight a large range to do something to it.

The 'Settings - View - Toggle Zoom' menu (or the Amiga-Z hotkey) toggles the
zoom mode.
@endnode

@node part2.3.8 "The Graph View..."
@toc "part2.3"
@{b}@{u}The Graph View:@{ub}@{uu}

In addition to Sheet Views, you can have Graph Views.  A Graph View shows a
graph in its own window.  The graph is automatically updated as the project
data changes.

To open a graph view, use the 'Project - View - New Graph View' menu.
Depending on whether the project has any graphs defined, one of the following
will happen:

- If the project has no graphs defined, you will get an error message and no
  view will be opened.

- If the project has only one graph defined, the graph view will be opened and
  will show that graph.

- If the project has more than one graph defined, you will be presented with a
  requester showing all the graphs in the project.  Select the graph you want
  to show in the new view.

A graph view has the normal menus accessible via the mouse as usual.  Most of
the project editing menus are disabled however.

When a graph is shown in a graph view, it tries to use the colors on the screen
it is open on to achieve good contrast between graph objects.
@endnode


@node part2.4 "Editing Cells..."
@toc "Main"
@{b}@{u}
	Editing Cells:
@{uu}@{fg highlight}
	@{" > " link part2.4.1} Editing Cells
	@{" > " link part2.4.2} Cell Edit Menus
	@{" > " link part2.4.3} Edit vs. Input modes
	@{" > " link part2.4.4} Cell Entry Shortcuts
	@{" > " link part2.4.5} Entering A Date or Time Value
	@{" > " link part2.4.6} Return Movement Setting
@endnode

@node part2.4.1 "Editing Cells..."
@toc "part2.4"
@{b}@{u}Editing Cells:@{ub}@{uu}

To edit a cell, move the cursor to that cell and then hit the Return key, or
use the 'Edit - Edit' menu.

This will activate the 'Edit Cell Box' at the bottom of the sheet view.  It
will contain the current contents of the cell, or will be empty if the cell
has no contents.

You can also directly type into a cell without using the Return key.  This will
replace the contents of the cell.

You can abort editing a cell at any time by using the Escape key.

While you are in edit cell mode, the left and right cursor keys move the cell
text edititing cursor, not the current cell cursor.  

FinalCalc shows what the currently entered contents will look like in the sheet
view using the formatting defined for that cell.  This changes as you edit the
cell contents.  This is only active if you are not entering a formula.

When you are done editing the cell, hit the Return key.  The new contents are
then stored into the cell.  The cell type will be changed if necessary to
reflect the type of text entered into it:

-	If the new contents entered look like a decimal, scientific, currency or
	percentage number, the cell will be stored as numeric.

-	If the first character in the new contents is an equals '=' sign, that cell
	will be set to be a formula, and the contents are stored as a formula.

-	If the cell is currently set to a Date or a Time format and the new
	contents entered look like a date or a time, the contents will be
	converted to a date or time value as stored as that.

-	In all other cases, the new contents are considered to be a string, and
	will be stored as a string cell.

After the cell contents are entered, the current cell cursor is moved one row
down by default.  This allows you to enter cells continuously without having to
move the cursor between them.  The direction the cursor moves after entering a
cell is controlled by the {"Return Movement" link part2.4.6} setting.
@endnode

@node part2.4.2 "Cell Edit Menus..."
@toc "part2.4"
@{b}@{u}Cell Edit Menus:@{ub}@{uu}

When FinalCalc is in cell edit mode, you get new menus for the sheet view.
The menus have the following cell text editing functions:

@{fg highlight}@{b}@{u}Input Menu:@{fg text}@{ub}@{uu}

	@{b}Save:@{ub}
	Enters the new contents into the cell.  Same as hitting the Return key.

	@{b}Cancel:@{ub}
	Cancels the cell editing.  Same as hitting the Escape key.

@{fg highlight}@{b}@{u}Edit Menu:@{fg text}@{ub}@{uu}

	@{b}Restore to original contents:@{ub}
	Restores the contents to the original contents of the cell before you
	started editing it.

	@{b}Clear contents:@{ub}
	Clears the contents of the edit cell box.

@{fg highlight}@{b}@{u}Actions Menu:@{fg text}@{ub}@{uu}

	These are formula editing functions.  There are only available when editing
	a formula.  The only function available in non-formula editing is the
	@{"Find Matching Bracket" link "FinalCalc:guide/part3.guide/part3.2" 53} feature.

@{fg highlight}@{b}@{u}Formulas Menu:@{fg text}@{ub}@{uu}

	These are @{"formula editing functions" link "FinalCalc:guide/part3.guide/part3.2" 53}.  There are only available when editing
	a formula.  The only functions available in non-formula editing are the
	Paste Date String, Paste Date Format and Paste Time format.

@{fg highlight}@{b}@{u}Cursor Menu:@{fg text}@{ub}@{uu}

	@{b}Beginning of Entry:@{ub}
	Moves the cursor to the first character in the text.  (Same as the
	Alt-Left-Cursor key.)

	@{b}End of Entry:@{ub}
	Moves the cursor to the last character in the text.  (Same as the
	Alt-Right-Cursor key.)

	@{b}Next Word:@{ub}
	Moves the cursor to the next word.  (Same as the Shift-Left-Cursor key.)

	@{b}Previous Word:@{ub}
	Moves the cursor to the previous word.  (Same as the Shift-Left-Cursor
	key.)
@endnode

@node part2.4.3 "Edit vs. Input modes..."
@toc "part2.4"
@{b}@{u}Edit vs. Input modes:@{ub}@{uu}

When editing a cell, you are in one of two edit modes:

@{fg highlight}@{b}@{u}Edit Mode:@{fg text}@{ub}@{uu}
This is indicated by 'Edit' in the mode indicator box (at the top left of
the sheet data area.) When you are in Edit mode, the cursor keys move the
cell edit cursor.  The Edit mode is invoked when you use the 'Edit - Edit'
menu, or hit Return on a cell to edit it.

@{fg highlight}@{b}@{u}Input Mode:@{fg text}@{ub}@{uu}
This is indicated by 'Input' in the mode indicator box.  When you are in
Input mode, the cursor keys automatically input the new contents into the
cell and move the current cell cursor in the direction of the cursor key.
The input mode is triggered when you directly enter text into a cell
without using the Return key or the 'Edit - Edit' menu.
@endnode

@node part2.4.4 "Cell Entry Shortcuts..."
@toc "part2.4"
@{b}@{u}Cell Entry Shortcuts:@{ub}@{uu}

When entering a cell, FinalCalc can change the format of the cell depending on
what the text you entered looks like:

-	If the first character in the contents is a $ sign, and the rest is a
	number, (e.g. $12.3), the cell is automatically set to currency mode and
	then stored as a number.

-	If a number is entered with commas, (e.g. 12,456), the current cell will
	automatically have the Commas flag set for it and the number is stored.
	The comma(s) don't have to be in the exact place, just their existance in
	the number will indicate that you want commas.

-	When entering a string, the first letter can be used to specify an alignment
	mode directy.  If the first letter is one of the following, the cell is set
	to the selected alignment mode, and the rest of the string is stored:

	'	Default string alignment (i.e. left-aligned string)
	^	Centered string
	"	Right-aligned string
	~	Numeric string alignment
	\\	Filled string

	The alignment characters can be used to force a number to be stored as a
	string.  (e.g. '123 is stored as a string, not a number)

See the @{"Cell Format" link part2.5} section for details on these formats.
@endnode

@node part2.4.5 "Entering a Date or Time value..."
@toc "part2.4"
@{b}@{u}Entering a Date or Time value:@{ub}@{uu}

If the cell being edited is set to a {"Date or a Time" link part2.4.5} format and the new
contents entered look like a date or a time, the contents will be converted to
a date or time value as stored as that.

@{fg highlight}@{b}@{u}Date Entry:@{fg text}@{ub}@{uu}

The entered date string must conform to the 'Date Strings' format as described
in @{"Appendix 4" link "FinalCalc:guide/appendix4.guide/Main"}.

For example:

	1 jan 1994
	12 feb
	today
	last saturday
	first monday next month

When you start editing a date cell, you will get the current value shown
as a date string.. e.g. '12 jan 1994'.
  
@{fg highlight}@{b}@{u}Time Entry:@{fg text}@{ub}@{uu}

The time string entered must contain at least the first of the following:

	Hours, which is any number, from 0 upwards.
	Minutes, which is any number, from 0 upwards.
	Seconds, which is any number, from 0 upwards.

These must be seperated by a colon ':' or a space.

For example:

	10:12:11
	10:12
	10

You can also enter a number of hours, seconds or minutes more than the
normally accepted numbers (24 hours, 60 minutes, or 60 seconds).  For
example:

0:0:10000	Defines a time of 10,000 seconds.
0:1000		Defines a time of 1000 minutes.
1000		Defines a time of 1000 hours.

When you start editing a time cell, you will get the current contents shown
as a time string.. e.g. '10:12:00'.
@endnode

@node part2.4.6 "Return Movement Setting..."
@toc "part2.4"
@{b}@{u}Return Movement Setting:@{ub}@{uu}

After the cell contents are entered, the current cell cursor is moved one
row down by default.  This allows you to enter cells continuously without
having to move the cursor between them.  The direction the cursor moves
after entering a cell is controlled by the Return Movement setting.  Use
the 'Settings - Sheet - Return Move Direction' menu.  This will bring up
the 'Edit Return Move' requester.

From it, you can set the direction the cursor moves after editing a cell,
or set it to 'none' so that the cursor stays on the current cell.

You can also set the number of steps the cursor moves in the selected
direction by changing the Steps value.
@endnode


@node part2.5 "Cell Format..."
@toc "Main"
@{b}@{u}
	Cell Format:
@{uu}@{fg highlight}
	@{" > " link part2.5.1 } The Cell Format
	@{" > " link part2.5.2 } Cell Format: Type
	@{" > " link part2.5.3 } Cell Format: Decimals
	@{" > " link part2.5.4 } Cell Format: Commas
	@{" > " link part2.5.5 } Cell Format: Alignment
	@{" > " link part2.5.6 } Cell Format: Hide
	@{" > " link part2.5.7 } Cell Format: Repeat
	@{" > " link part2.5.8 } Cell Format: Style
	@{" > " link part2.5.9 } Cell Format: Color
	@{" > " link part2.5.10} Cell Format: Font
	@{" > " link part2.5.11} Cell Format: Comment
	@{" > " link part2.5.12} Cell Format: Protect
	@{" > " link part2.5.13} Format Tags
	@{" > " link part2.5.14} Empty Cells
	@{" > " link part2.5.15} Default Column Format
	@{" > " link part2.5.16} Current Cell Format Indicator
@endnode

@node part2.5.1 "The Cell Format..."
@toc "part2.5"
@{b}@{u}The Cell Format:@{ub}@{uu}

The Cell Format defines the way a cell's contents are displayed in FinalCalc.
This defines the way numeric contents and string contents are displayed, as
well as the cell font, color and style.

The 'Format' menu controls all cell formatting.  You can change a cell's
format directly via the Format menus, or via the 'Edit Cell Format' requester
which shows all the cell's format in one requester.  It is called by the
'Format - Edit' menu.

The Format menus act on the current cell.  If you highlight a range, then the
Format menu commands will act on that entire range.

The Edit Cell Format requester only affects the current cell, even if a range
is highlighted.

Some format settings only apply to numeric cells, others only apply to string
cells, and others apply to all cell types.
@endnode

@node part2.5.2 "Cell Format: Type..."
@toc "part2.5"
@{b}@{u}Cell Format: Type:@{ub}@{uu}

The cell display 'type' defines the basic numeric type of the cell.  This
affects both how it is displayed, and also how input into this cell is handled
in case of @{"date and time" link part2.4.5} cells.

A numeric cell can be set to one of the following types:  (String cells are not
affected by this setting)

@{fg highlight}@{b}@{u}General:@{fg text}@{ub}@{uu}
This is the default numeric cell type.  The cell simply shows a decimal
number with no special formatting.  (e.g.  12.3456)

@{fg highlight}@{b}@{u}Scientific:@{fg text}@{ub}@{uu}
Shows the decimal number in scientific notation.  This helps show very
large or very small number.  The cell value is shown as a number between
0.0 and 1.0, then an 'E', an optional positive or negative sign, and then
an exponent of 1 to 3 digits.

Basically, the first number is multiplied by 10 to the power of the exponent.
   
	1.0E+6   =  1.0  * 10^6  =  1,000,000
	2.74E+5  =  2.74 * 10^5  =  274,000
	1.0E-6   =  1.0  * 10^-6 =  0.000001

@{fg highlight}@{b}@{u}Currency:@{fg text}@{ub}@{uu}
The number is shown in the defined currency format.  This defaults to a '$'
sign preceding the number.  (e.g.  $12.34)

You can control how Currency format cells are displayed by using the
'Settings - Sheet - Currency' menu.  This brings up the 'Edit Currency'
requester.  Simply set the currency symbol (up to 12 characters) you want to
show, and whether you want it to be a prefix (shown before the number) or a
postfix (shown after the number).

@{fg highlight}@{b}@{u}Percent:@{fg text}@{ub}@{uu}
Shows the number as a percentage value.  This is basically the value of the
cell, multiplied by 100, and shown with a '%' sign added to it. (e.g. "12.34%")

@{fg highlight}@{b}@{u}Boolean:@{fg text}@{ub}@{uu}
This simply shows either "TRUE" or "FALSE".  If the value of the cell is zero,
FALSE is shown, otherwise TRUE is shown.

@{fg highlight}@{b}@{u}Date:@{fg text}@{ub}@{uu}
Shows the cell as a date.  The value of the cell is interpreted as the number
of days since 1 January 1978.

FinalCalc supports 4 types of date formats.  These are defined as Date 1 to
Date 4.  You can set a cell to any of those four formats.

The four date formats are also user-definable.  They default to the following:

@{b}@{u}	Format			Example@{ub}@{uu}
 1	dd.nn.yy			21.11.94
 2	nn.dd.yy			11.21.94
 3	dd-Mmm-yy		21-Nov-94
 4	d Mmmm yyyy		21 November 1994

To edit the date formats, use the 'Settings - Sheet - Time/Date Formats'.  The
'Edit Date/Time Formats' requester will come up showing the currently defined
formats for the current sheet.

For full information on the time format strings see @{"Appendix 2" link "FinalCalc:guide/appendix2.guide/Main"}, and for date
format strings see @{"Appendix 3" link "FinalCalc:guide/appendix3.guide/Main"}.  You can also click on the [?] gadgets to get
online help on the date and time formats.


FinalCalc supports date from 1 Jan 1900 to 31 Dec 2999.  Cell values that
result in dates outside this range are shown as "DATE ERROR".

@{fg highlight}@{b}@{u}Time:@{fg text}@{ub}@{uu}
Shows the cell as a time value.  The value of the cell is interpreted as a
fraction of a day.  (e.g. 0.5 is 12:00:00 and 0.25 is 06:00:00).

FinalCalc supports 2 types of time formats.  There are defined as Time 1 and
Time 2.  You can set a cell to either of these.

These two formats are also user-definables.  They default to the following:

@{b}@{u}	Format		Example@{ub}@{uu}
 1	hh:mm:ss		11:15:00
 2	hh:mm aa		11:15 am

To edit the time formats, use the 'Settings - Sheet - Time/Date Formats'
as described in the section on dates above.
@endnode

@node part2.5.3 "Cell Format: Decimals..."
@toc "part2.5"
@{b}@{u}Cell Format: Decimals:@{ub}@{uu}

When displaying a decimal number, FinalCalc normally shows as much of the
fraction of that number as it can until the fraction is exhaused.  (e.g.
1.2, 1.23, 1.01)  This called the 'fixed decimals off' mode.  To force
FinalCalc to display a certain number of decimals for the fraction, you
can use the Decimals setting.

Simply use the 'Format - Decimals' menu to set how many digits you want to
show after the decimal point.  If the number has a larger fraction than that,
it will be rounded up to the number requested, and if it has a smaller fraction
than that, it will be padded out with zeros to fill it.

When you set the number of decimals for a cell, the Fixed setting is
automatically turned on.  To get the number back to the default mode, use the
'Settings - Fixed - Off' menu.  The Decimals setting is ignored if the Fixed
mode is off.
@{b}@{u}
	Setting			Display@{ub}@{uu}
	Fixed Off			12.3456
	Decimals 3		12.346
	Decimals 0		12
	Decimals 6		12.345600

In Fixed off mode, if the number has too many digits in its fraction to display
in the current column, the fractional part is trimmed down, and a '+' sign is
shown at the end of the number to indicate that.  (e.g.  "12.3456+")
@endnode

@node part2.5.4 "Cell Format: Commas..."
@toc "part2.5"
@{b}@{u}Cell Format: Commas:@{ub}@{uu}

The Commas setting, when turned on, shows a numeric cell with commas in it
every 3 digits.  This only affects numeric cells.

Commas On		1,234,567.89
Commas Off		1234567.89
@endnode

@node part2.5.5 "Cell Format: Alignment..."
@toc "part2.5"
@{b}@{u}Cell Format: Alignment:@{ub}@{uu}

Normally, FinalCalc shows the numeric value of a cell at the right side of that
cell, and string contents of a cell at the left side.  This is called the
default alignment mode.

FinalCalc allows several cell text alignments:

@{fg highlight}@{b}@{u}Default Alignment:@{ub}@{uu}@{fg text}
Numbers are right aligned, and strings are left aligned.

@{fg highlight}@{b}@{u}Left:@{ub}@{uu}@{fg text}
All cell text is left aligned.

@{fg highlight}@{b}@{u}Right:@{ub}@{uu}@{fg text}
All cell text is right aligned.

@{fg highlight}@{b}@{u}Centered:@{ub}@{uu}@{fg text}
All cell text is centered.

@{fg highlight}@{b}@{u}Numbers Alignment:@{ub}@{uu}@{fg text}
Normally, when showing numbers in the default mode, FinalCalc adds a
trailing space at the end of the number.  This makes numbers stay away from
the right edge of the column.  The Numbers Align mode applies the same
action to string cells, making them align with numeric cells instead of
using right alignment.
@endnode

@node part2.5.6 "Cell Format: Hide..."
@toc "part2.5"
@{b}@{u}Cell Format: Hide:@{ub}@{uu}

You can hide a cell from the display by turning on its Hide setting.  This
does not remove the cell, simply stops it from showing up in the display.
The only way to view it contents is to move the cursor to it, and see its
contents in the cell contents line.

This is a good way of hiding intermediate calculations from the display.
@endnode

@node part2.5.7 "Cell Format: Repeat..."
@toc "part2.5"
@{b}@{u}Cell Format: Repeat:@{ub}@{uu}

The Repeat setting makes FinalCalc repeat the contents of the cell as many
times as will fit in the cell's column.  Cell text repeat affects only
string cells.  It is not available for numeric cells.
@endnode

@node part2.5.8 "Cell Format: Style..."
@toc "part2.5"
@{b}@{u}Cell Format: Style:@{ub}@{uu}

Any cell's text can be set to bold, italic, underlined, reversed or shaded.

To set a cell's style, use the 'Format - Style' menu and select the style
you want.  For example, to set a cell to bold and italic, use 'Format -
Style - Bold' and then 'Format - Style - Italic'.  To clear all the cell
style use the 'Format - Style - Normal'.

The following are the style attributes allowed for a cell:

@{fg highlight}@{b} Bold: @{ub}@{fg text}
 The cell text is shown in bold.
@{fg highlight}@{i} Italic: @{ui}@{fg text}
 The cell text is shown in italics.
@{fg highlight} @{u}Underline:@{uu} @{fg text}
 Shows the cell text with an underline across it.
@{fg highlight} @{fg back}@{bg text}Reverse:@{fg text}@{bg back} 
 Shows the cell text in reverse colors.
@{fg highlight} Shaded:@{fg text}
 Shows the cell text with a light shaded background.  If the cell is also
 set to reverse, it will get a dark shaded background.

Attributes can be mixed, like @{b}@{i}bold/italic. @{ub}@{ui}

You can also use the Edit Cell Format requester (Amiga-F) and directly change
each style attribute.
@endnode

@node part2.5.9 "Cell Format: Color..."
@toc "part2.5"
@{b}@{u}Cell Format: Color:@{ub}@{uu}

A cell is normally shown as black text on a grey background.  You can, however,
set a cell to show in one of many other colors.  To set a cell's color, use the
'Format - Color' menu.  You will get a requester showing you a list of colors
to select from.

Normally, the cell color is set to 'default', which uses the currently defined
default cell text color.

The @{"screen" link "FinalCalc:guide/part8.guide/part8.1"} FinalCalc is running on must be capable of displaying at least 8
colors for cell colors to show up in the display.  If the screen has less
than 8 colors, the cell color is not shown.
@endnode

@node part2.5.10 "Cell Format: Font..."
@toc "part2.5"
@{b}@{u}Cell Format: Font:@{ub}@{uu}

Any text shown for a cell is normally shown in the default program font unless
you define a specific font for that cell.

You can set a cell to any system font of any size.  To set a cell's font, use
the 'Format - Font - Set' menu.  You will get the system font requester.
Select the font and size you want from it.

Once a cell's font is set, the row the cell is in will be expanded to fit the
new font if it is larger than the current height of the row.

To clear a cell's font and return it to the default program font, use the
'Format - Font - Clear' menu.

While FinalCalc is loading a font from disk, it shows a message that it is
doing so in the cell contents line.  This is normally too fast to be noticed,
but some system fonts (especially CGTimes, CGTriumvirate, and LetterGothic) can
take some time to build, so this message lets you know what is happening.

Note that if you share projects with other users or machines, you could select
fonts that do not exist on the other's system.  When FinalCalc loads a project,
it tests to see if the system contains all the fonts that the project requires.
If it cannot find a font, it will ask you whether you want to replace that font
with another one.  The font will also be tested against the Outline Fonts List.
@endnode

@node part2.5.11 "Cell Format: Comment..."
@toc "part2.5"
@{b}@{u}Cell Format: Comment:@{ub}@{uu}

You can attach a comment to a cell.  This serves no purpose other than a
reminder about the cell.  To set a comment (and to view it) use the 'Edit Cell
Format' requester and enter the comment in the Comment field.

The comment will also appear in the cell contents line, attached to the end
of the cell's contents.
@endnode

@node part2.5.12 "Cell Format: Protect..."
@toc "part2.5"
@{b}@{u}Cell Format: Protect:@{ub}@{uu}

You can protect a cell from being modified by setting its Protect status to on.
Simply use the 'Format - Protect - Yes' menu to protect the cell.

Once a cell is protected, if you try to edit it, paste over it, or otherwise
modify it, the display will flash and you will be informed that the cell is
protected.  The cell is not modified.

To unprotect the cell, use the 'Format - Protect - No' menu.

This is technically not a format setting, but is grouped with the format
settings for practical purposes.
@endnode

@node part2.5.13 "Format Tags..."
@toc "part2.5"
@{b}@{u}Format Tags:@{ub}@{uu}

A Format Tag is a collection of cell format settings that are defined as a
single object and are given a name.

Once a format tag has been defined, any cell can be attached to that tag and
its format will be a copy of the format settings defined in that tag.

The main benefit of using format tags is to allow changing the format of cells
of a similar type by simply changing the format tag itself, and not all the
cells in the project.

To define a Format Tag, use the 'Format - Tags - Edit' menu.  You will get
the 'Edit Format Tags' requester, which allows you to define, edit and delete
format tags.

Click on the 'New' button.  You will then get the 'Edit Format Tag' requester.
In it, you see all the basic @{"cell format" link 2.5.1} settings.  Simply select the settings
you want, give the tag a descriptive title, and click on 'Use' to define the
new format tag.

Once you have a format tag defined, you can then apply it to the current cell
(or the current range if it is active) by using the 'Format - Tag - Apply'
menu.  You will get a requester showing the list of currently defined format
tags.  Select the tag you want to apply, and click on 'Apply'.  The cell is
now attached to the selected format tag.

To detach a cell from the format tag it is attached to, simply use the
'Format - Tags - Clear' menu.  This clears the cell's attachment to any format
tags.

If you try to change a cell's format while it is attached to a format tag, the
cell's format will acquire a copy of that format tags settings, detach from its
format tag, and then change the requested format setting.

When deleting a format tag from the 'Edit Format Tags' requester, FinalCalc
will scan the project to see if any cells use that format tag.  If no cells use
it, it will be deleted immediately.  If there are cells that use it, you will
be informed of how many cells are using it, allowing you to confirm or cancel
the delete command.
@endnode

@node part2.5.14 "Empty Cells..."
@toc "part2.5"
@{b}@{u}Empty Cells:@{ub}@{uu}

When a cell has no contents, it can be in one of two states:

@{b}@{u}@{fg highlight}Clear cell:@{ub}@{uu}@{fg text}
A clear cell is a cell that does not exist.  It has not been allocated and has
no contents or format settings.

@{b}@{u}@{fg highlight}Empty cell:@{ub}@{uu}@{fg text}
An empty cell is a cell that actually exists, but has no contents.  It does,
however, have format settings.


Empty cells are important because you can define the format for empty cells and
have them ready to show up in the required format when you enter a number or a
string into them.  (for example in pre-defined templates)

Setting the format for any cell that has no contents automatically makes it an
empty cell, including protecting the cell.  Cells that had contents previously,
but were deleted, also become empty cells.

Empty cells are saved with the project and are loaded back, preserving their
format settings.  If you do not require that empty cells be saved with your
project (the main benefit is reducing the memory and disk usage), you have two
possible solutions:

@{b}@{u}@{fg highlight}Free Empty Cells:@{ub}@{uu}@{fg text}
   The Free Empty Cells function is called by the 'Actions - Free Empty Cells'
   menu.  It physically converts all empty cells to clear (unallocated) cells
   in the current sheet only. (not the entire project)

@{b}@{u}@{fg highlight}Save Empty Cells setting:@{ub}@{uu}@{fg text}
   You can instruct FinalCalc not to save empty cells when saving the project
   to disk by turning off the 'Save Empty Cells' option in the 'Project Save
   Preferences' requester, which is called by the 'Settings - Global - Project
   Save Preferences' menu.

Both the above methods do not apply to cells that are protected, are set to
reverse, or have a font set.
@endnode

@node part2.5.15 "Default Column Format..."
@toc "part2.5"
@{b}@{u}Default Column Format:@{ub}@{uu}

Whenever you change the format of a cell in a column, the next new (clear
unallocated) cell you enter in that column will default to the format of the
previous cell.

What this means is that every time a cell's format is changed by the user,
this format is stored as the default format for new cells in that column,
and whenever you use a new cell in that column, it will automatically get
that column's default format.
@endnode

@node part2.5.16 "Current Cell Format Indicator..."
@toc "part2.5"
@{b}@{u}Current Cell Format Indicator:@{ub}@{uu}

The current @{"cell contents line" link part2.3.1 40} shows a quick summary of the current cell's
format.

The cell contents line can show one or more of the following items:

a.	The current cell, shown as  "A1:"

b.	The current range, shown as "(C8:D15)"

c.	The cell numeric type, this shows up as follows:

	(xn) where x is the cell type, and n is an optional number that shows up if
	Fixed is on, and shows the number of decimals selected.

	x is one of the following:

		G	General
		S	Scientific
		%	Percent
		C	Currency
		D	Date (shows as D1, D2, D3, or D4)
		T	Time (shows as T1 or T2)
		B	Bool

d.	Hidden cell, shown as "(H)"

e.	Protected cell, shown as "(P)"

g.	The Format Tag the cell is set to, shown as "(Tag Name)"

f.	Empty cell, shown as "(empty cell)".
@endnode


@node part2.6 "Cell Editing Tools..."
@toc "Main"
@{b}@{u}
	Cell Editing Tools:
@{uu}@{fg highlight}
	@{" > " link part2.6.1} Cutting, Copying and Pasting Cells
	@{" > " link part2.6.2} Paste Settings
	@{" > " link part2.6.3} Loading and Saving Clips
	@{" > " link part2.6.9} Copying and Pasting using the System Clipboard
	@{" > " link part2.6.4} Blanking Cells
	@{" > " link part2.6.10} Inserting and Deleting Cells
	@{" > " link part2.6.5} Inserting and Deleting Rows and Columns
	@{" > " link part2.6.6} Moving a Range
	@{" > " link part2.6.7} Filling a range with numbers
	@{" > " link part2.6.8} Filling a range with dates				
@endnode


@node part2.6.1 "Cutting, Copying and Pasting Cells..."
@toc "part2.6"
@{b}@{u}Cutting, Copying and Pasting Cells:@{ub}@{uu}

You can cut, copy and paste cells in FinalCalc in a sheet, between sheets in a
project, or even between projects.

Cutting a cell or a range is removing the current cell or range and placing its
contents in a temporary place called the 'clip buffer'.

Once you have a clip in the clip buffer, you can then paste it back anywhere in
a project.

Copying is the same as cutting, except that it does not clear the source cell
or range, it just places a copy of it in the clip buffer.

If the clip buffer has previous contents when you cut or copy, its contents
will be replaced with the new clip.

@{b}@{u}@{fg highlight}Cutting:@{ub}@{uu}@{fg text}
To cut a cell use the 'Edit - Cut' menu (or Amiga-X hotkey).  If a range is
currently highlighted, that entire range will be cut.  The cells will be
removed from the sheet.

@{b}@{u}@{fg highlight}Copying:@{ub}@{uu}@{fg text}
To copy a cell or range, use the 'Edit - Copy' menu (or Amiga-C hotkey).
This will not effect the sheet.

@{b}@{u}@{fg highlight}Pasting:@{ub}@{uu}@{fg text}
This puts the contents of the clip buffer into the current sheet.  The way the
paste is done depends on the following:

1.	If the clip buffer contains a single cell:

	a.	If the sheet does not have a current range, a copy of the cell in the
		clip buffer is placed into the current cell.

	b.	If there is a range selected, a copy of the cell in the clip buffer
		is placed in every cell in the current range.

2.	If the clip buffer contains a range:

	a.	If the sheet does not have a current range, the range in the clip
		buffer is copied onto the sheet starting at the current cell.

	b.	If there is a range selected, the range in the clip buffer is copied
		onto the sheet.  If the range defined is more than twice as wide as
		the clip buffer and/or twice as tall as the clip buffer, multiple
		copies of the clip buffer will be pasted into the sheet.  If the
		range is smaller than the clip buffer the paste operation will only
		fill in as many cells as the range selected.
@endnode

@node part2.6.2 "Paste Settings..."
@toc "part2.6"
@{b}@{u}Paste Settings:@{ub}@{uu}

By default, when FinalCalc pastes a cell to the sheet during a Paste operation,
all of the cell's format and contents are pasted.  You can, however, control
exactly what is pasted by changing the paste settings.

The 'Edit - Paste - Settings' menu brings up the 'Edit Paste Settings'
requester, which allows control over the following paste settings:

@{b}@{fg highlight}Apply Format Tags:@{ub}@{fg text}
If turned off, the destination cell will not have its format tag changed.

@{b}@{fg highlight}Apply Text Style:@{ub}@{fg text}
If turned off, the destination cell will not have its text style changed.

@{b}@{fg highlight}Apply Text Font:@{ub}@{fg text}
If turned off, the destination cell will not have its font changed.

@{b}@{fg highlight}Apply Text Color:@{ub}@{fg text}
If turned off, the destination cell will not have its color changed.

@{b}@{fg highlight}Lines/Borders:@{ub}@{fg text}
If turned off, the destination cell will retain its lines and borders.

All the above settings default to being on, which copies the format in the
clip buffer to the destination cell.

The other settings in the Paste Settings requester affect how a formula is
pasted, and are discussed in the @{"Pasting A Formula" link "FinalCalc:guide/part3.guide/part3.1.8"} section.
@endnode

@node part2.6.3 "Loading and Saving Clips..."
@toc "part2.6"
@{b}@{u}Loading and Saving Clips:@{ub}@{uu}

You can save the current clip buffer to a file for future use.  To save the
current clip buffer, use the 'Edit - Clip - Save' menu.  You will get a file
requester asking for a name to save the clip under.

After that, at any time, you can use the 'Edit - Clip - Load' menu to load a
clip from file into the clip buffer.  Once a clip is loaded, you can then use
the Paste operation to paste it.
@endnode

@node part2.6.9 "Copying and Pasting using the System Clipboard..."
@toc "part2.6"
@{b}@{u}Copy to Clipboard:@{ub}@{uu}

The 'Edit-Copy-Copy to Clipboard' copies the current cell or range as text
to the sytem clipboard.

@{b}@{u}Paste from Clipboard:@{ub}@{uu}

The 'Edit-Paste-Paste from Clipboard' menu item pastes the system clipboard
contents starting at the current cell, and downwards as a single column.

Paste from Clipboard strips all ANSI/ISO escape sequences from the source
text so that they don't mess up the imported text.
@endnode

@node part2.6.4 "Blanking Cells..."
@toc "part2.6"
@{b}@{u}Blanking Cells:@{ub}@{uu}

You can blank a cell or a range from the current sheet.  This clears the cell's
contents, making it into an empty cell.

@{b}@{fg highlight}Blanking a cell:@{ub}@{fg text}
Use the 'Edit - Blank - Cell' menu, or the Delete key (if no range is
selected).

@{b}@{fg highlight}Blanking a range:@{ub}@{fg text}
Select a range and use the 'Edit - Blank - Range' menu, or the Delete key.

@{b}@{fg highlight}Blanking a column:@{ub}@{fg text}
Use the 'Edit - Blank - Column' menu.  This clears all the cells in the
current column.

@{b}@{fg highlight}Blanking a row:@{ub}@{fg text}
Use the 'Edit - Blank - Row' menu.  This clears all the cells in the current
row.


@{b}@{u}Blank Settings:@{ub}@{uu}

By default, blanking clears the cell completely, you can, however, control how
the Blank function operates from the 'Edit Blank Settings' requester, which is
accessible from the 'Edit - Blank - Settings' menu.

a.	Numeric Cells:
	If turned off, numeric cells are not blanked.

b.	String Cells:
	If turned off, string cells are not blanked.

c.	Formulas:
	If turned off, cells with formulas are not blanked.

d.	Borders:
	If turned off, lines and borders in cells are not blanked.

e.	Format Tags:
	If turned off, format tags are not cleared.

f.	Text Style:
	If turned off, text style (bold, italic, underlined, reverse and shaded) is
	not cleared.

g.	Text Color:
	If turned off, text color is not cleared.

You can use the above to selectively clear a specific part of the cell.  This
is most useful when applying it to a large range of cells.
@endnode

@node part2.6.10 "Inserting and Deleting Cells..."
@toc "part2.6"
@{b}@{u}Inserting and Deleting Cells:@{ub}@{uu}

You can insert or delete a cell or range in a sheet.  This moves all the cells
in the sheet after the selected cell or range.

@{b}@{u}@{fg highlight}Insert Cells and Shift Right:@{ub}@{uu}@{fg text}
The 'Edit - Insert - Cells and Shift Right' menu shifts the current cell or
range to the right and adjusts all references to it in the project.

@{b}@{u}@{fg highlight}Insert Cells and Shift Down:@{ub}@{uu}@{fg text}
The 'Edit - Insert - Cells and Shift Down' menu shifts the current cell or
range down and adjusts all references to it in the project.

@{b}@{u}@{fg highlight}Delete Cells and Shift Left:@{ub}@{uu}@{fg text}
The 'Edit - Delete - Cells and Shift Left' menu deletes the current cell or
range, and shifts all the cells to the right of it in its place.

@{b}@{u}@{fg highlight}Delete Cells and Shift Up:@{ub}@{uu}@{fg text}
The 'Edit - Delete - Cells and Shift Left' menu deletes the current cell or
range, and shifts all the cells below it in its place.
@endnode

@node part2.6.5 "Inserting and Deleting Rows and Columns..."
@toc "part2.6"
@{b}@{u}Inserting and Deleting Rows and Columns:@{ub}@{uu}

You can insert or delete one or more columns or rows in a sheet.  This moves
all the cells in the sheet after the selected row or column.

@{b}@{u}@{fg highlight}Insert Column(s):@{ub}@{uu}@{fg text}
To insert columns, use the 'Edit - Insert - Column' menu.  If there is no
range selected, a single column will be inserted at the current cell's
column.  If there was a range selected, multiple columns will be inserted
in the area the range covers.

@{b}@{u}@{fg highlight}Delete Column(s):@{ub}@{uu}@{fg text}
To delete columns, use the 'Edit - Delete - Column' menu.  If there is no
range selected, the column where the current cell is will be deleted.  If a
range was selected, all the columns in that range will be deleted.

@{b}@{u}@{fg highlight}Insert Row(s):@{ub}@{uu}@{fg text}
To insert rows, use the 'Edit - Insert - Row' menu.  If there is no range
selected, a single row will be inserted at the current cell's row.  If there
was a range selected, multiple rows will be inserted at in the area the
range covers.
  
@{b}@{u}@{fg highlight}Delete Row(s):@{ub}@{uu}@{fg text}
To delete rows, use the 'Edit - Delete - Row' menu.  If there is no range
selected, the row where the current cell is will be deleted.  If a range was
selected, all the rows in that range will be deleted.

You can use the Amiga-I (for Insert) and Amiga-D (for Delete) hotkeys.  These
bring up the keyboard menus directly at the sub-menu for Insert and Delete.
For example, to insert a column hit Amiga-I, and then 'C'.

FinalCalc performs a lot of @{"repair work" link "FinalCalc:guide/part3.guide/part3.1.10"} on formulas and range names after any
of these operations is performed.
@endnode

@node part2.6.6 "Moving a Range..."
@toc "part2.6"
@{b}@{u}Moving a Range:@{ub}@{uu}

To move a range of cells from one position in the sheet to another, use the
Move Range function.  The 'Edit - Move' menu (or Amiga-M hotkey) brings up the
'Move Range' requester.

In this requester, you have to define the range to move and the top left cell
of the destination.  Once you have defined those, use the 'Move' button to
perform the actual move.

FinalCalc performs a lot of @{"repair work" link "FinalCalc:guide/part3.guide/part3.1.10"} on formulas and range names after 
performing a Range Move.
@endnode

@node part2.6.7 "Filling a range with numbers..."
@toc "part2.6"
@{b}@{u}Filling a range with numbers:@{ub}@{uu}

FinalCalc's Fill Numbers tool allows you to quickly fill a range with
consecutive numbers.

First, select the range to fill in the sheet itself.  Then use the 'Edit -
Fill - Numbers' menu to bring up the 'Range Fill Numbers' requester which
controls how the fill numbers operation is done.

The requester comes up with the range to fill already filled in.  It also
shows the start value (default to 1), the end value (defaults to the number
of cells in the range), and the interval (defaults to 1).

For example, if the range is set to A1:A5, start value of 10, interval of
1, the fill will result in the values 10, 11, 12, 13, 14 in the cells A1,
A2, A3, A4 and A5.

The end value, if reached before the end of the range while filling, will
stop the fill operation.

The interval value defines the increment added between each step in the
fill.  For example, a start value of 1, and an interval of 3 will result in
the values 1, 4, 7, 10, and so on.
@endnode

@node part2.6.8 "Filling a range with dates..."
@toc "part2.6"
@{b}@{u}Filling a range with dates:@{ub}@{uu}

The Fill Dates tool fills in a range of cells with date numbers and sets the
cells to a date format.

First, select the range of cells to be filled with dates.  Then use the 'Edit -
Fill - Dates' menu to bring up the 'Range Fill Dates' requester.

The requester has several settings:

	@{b}@{u}@{fg highlight}Range to fill:@{ub}@{uu}@{fg text}
	This is the range of cells in the sheet to fill.  If you selected a range in
	the sheet before you called up the requester, that range will show up here.

	@{b}@{u}@{fg highlight}Start Date:@{ub}@{uu}@{fg text}
	The date to use as the first date in the first cell filled.  This defaults
	to "today", which is today's date.  You can enter any valid date string, as
	described in @{"Appendix 4" link "FinalCalc:guide/appendix4.guide/Main"}.

	@{b}@{u}@{fg highlight}End Date:@{ub}@{uu}@{fg text}
	This is empty by default.  If you enter a date string here, the fill will
	stop at this date if it gets to it before it has filled the entire range.
	This allows you to select a bigger range than you need, and just define the
	last date you want so you don't have to figure out how many cells you need
	exactly before you do the fill.

	@{b}@{u}@{fg highlight}Interval:@{ub}@{uu}@{fg text}
	The number of days, months, or years to add between each filled cell.  This
	defaults to 1 day, no months or years.  You can use combinations of day,
	month and year intervals.

	@{b}@{u}@{fg highlight}Date Format:@{ub}@{uu}@{fg text}
	This is a number from 1 to 4 which matches Date 1 to Date 4 format.  The
	cells are set to this format after they are filled in if they are not
	already set to a date format.

Once you have entered the settings you like, hit the Fill button to perform the
date fill operation.
@endnode

@node part2.7 "Lines and Borders..."
@toc "Main"
@{b}@{u}Lines and Borders:@{ub}@{uu}

FinalCalc can draw lines around the edges of cells in the sheet display.  The
lines can be individually controlled on and off for each of the four sides of
the cell.  Each line can be a thin (single) or thick (double) line.

The Actions menu has several items that control settings and clearing these
lines around cells.

	@{b}@{u}@{fg highlight}Actions - Borders menu:@{ub}@{uu}@{fg text}
	The Actions - Borders menu draws a single or a double border around the
	current cell or the current range.  

	@{b}@{u}@{fg highlight}Actions - Lines menu:@{ub}@{uu}@{fg text}
	The Actions - Lines menu draws a single line at the top, bottom, left or
	right side of the current cell or the cells in the current range.

	@{b}@{u}@{fg highlight}Actions - Double Lines menu:@{ub}@{uu}@{fg text}
	The Actions - Lines menu draws a double line at the top, bottom, left or
	right side of the current cell or the cells in the current range.

	@{b}@{u}@{fg highlight}Actions - Clear Lines/Borders menu:@{ub}@{uu}@{fg text}
	The Actions - Clear Lines/Borders menu clears all lines and borders from
	the current cell or the cells in the current range, or selectively clears
	only the top, bottom, left or right lines.

	@{b}@{u}@{fg highlight}Actions - Clean up lines/borders menu:@{ub}@{uu}@{fg text}
	The Actions - Clean up lines/borders menu looks at the current cell (or all
	cells in the current range) and sees if its lines/borders are duplicated in
	the adjacent cells, and if so, it will clean up the lines/borders to remove
	the duplicates.

	@{b}@{u}@{fg highlight}Actions - Grid:@{ub}@{uu}@{fg text}
	Draws a grid around the current range.  The grid is a border around the
	range, and top and right lines in all cells, making the range look like a
	table.

Line/border drawing is an additive process.  Cells collect the lines that
get drawn into them and show them as requested.  If you define both a
single and a double line in the same position, the double line will
override the single line.

An example of the additive process is to select a range, and then use the
'Actions - Grid' menu, and then 'Actions - Borders - Double'.  This will
build a table grid with a double border around it.
@endnode


@node part2.8 "The Undo and Redo System..."
@toc "Main"
@{b}@{u}The Undo and Redo System:@{ub}@{uu}

FinalCalc keeps tracks of all the changes you make to a project's data and
allows you to undo any changes made up to the first change since you loaded
the project or started the project.

The changes indicator is a small box at the bottom right of a sheet view.  It
shows the number of changes made to the project since it was loaded, started
or since it was last saved.

To undo a change to the project, use the 'Edit - Undo - Undo' menu, or the
Amiga-U hotkey.  FinalCalc will undo the last change you did to the project,
repair any damage to the project's data, start recalculating the project, and
decrement the changes indicator count.

Once you have undone a change, you can redo that change by using the 'Edit -
Undo - Redo' menu or the Alt-U hotkey.  This will redo the change you last
undid.

You can undo as many times as you like, to the first change you made to the
project.  You can also redo any changes you have undone as long as you have
not made any new changes to the project, for as soon as you make a change to
the project, all redos from that point become invalid and are lost.

When you have no more undos or redos to do, the display will flash when you
attempt to undo or redo, and a message will come up informing you of that.

If you try to undo or redo an event that was done on another sheet in the
project, you will be informed of that and asked whether you want to go ahead.

Whenever you save the project to disk, the changes indicator is automatically
reset to 0.  The undo events are not lost, and you can still undo, but the
changes indicator will show a negative count, telling you that you are 'before'
the state the project was in when it was last saved.


@{b}@{u}@{fg highlight}Types of events stored:@{ub}@{uu}@{fg text}
FinalCalc stores many types of changes to the project's data.  These include:

     1. Editing a Cell
     2. Deleting Columns and Rows
     3. Inserting Columns and Rows
     4. Moving a Range
     5. Blanking a Cell, Range, Column or Row
     6. Changing a column's width
     7. Cutting a cell
     8. Pasting 
     9. Drawing and Clearing Lines and Borders
    10. Removing Formulas
    11. Changing a cell's format (including font)
    12. Filling Numbers and Dates
    13. Sorting a Range
    14. Freeing Empty Cells
    15. Editing a Cell's Comment
    16. Search & Replace

@{b}@{u}@{fg highlight}View Undo Events List:@{ub}@{uu}@{fg text}
The 'Edit - Undo - View List' menu brings up the 'Undo/Redo Events List'
requester.  This lists the current undo and redo events list in detail.  The
current undo event is highlighted and information about the event is shown in
the details box.  Events after it are redo events (if they exist).  You can
move around through the entire undo/redo list and see what actions are in the
list and what each did (or would do to the project when undone or redone).

This has two main benefits.  It allows you to view what the next undo or redo
will do, and shows you a history of the changes you made to the project.

If an event was done via a script command, it will have "(rexx)" shown.  This
includes events caused by the panel icons, as they call script commands.

@{b}@{u}@{fg highlight}Enabling and Disabling the Undo System:@{ub}@{uu}@{fg text}
When FinalCalc starts a new project, it always has the Undo system enabled for
it.  You can turn off the Undo system at any time by using the 'Edit - Undo -
Disable' menu.  The changes indicator will no longer show the number of changes
made to the project, but will simply show 'Changed' when changes have been made
to the project.

The benefits of turning the Undo system off are slightly faster program
operation in large scale actions, and lower memory usage.

If FinalCalc runs out of system memory, it will automatically turn off the Undo
system, freeing its memory for other uses.  It will inform you of that.

You can re-enable the Undo system at any time by using the 'Edit - Undo -
Enable' menu.

@{b}@{u}@{fg highlight}Undoing All Changes:@{ub}@{uu}@{fg text}
The 'Edit - Undo - Undo All Changes' menu undoes all changes to the current
project until the changes count returns to 0.  You will be asked to confirm
this before the operation is done.

The main difference between this and doing Undo many times is that it is a lot
quicker.
@endnode


@node part2.9 "The Filing System..."
@toc "Main"
@{b}@{u}
	The Filing System:
@{uu}@{fg highlight}
	@{" > " link part2.9.1} Project Save Settings
	@{" > " link part2.9.2} Program File Paths
	@{" > " link part2.9.3} Default Startup Project
	@{" > " link part2.9.4} Project User Menus
	@{" > " link part2.9.5} File Encryption
	@{" > " link part2.9.6} Compare Projects
	@{" > " link part2.9.7} Sharing files with other spreadsheets
@endnode

@node part2.9.1 "Project Save Settings..."
@toc "part2.9"
@{b}@{u}Project Save Settings:@{ub}@{uu}

When saving a file, FinalCalc looks at the project save settings defined in the
'Project Save Preferences' requester to decide how to save the project.

To get to this requester, use the 'Settings - Global - Project Save Preferences'
menu.  It controls the following settings:

@{b}@{u}@{fg highlight}Revision Control:@{ub}@{uu}@{fg text}
Revision Control allows you to keep the last several revisions of a project
on disk.  To set the option you have to select the number of revisions you
to have have for projects.

For example, if you set revisions to 3 and save a project name "test.sheet",
FinalCalc does the following when you save the project:

1. delete test.sheet_003 if it exists
2. rename test.sheet_002 to test_003.sheet
3. rename test.sheet_001 to test.sheet_002
4. rename test.sheet to test.sheet_001
5. save the project as test.sheet

If any error occurs during this process you will not be warned unless it
involves the last step, which saves the current version.

The maximum number of revisions allowed is 999.

@{b}@{u}@{fg highlight}Auto Save:@{ub}@{uu}@{fg text}
Auto Save allows you to set a number of minutes after which FinalCalc will
remind you to save the project if it has been changed.  Once the timer
triggers, FinalCalc will put up a requester asking you whether you want to
save the project.  If you reply yes, the project is automatically saved for
you.  After that, the timer is reset and starts again.

You can tell FinalCalc to just save the project without asking by turning
off the 'Confirm Auto Save' setting.

The maximum number of minutes allowed is 999.

AutoSave only works if you're using FinalCalc.  If you go to another program
or screen it will not nag you untill you get back to FinalCalc (i.e.
activate a window that belongs to FinalCalc).

@{b}@{u}@{fg highlight}Confirm Deletes:@{ub}@{uu}@{fg text}
This defaults to being on, which means that every time FinalCalc tries to
overwrite a project on disk it will ask you to confirm it first.

Note that selecting the Revision Control option disables this option.

@{b}@{u}@{fg highlight}Generate Icons:@{ub}@{uu}@{fg text}
FinalCalc generates a Workbench icon for each project it saves.  If you turn
this option off, no icons will be generated.

@{b}@{u}@{fg highlight}Append .sheet to file:@{ub}@{uu}@{fg text}
By default, FinalCalc always appends ".sheet" to project names when saving
them to disk if they do not already have that extension.  You can stop this
from happening if you turn this option off.

Note that this does not affect loading a project, where FinalCalc always
looks for a ".sheet" extension if it cannot find the original name
specified.

@{b}@{u}@{fg highlight}Save Printer Settings:@{ub}@{uu}@{fg text}
By default, FinalCalc saves all information about the current printer with
a project.  This is useful for setting different printer settings for each
project.  You can, however, tell FinalCalc not to save printer settings by
turning off the 'Save Printer Settings' option, in which case all
information about the current printer setting (printer type, color mode,
number of copies, destination port, etc.) is not saved with the project.
This allows other users to load the saved project without it affecting their
printer settings.  This is recomended for projects intended to be shared
with others.

@{b}@{u}@{fg highlight}Save View Settings:@{ub}@{uu}@{fg text}
This defaults to on.  If it is turned off, view details (number of views,
their types, positions and sizes) will not be saved.  When loading a project
that was saved with no view details, a sheet view will be opened
automatically on sheet A with the default view settings.

@{b}@{u}@{fg highlight}Save Empty Cells:@{ub}@{uu}@{fg text}
You can instruct FinalCalc not to save @{"empty cells" link part2.5.14} when saving a project
by turning off this setting.

@{b}@{u}@{fg highlight}Save Numeric Results:@{ub}@{uu}@{fg text}
When FinalCalc saves a cell with a formula, it saves both the formula and
its current result.  If you turn off the 'Save Numeric Results' option,
numeric formula results will not be saved with the project.

The main benefit of this is to reduce the file size.  (The exact saving
is 8 bytes for each numeric formula.)

Each cell saved without its numeric result is marked so that it gets
recaulated when the project is loaded to figure out its original value.

@{b}@{u}@{fg highlight}Save String Results:@{ub}@{uu}@{fg text}
This is the same as Save Numeric Results above, but applies to formulas
that have a string result.  If this option is turned off, formula string
results will not be saved with the project.

@{b}@{u}@{fg highlight}Backup Path:@{ub}@{uu}@{fg text}
The Backup Path is an optional path to a storage device on your system.  If
you specify a backup path, every time FinalCalc saves a project, it will
deposit a copy of that file in the backup path.

FinalCalc copies the saved project to the backup path in the background, so
you may notice that disk activity is continuing even after the project save
was done.  This does not affect you, so you can continue to use FinalCalc
even while this is happening.


All the settings in the 'Project Save Preferences' can be permanently saved so
that they are used in future FinalCalc settings by using the 'Settings - Global -
Save Settings' menu.
@endnode

@node part2.9.2 "Program File Paths..."
@toc "part2.9"
@{b}@{u}Program File Paths:@{ub}@{uu}

You can tell FinalCalc where to find different kinds of user files on your
system.  The 'Settings - Global - Paths' menu brings up the 'Edit Paths for
Program Files' requester, which allows you to define paths for the following
objects:

	@{b}@{u}@{fg highlight}Default:@{ub}@{uu}@{fg text}
	The default path for all user objects.  If any of the remaining paths is not
	defined, it will use this one.

	@{b}@{u}@{fg highlight}Project:@{ub}@{uu}@{fg text}
	Default path for FinalCalc Project files.

	@{b}@{u}@{fg highlight}Single Sheets:@{ub}@{uu}@{fg text}
	Default path for single sheet save and load files.

	@{b}@{u}@{fg highlight}Print Output:@{ub}@{uu}@{fg text}
	Default output path for printing to a file.

	@{b}@{u}@{fg highlight}Clips Load/Save@{ub}@{uu}@{fg text}
	Default path for loading and saving clips.

	@{b}@{u}@{fg highlight}Macros & Recorder:@{ub}@{uu}@{fg text}
	The default path for Scripts, Macros and Recorder output.

	@{b}@{u}@{fg highlight}Import/Export Text:@{ub}@{uu}@{fg text}
	The default path for text import and export.

When FinalCalc brings up the file requester for one of the above objects, it
will default to showing the path you defined for it unless that object has
already been loaded or saved to a different path.
@endnode

@node part2.9.3 "Default Startup Project..."
@toc "part2.9"
@{b}@{u}Default Startup Project:@{ub}@{uu}

If you define a default startup project in the 'Edit Paths for Program Files'
requester, FinalCalc will look for that project when it first starts up, and
if it finds it, it will automatically load it.

If the defined Startup Project file name provided has a path, Final Calc
attempts to directly access it.  If it has no path, FinalCalc looks for
it in the Default Projects path.
@endnode

@node part2.9.4 "Project User Menus..."
@toc "part2.9"
@{b}@{u}Project User Menus:@{ub}@{uu}

Project User Menus are menus defined by the user for a specific project.
They are attached to the end of the FinalCalc menus.

To define project user menus, you must first generate a User Menus File, which
is a standard text file that contains a description of the menus, their
shortcuts, and what each menu does.

For a description of the User Menus format see the section on Program User
Menus.  Project menus differ from Program menus in that they belong to a
specific project, while Program menus are global and show up for all projects.
If you define both Project and Program user menus, both will show up.

To attach user menus to a project, use the 'Settings - Project - User Menus'
menu and select the file that contains the user menus for the current project.

When switching from a project to another, FinalCalc will change the menus
to show the current project's user menus.
@endnode

@node part2.9.5 "File Encryption..."
@toc "part2.9"
@{b}@{u}File Encryption:@{ub}@{uu}

FinalCalc can save projects to disk in a secure encrypted format.  A project
saved in this way cannot be loaded by FinalCalc or decoded by any external
means (without a major effort).

To save an encrypted project, use the 'Project - Project - Save With Password'
menu.  This will bring up the file requester.  Select the file name to save to.
You will be then asked to enter a password to encrypt the file with.

Enter a password of at least 6 or more characters.  There is no significant
increase in security for passwords longer than 15 characters.

To load an encrypted project, simply load or open it as usual.  When FinalCalc
detects that it is encrypted, it will ask you for the password to decode it.
This must be identical to the password you used to save it, otherwise the
decryption will fail and FinalCalc will complain.

If you lose your password, the file cannot be decoded as the password is
physically used to encrypt the project's contents.  Even Softwood cannot
decode a file without its password.
@endnode

@node part2.9.6 "Compare Projects..."
@toc "part2.9"
@{b}@{u}Compare Projects:@{ub}@{uu}

You can compare the current project to a project on disk.  The 'Project -
Project - Compare' menu asks for you a file to compare with, and it will
then generate a report that shows the differences between the current project
and the project on disk.  The comparison report is only done on the contents
of the cells, and not their formats.

A good use for this feature is to quickly see the changes you have done
to a sheet since you last saved it or loaded it.

The report is kept in temporary storage as long as FinalCalc is still running.
You can access previous reports by using the 'Tools - View Previous Reports'
menu.  This brings up a list of all stored reports allowing you to select the
report to view.
@endnode

@node part2.9.7 "Sharing files with other spreadsheets..."
@toc "part2.9"
@{b}@{u}Sharing files with other spreadsheets:@{ub}@{uu}

FinalCalc supports loading Lotus 1-2-3 .WK1 and .WKS files as well as Maxiplan,
ProCalc, Gold Disk Office and Advantage (1.1 or above) spreadsheet files.  To
load any of these formats, simply use 'Project - Load' or 'Project - Open' as
usual.  FinalCalc automatically recognizes these formats and loads them.

@{b}@{u}@{fg highlight}Loading ProCalc, Advantage and Gold Disk Office Files:@{ub}@{uu}@{fg text}

FinalCalc detects and imports the FAFF file format, which is used by ProCalc,
Advantage (1.1 and above), and Gold Disk Office.

The modules handles both cell and formula contents, and styles.  Style tags,
fonts and colors are loaded and converted into FinalCalc styles.

Database input and criteria ranges are imported correctly.   All database
criteria cells are converted into a format usuable by FinalCalc.  ("FIELD"
is added to them, so a criteria of ">11" becomes "FIELD>11").  Database
formula functions are also converted.

@{b}@{u}@{fg highlight}Saving .WK1 Files:@{ub}@{uu}@{fg text}

FinalCalc also saves .WK1 files.  To do that, use the 'Project - Save As 1-2-3'
menu.  A file requester will come up allowing to select where to save the file
and under what name.

Due to differences between FinalCalc projects and Lotus .WK1 sheets, there are
several limitations when saving to a .WK1 file:

-	Only the current sheet is saved, not all sheets in the project since .WK1
	doesn't support multiple sheets.

-	If a formula contains FinalCalc functions that are not compatible with
	the 1-2-3 format, the formula will be saved as a string cell so that
	you can edit it later in the destination spreadsheet.

-	Date/time cells are saved as date/time cells, but in the default
	1-2-3 format.  (since .WK1 doesn't support custom formats).

-	.WK1 only supports cells up to IV8192.  Any cells beyond that are not saved.

-	Saving a sheet as a 1-2-3 does not affect the 'changed' status of the
	project.  This is because of the above limitations, so that the user knows
	that the entire project was not saved.

-	Range names are trimmed to 15 characters, according to 1-2-3 requirements.

-	Cell styles, colors and fonts are not saved.

-	Date cells are converted from FinalCalc date numbers to Lotus date numbers.
	This is only applied if the cell is marked as Date and is not a formula.
	i.e. formulas that use fixed date numbers will not be corrected.
@endnode

@node part2.10 "The Help System..."
@toc "Main"
@{b}@{u}The Help System:@{ub}@{uu}

FinalCalc's help system uses the Amiga's AmigaGuide help system.  The help
documents are shown as hypertext files with keywords that link it to other
documents.

There are several entries into the help system:

	@{b}@{u}@{fg highlight}The main entrance:@{ub}@{uu}@{fg text}
	The 'Tools - Help Guide' menu (or hitting the Help key in a sheet view)
	brings up the main index page of the help document.  From there you can
	navigate to find any subject you like.

	@{b}@{u}@{fg highlight}Menu help:@{ub}@{uu}@{fg text}
	You can get help on any menu item by selecting that menu item with the mouse
	and hitting the Help key while that menu item is highlighted.  You will get
	information on that menu item.

	@{b}@{u}@{fg highlight}Keyboard Menu help:@{ub}@{uu}@{fg text}
	When you are using the @{"keyboard menus" link part2.3.5}, you can get help on the currently
	highlighted menu item by hitting the Help key.

	@{b}@{u}@{fg highlight}Requester help:@{ub}@{uu}@{fg text}
	When any requester is up, you can hit the Help key (or the requester's Help
	button) to access specific help on that requester.

	@{b}@{u}@{fg highlight}Formula Function help:@{ub}@{uu}@{fg text}
	When editing a formula, hitting the Amiga-H key brings up information on
	the currently highlighted @{"function" link "FinalCalc:guide/part3.guide/part3.2" 76}.

When FinalCalc first runs, it calls up the AmigaGuide system to get it ready
for use and to make sure it exists.  If the AmigaGuide system is not installed
in your system, FinalCalc will complain about it whenever you try to access the
help system.

It is also possible that AmigaGuide decides to shut itself down due to memory
shortage (or any other reason).  If this occurs, FinalCalc will warn you that
AmigaGuide has shut down and will no longer be available for the current
session.
@endnode



@node part2.11 "Requesters..."
@toc "Main"
@{b}@{u}
	Requesters:
@{uu}@{fg highlight}
	@{" > " link part2.11.1} What is a requester?
	@{" > " link part2.11.2} Requester Gadgets
	@{" > " link part2.11.3} Requester Menus
	@{" > " link part2.11.4} Load/Save Requester Contents
	@{" > " link part2.11.5} Copy/Paste Requester Contents
@endnode


@node part2.11.1 "What is a requester..."
@toc "part2.11"
@{b}@{u}What is a requester:@{ub}@{uu}

A requester is a window opened by FinalCalc that is used to get user input.
It is normally called by a sheet or graph view or another requester.

A requesters is generally made up of 'gadgets' which are objects in the window
that interact with the user like buttons and sliders.

Most FinalCalc requesters, if called from a sheet view, do not block input into
the sheet view that called them.  This is useful when you want to move around
the project to find a range or cell to paste into a requester.

This allows multiple requesters can be open at any time, all those requesters
will accept input and work normally as long as a requester is not specifically
blocked by a requester it called.

If you close down a project, all requesters that were called up from that
project will be automatically closed down as well.
@endnode

@node part2.11.2 "Requester Gadgets..."
@toc "part2.11"
@{b}@{u}Requester Gadgets:@{ub}@{uu}

A requester can have many types of gadgets.  Each gadget can have a hotkey
attached to it.  The hotkey is a letter in the gadget's title underlined with
a small line.  Hitting the hotkey activates the gadget or triggers it.

The following is a list of gadgets that are used in requesters:


@{b}@{u}@{fg highlight}Buttons:@{ub}@{uu}@{fg text}
A button is simple gadget that does an action if pushed.  These normally do
an action.  The following are standard buttons that show up in many
requesters:

	Reset Button:
	Resets all gadgets in the requester to their original status (when the
	requester first came up).

	Cancel Button:
	Aborts all changes and exits the requester.  Hitting the Escape key does
	the same thing.

	Help Button:
	Brings up specific help on the current requester.

@{b}@{u}@{fg highlight}Checkmark:@{ub}@{uu}@{fg text}
This is a small box that can have a checkmark in it.  It can be toggled
between being on (checkmark) and off (no checkmark).

@{b}@{u}@{fg highlight}Radio:@{ub}@{uu}@{fg text}
Radio gadgets are a set of related gadgets in which only one of that set
can be selected at any time.  Selecting any radio gadget from a group
de-selects all the other gadgets in that group.

@{b}@{u}@{fg highlight}Sliders:@{ub}@{uu}@{fg text}
A slider is a horizontal or a vertical slider gadget that can be set to a value
from a possible range of values.  The hotkey for a gadget, when hit, increases
the value of the slider by one.  Holding the shift key with the hotkey reduces
the value of the slider by one step.  The alt-hotkey combination moves the
slider to the maximum value, and the alt-shift-hotkey combination moves the
slider to the minimum value.

@{b}@{u}@{fg highlight}List:@{ub}@{uu}@{fg text}
A list gadget is a box that has multiple lines showing multiple entries.
It can show more entries than the box can hold by scrolling up and down.

You can select an entry in a list gadget by clicking on it, or using the
cursor up and down keys to select the entry before or after the current
one.  The shift-cursor keys move up and down one page at a time, and the
alt-cursor keys move to the top and bottom of the list.

Some requesters also accept a double-click on a list gadget entry to be the
same as selecting that entry and exiting the requester successfully.

@{b}@{u}@{fg highlight}String:@{ub}@{uu}@{fg text}
A string gadget holds any text string.  Hitting the hotkey for that gadget
activates the gadget, allowing you to type in it.  Hit the return key to
enter the value and de-activate the gadget.

String gadgets can be stringed together as related items.  With stringed
gadgets, hitting enter or enter in one gadget activates the next one and so on.

String gadget can be of a specific type.  These are marked by a [?] gadget
next to the gadget.  Hitting the [?] button fills in the string gadget with
a different string depending on the gadget's specific type.  You can also
directly trigger the [?] gadget from the keyboard by using the alt keys
with the gadget's hotkey.

The following is a list of the specific string gadget types and what the [?]
gadget does for each type:

	Cell:
	Pastes the current cell (e.g. A1)

	Range:
	Brings up a list showing the current range, and all	range names in the
	current project. (e.g. A1:B10)

	3D Range:
	Same as Range above, but pastes a full 3D range name. (e.g. A_B10:B_C20)

	Date String:
	Brings up a requester that allows you to paste a Date String.

	Date Format:
	Brings up a requester that allows you to paste a Date Format string.
			
	Time Format:
	Brings up a requester that allows you to paste a Date Format string.

	Graph:
	Brings up a requester showing all graphs defined in the current project.

	Amiga Font:
	Brings up the system font requester, allowing you to select a font and
	its size.

	Outline Font:
	Brings up a list of all outline fonts in the system, allowing you to select
	one.

	Header/Footer String:
	Brings up a requester that allows you to paste a Print Job Header/Footer
	string.

	Graph Title String:
	Brings up a requester that allows you to paste a Graph Title string.

	File name:
	Brings up the file requester, allowing you to select a file name.

	Directory:
	Brings up the file requester, allowing you to select a directory.

	Color:
	Brings up a list of colors to select from.

	Graph Color:
	Brings up the Graph Colors List, allowing you to select a Graph Color.

	Graph Pattern:
	Brings up the Graph Patterns List, allowing you to select a Graph Pattern.

	Graph Symbol:
	Brings up the Graph Symbols List, allowing you to select a Graph Symbol.

	Sheet:
	Brings up a requester listing all active sheets in the current project,
	allowing you to select one.

Some string gadgets also have a second gadget attached after the [?]
gadget.  This can be triggered by clicking on it or using the control key
with the gadget's hotkey.


@{b}@{u}@{fg highlight}String Gadgets Activation:@{ub}@{uu}@{fg text}

When a string gadget is active, some keyboard keys perform special actions:

Enter or Return key:
Enters the new value into the string gadget, and activates the next gadget
tied to the current one, if there is one.   Some string gadgets will also
affect other gadgets' status when you hit Enter.

Tab key:
Hitting the Tab key activates the next string gadget if it exists.  This
is the same as hitting Return, except that it looks for any string gadget,
not one that is tied to the current one.  The Tab key does not actually
simulate hitting Return unless the value of the string gadget was changed.
Hitting the Shift-Tab key activates the previous string gadget, if it
exists.

Escape key:
Hitting the Escape key simply deactivates the string gadget.

Help key:
Hitting the Help key deactivates the string gadget and calls the online
help for the current requester.

Amiga-? key:
If the active string gadget has a [?] gadget, hitting Amiga-? (or Amiga-/)
will trigger the [?] gadget and reactivate the string gadget when done.
The same is done for [+] (Amiga-+) and [e] gadgets (Amiga-e).
@endnode

@node part2.11.3 "Requester Menus..."
@toc "part2.11"
@{b}@{u}Requester Menus:@{ub}@{uu}

Most requesters have menus.  What these menus contain depends on the requester,
but in general, they look like this:

@{b}@{u}@{fg highlight}File Menu:@{ub}@{uu}@{fg text}
Allows you to @{"save and load" link part2.11.4} the requester contents to a file.

@{b}@{u}@{fg highlight}Edit Menu:@{ub}@{uu}@{fg text}
The 'Reset Contents' menu resets all gadgets in the requester to their original
status (when the requester first came up).

The 'Copy Contents' and 'Paste Contents' menus allow you to @{"copy and paste" link part2.11.5} the
requester contents.

@{b}@{u}@{fg highlight}Help Menu:@{ub}@{uu}@{fg text}
The Help menu brings up specific help on the current requester.
@endnode

@node part2.11.4 "Save/Load Requester Contents..."
@toc "part2.11"
@{b}@{u}Save/Load Requester Contents:@{ub}@{uu}

If a requester has the 'File' menu, you can use the 'File - Save Contents' menu
to save a copy of a requester's contents to a file.  Then, at any time after
that, you can load those contents back from the file to the same requester
using the 'File - Load Contents' menu.

Each requester saves its contents in its own format, and adds its own extension
to the filename.  For example, the Search requester uses an extension of 
"#?.search".

The file requester is brought up when saving and loading requester contents,
and the correct wildcard is set to show only files that apply to the current
requester type.  After you select the file name, the display is flashed to
confirm that the action was successful.

By default, these files are stored in a directory named "FinalCalc:Config"
@endnode

@node part2.11.5 "Copy/Paste Requester Contents..."
@toc "part2.11"
@{b}@{u}Copy/Paste Requester Contents:@{ub}@{uu}

If a requester has the 'Edit - Copy Contents' and 'Edit - Paste Contents'
menus, you can use those to copy the contents of the requester into a temporary
buffer, and then paste them back at any time to the same requester.

Each requester has its own buffer, so you can use Copy and Paste Contents on
many different types of requesters at the same time.

If the Copy or Paste action is successful, the display is flashed.
@next "FinalCalc:guide/part3.guide/Main"
@endnode