Demo/TableCalc/!iSVManual/Manual

Home » Archimedes archive » Archimedes World » AW-1995-06_Disc2.adf » June95_2 » Demo/TableCalc/!iSVManual/Manual

This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.

Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.

Tape/disk:	Home » Archimedes archive » Archimedes World » AW-1995-06_Disc2.adf » June95_2
Filename:	Demo/TableCalc/!iSVManual/Manual
Read OK:	✔
File size:	38E0 bytes
Load address:	0000
Exec address:	0000

TableCalc Demo Version
This is a demo version of Tablecalc. It has all the 
features of the real version except that it cannot 
save or print files. Tablecalc costs �31.50 including
carriage.
iSV Products
86 Turnberry
Home Farm, Bracknell
Berks RG12 8ZH
Tel 01344 55769

About TableCalc 
TableCalc is a sophisticated table generating
program for Acorn RISC OS computers with RISC OS
3.1 or later. As well as simple tables, it allows
the creation of spreadsheets, in which a range of
calculation can be carried out on figures.

Installing TableCalc 
TableCalc can be installed on a hard disc by
dragging the !TableCalc application to a directory
viewer. Floppy disc users should make a backup
copy of the TableCalc master disc for personal
use.

Interactive help
When you are running TableCalc, many helpful
messages are available. To view them, run the
!Help application from the Apps folder. Now,
whenever you point at any of TableCalc's windows
or menus, a message will be displayed in the Help
window.

Creating a table
TableCalc can be loaded in the normal way, by
double-clicking on its icon in a directory viewer.
Once TableCalc is loaded, a new table can be
created by clicking on its icon bar icon. Table
files can be loaded by double-clicking, or by
dragging them to the TableCalc icon.

Building tables
Most TableCalc editing functions rely on the
position of the caret. This is a red vertical bar.
When the caret is positioned within a table,
text which is entered from the keyboard is
inserted at the caret. When the caret is
positioned in a slot on the last row of a table,
pressing <RETURN> adds a new row at the bottom of
the table. Similarly, <TAB> can be used to add
columns to the right hand side of the table.

Editing text
Text is entered into a slot by positioning the
caret in the slot, then typing from the keyboard.
If you type more text than can be held by the
slot, the slot is extended downwards,
word-wrapping the text appropriately. If you type
a word which is too long to fit on one line, the
width of the column is increased. A single
character can be deleted by pressing the <DELETE>
key. A complete slot can be cleared by pressing
MENU and selecting the "Slots->Clear" item.
The tool bar
Attached to the top of each TableCalc window is a
tool bar allowing certain important operations to
be performed very quickly. A diagram showing the
functions of each of the buttons is included on
the quick reference card, which can be printed
using the !QuickRefs application, supplied on the
TableCalc master disc.

Adding rows and columns 
A row can be added after the row on which the
caret is positioned by pressing MENU and choosing
the "Grid->Add row" item. If, instead of clicking
on "Add row", you move the pointer to the right, a
submenu is displayed, allowing you to add a row
before or after the current row. The "Add column"
item works in exactly the same way. 

Deleting rows and columns
A row or column can be deleted by positioning the
caret, then using the "Grid->Delete Row" or
"Grid->Delete Column" item. A dialog box will
appear requesting confirmation. Click on the YES
button to perform the deletion. If you find this
annoying, you can turn it off. See the section on
global choices.

Column widths
The width of any column within the table can be
adjusted by pointing at a line separating columns,
and dragging with SELECT. When you point at a line
which can be dragged, the shape of the mouse
pointer changes. A column width can be set
automatically to the minimum width needed to
accomodate all the text without using word wrapby
double-clicking SELECT over a column boundary.

Selecting a block
Certain TableCalc operations require a block of
slots to work on. Other operations which work on
single slots can also be applied to all the slots
in a specified block. The easiest way to specify a
block is to drag select from one corner of the
desired region to the diagonally opposite corner.
Alternatively, position the caret in one corner,
then click ADJUST in the other. Either way, the
selected block is show in inverse video.

Keyboard short cuts
Almost all TableCalc operations which are normally
performed from menus can also be performed from
the keyboard. The keyboard short cuts are all
shown on the menus. The !QuickRefs application can
be used to print a quick reference card, which
includes a complete listing of all short cuts.

TableCalc styles
The appearance of text in slots is controlled by a
system of styles. Styles are controlled from the
style browser, which is accessed by pressing menu
and selecting the "Styles..." item (Ignore the
arrow symbol). This opens a window showing an
example of each available style. Each table has
its own set of styles, and its own style browser.
To apply a style to a slot, position the caret,
then double-click SELECT over the desired style.
Styles can be applied to blocks in the same way.
Editing a style 
A style can be edited from the style browser by
double-clicking ADJUST over a style's entry. This
opens a window allowing all the style's attributes
to be altered. Style attributes are divided into
four groups. In all styles (except the normal
style) each group can be turned on and off. When a
group is turned off, the default values from the
normal style are used instead. The style editor
can also be accessed by pressing <CTRL-T>. This
edits the style used in the current slot.  
Styles: An example 
Open a new�table by clicking on the TableCalc icon
bar icon, then open the style browser. Edit the
Heading style, and notice that the Colours section
is not ticked. Close the style editor, then edit
the Highlight 3 style. You will see that the
colours item is ticked. Now edit Normal, and
change the background colour, then click on the
Set button. Notice that this changes the
background colour for all styles except Highlight�3.
All styles inherit options from Normal unless overridden.
The Styles menu
If, for any reason, you do not wish to have the
style browser window open, you can access the
style system directly from the menu. The Styles...
item leads to a menu listing all the available
styles. Each of these items in turn lead to a menu
offering Apply and Edit options. 

Joining a slot 
If slots in more than two columns are selected,
the "Grid->Join slots" menu item will be
available. This can be used to join slots from two
or more columns together to make a wider
"super-slot". These wide slots can be split up
again by positioning the caret and using the
"Grid->Split slots" item.

Line control
The horizontal lines between rows can be
controlled using two options from the "Grid"
submenu. These are both used in the same way:  A
block is selected, covering at least two rows,
then the menu item is used to turn all row lines
contained within that block on or off. When a line
has been turned off, it is shown with a "dotting"
effect. "Off" lines are never shown in printouts,
or when draw files are exported. Column lines can
be controlled in a similar way.  
Saving a table 
To save your table, press MENU and follow the
"File->Save" item. This displays a standard RISC
OS save box, allowing the table to be saved. There
are two slightly different formats in which the
table can be saved. See the section "OLE support
II" for more information.

Printing a table
To print a table, ensure that you have a RISC OS
printer driver loaded and correctly set up. Now
select the "File->Print..." item. A dialog box
will appear, telling you how many pages will be
needed to print the table. Enter the number of
copies you wish to print, then click on the Print
button.

Working with DTP packages
TableCalc can export standard draw files for use
with a wide range of DTP and multimedia packages.
To export a draw file, press MENU and follow the
"File->Export->Draw" item. This leads to a save
box. Having saved a draw file, it can be dropped
straight into a DTP program, or loaded into !Draw
for further editing. Note that certain DTP
packages support OLE, which provides an easier
alternative. See the next section for more
details.
OLE support
TableCalc supports object linking and embedding
(OLE) with appropriate programs. Programs which
currently support OLE include Computer Concepts'
Impression. To perform OLE, simply drop a table
file into a frame or document. It will be
displayed as normal. If you wish to edit the
table, hold down <CTRL> and double click on the
frame. Having edited a table which was loaded by
OLE, the original can be altered by pressing <F3>
then <RETURN>
OLE support II
OLE only works correctly if the "save with
graphics" option is turned on from the table
choices dialog box. Note, however, that files which
are saved with graphics are significantly larger
than those which are not. Therefore, it is
recommended that the "Save with graphics" option
is turned off if you are not using OLE. The global
choices dialog box allows you to specify the
default value of the "Save with graphics" option.

Spreadsheets
As well as normal text, slots in TableCalc tables
can contain number slots. To create a number slot,
position the caret in a blank slot, then select
the "Slots->Edit Expression" menu item. Enter a
number into the writable icon, then click on the
Set button, or press return.

Other number entry methods
If you wish to enter a sequence of numbers with a
constant difference (e.g. 1,3,5,...), the slot
initialiser can be used. To use it, select a block
then press MENU and select the
Slots->Initialise... item. Enter the initial value
and difference, then click on the Fill button. If
you wish to enter a large number of figures with
no constant difference, they can be entered in
standard text slots, then converted to numbers
slots using the "Slots->Text to numbers" item.
Expressions
As well as simple numbers, number slots can
contain mathematical expressions. Expressions can
be in terms of numbers (e.g. 2+2), or they can
refer to other slots within the table. Slots are
referred to by a letter and a number. (e.g. B4).
The letter refers to the column (B being the
second from the left), and the number refers to
the row. A typical expression using a slot
reference would be (C3+2)*3.

The expression editor
Any expression can be entered into the writable
field in the expression editor from the keyboard,
but many expressions can be "built" using the
other buttons in the expression editor. There are
buttons to insert the basic arithmetic operators,
functions (see later sections), pairs of brackets,
and also the ^ symbol which is used to raise one
number to the power of another. Slot references
can be inserted by clicking on a slot in the main
window.
Functions
TableCalc provides a range of functions which act
on numbers, slot references, or expressions. A
function is used from within an expression by
entering the name of the function followed by a
pair of brackets containing the number or
expression on which you wish the function to work.
Functions can be inserted into expressions using
the mouse by clicking on the fn() button, and
selecting a function from the resulting menu.

Functions available
Tablecalc currently provides a square root
function, a VAT function and a set of trigonometric
and inverse trigonometric functions, together with
a pair of functions to convert from degrees to
radians and back again. Note that all the trig
functions currently work in degrees, NOT radians.

Spreadsheet block functions
As well as the functions described above, which
act on numbers, TableCalc provides several
functions which act on blocks of slots. Currently
available block  functions are sum() and
average(). Both these functions should be passed
TWO slot references referring to diagonally
opposite corners of a block e.g. sum(a2b6). These
functions have special buttons to insert them. The
"sigma" button inserts sum(), and the "X bar"
button inserts average().
Constant functions
TableCalc provides two "constant" functions,
namely const_pi() and const_e(). These take no
arguments, and return the appropriate mathematical
constant (correct to 10 significant figures). A
typical use would be in the expression
(const_pi()*(10^2)), which returns the area of a
circle of radius 10 units.

Formula replication
If you have entered an expression into a slot, it
is possible to copy it into the slots below or to
the right, by selecting a block then using the
"Slots->Copy down" or "Copy right" menu items. If
the expression contains slot references, these are
adjusted appropriately (e.g., if A1+1 was copied
down, it would become A2+1 in the next slot down). 

Absolute slot references
If you do not wish a reference to be adjusted when
a formula replication is performed (see the
previous section), it should be prefixed by the
hash character (#). Such a slot reference can be
inserted by clicking on a slot with the adjust
button, instead of select.

Other spreadsheet operations
As well as the operations described in the
previous sections, there are two other menu
options concerning spreadsheets. They are both
located on the "Slots" submenu. The "Snapshot"
item converts expressions into numbers, making
them independent of any changes to referenced
slots. The "Numbers to text" item converts both
number and expression slots to text slots. Both
these operations work both on single slots and
selected blocks.
CSV file support
TableCalc can load and save standard Comma
Separated Value (CSV) files. To load a CSV file,
drop it on the TableCalc icon on the icon bar (CSV
files cannot be loaded by double-clicking). To
save a table as a CSV file, use the
File->Export->CSV menu item. If a block is
selected, you will be offered the choice to save
only the selected region.

Table choices
Each table currently has two options associated
with it. Saving of graphics with table files can
be turned on and off (see the section "OLE support
II"), as can a spreadsheet border surrounding the
table, which show row letters and column numbers.

TableCalc global choices
A number of TableCalc's features can be customised
by the user. Such features are controlled by
clicking MENU over the icon bar icon, then
selecting "Choices...". Choices currently
available include: Confirmation when rows and
columns are deleted, the initial state of the
"Save with graphics" flag for newly created
documents, automatic display of the spreadsheet
border when the expression editor is used, and the
current VAT rate.
Copyright message
TableCalc  is � iSV/Thomas Down 1994
!iSVManual is � iSV Products 1993
The author acknowledges the use of the DeskLib
library in the production of this program.

00000000  54 61 62 6c 65 43 61 6c  63 20 44 65 6d 6f 20 56  |TableCalc Demo V|
00000010  65 72 73 69 6f 6e 0a 54  68 69 73 20 69 73 20 61  |ersion.This is a|
00000020  20 64 65 6d 6f 20 76 65  72 73 69 6f 6e 20 6f 66  | demo version of|
00000030  20 54 61 62 6c 65 63 61  6c 63 2e 20 49 74 20 68  | Tablecalc. It h|
00000040  61 73 20 61 6c 6c 20 74  68 65 20 0a 66 65 61 74  |as all the .feat|
00000050  75 72 65 73 20 6f 66 20  74 68 65 20 72 65 61 6c  |ures of the real|
00000060  20 76 65 72 73 69 6f 6e  20 65 78 63 65 70 74 20  | version except |
00000070  74 68 61 74 20 69 74 20  63 61 6e 6e 6f 74 20 0a  |that it cannot .|
00000080  73 61 76 65 20 6f 72 20  70 72 69 6e 74 20 66 69  |save or print fi|
00000090  6c 65 73 2e 20 54 61 62  6c 65 63 61 6c 63 20 63  |les. Tablecalc c|
000000a0  6f 73 74 73 20 a3 33 31  2e 35 30 20 69 6e 63 6c  |osts .31.50 incl|
000000b0  75 64 69 6e 67 0a 63 61  72 72 69 61 67 65 2e 0a  |uding.carriage..|
000000c0  69 53 56 20 50 72 6f 64  75 63 74 73 0a 38 36 20  |iSV Products.86 |
000000d0  54 75 72 6e 62 65 72 72  79 0a 48 6f 6d 65 20 46  |Turnberry.Home F|
000000e0  61 72 6d 2c 20 42 72 61  63 6b 6e 65 6c 6c 0a 42  |arm, Bracknell.B|
000000f0  65 72 6b 73 20 52 47 31  32 20 38 5a 48 0a 54 65  |erks RG12 8ZH.Te|
00000100  6c 20 30 31 33 34 34 20  35 35 37 36 39 0a 0a 41  |l 01344 55769..A|
00000110  62 6f 75 74 20 54 61 62  6c 65 43 61 6c 63 20 0a  |bout TableCalc .|
00000120  54 61 62 6c 65 43 61 6c  63 20 69 73 20 61 20 73  |TableCalc is a s|
00000130  6f 70 68 69 73 74 69 63  61 74 65 64 20 74 61 62  |ophisticated tab|
00000140  6c 65 20 67 65 6e 65 72  61 74 69 6e 67 0a 70 72  |le generating.pr|
00000150  6f 67 72 61 6d 20 66 6f  72 20 41 63 6f 72 6e 20  |ogram for Acorn |
00000160  52 49 53 43 20 4f 53 20  63 6f 6d 70 75 74 65 72  |RISC OS computer|
00000170  73 20 77 69 74 68 20 52  49 53 43 20 4f 53 0a 33  |s with RISC OS.3|
00000180  2e 31 20 6f 72 20 6c 61  74 65 72 2e 20 41 73 20  |.1 or later. As |
00000190  77 65 6c 6c 20 61 73 20  73 69 6d 70 6c 65 20 74  |well as simple t|
000001a0  61 62 6c 65 73 2c 20 69  74 20 61 6c 6c 6f 77 73  |ables, it allows|
000001b0  0a 74 68 65 20 63 72 65  61 74 69 6f 6e 20 6f 66  |.the creation of|
000001c0  20 73 70 72 65 61 64 73  68 65 65 74 73 2c 20 69  | spreadsheets, i|
000001d0  6e 20 77 68 69 63 68 20  61 20 72 61 6e 67 65 20  |n which a range |
000001e0  6f 66 0a 63 61 6c 63 75  6c 61 74 69 6f 6e 20 63  |of.calculation c|
000001f0  61 6e 20 62 65 20 63 61  72 72 69 65 64 20 6f 75  |an be carried ou|
00000200  74 20 6f 6e 20 66 69 67  75 72 65 73 2e 0a 0a 49  |t on figures...I|
00000210  6e 73 74 61 6c 6c 69 6e  67 20 54 61 62 6c 65 43  |nstalling TableC|
00000220  61 6c 63 20 0a 54 61 62  6c 65 43 61 6c 63 20 63  |alc .TableCalc c|
00000230  61 6e 20 62 65 20 69 6e  73 74 61 6c 6c 65 64 20  |an be installed |
00000240  6f 6e 20 61 20 68 61 72  64 20 64 69 73 63 20 62  |on a hard disc b|
00000250  79 0a 64 72 61 67 67 69  6e 67 20 74 68 65 20 21  |y.dragging the !|
00000260  54 61 62 6c 65 43 61 6c  63 20 61 70 70 6c 69 63  |TableCalc applic|
00000270  61 74 69 6f 6e 20 74 6f  20 61 20 64 69 72 65 63  |ation to a direc|
00000280  74 6f 72 79 0a 76 69 65  77 65 72 2e 20 46 6c 6f  |tory.viewer. Flo|
00000290  70 70 79 20 64 69 73 63  20 75 73 65 72 73 20 73  |ppy disc users s|
000002a0  68 6f 75 6c 64 20 6d 61  6b 65 20 61 20 62 61 63  |hould make a bac|
000002b0  6b 75 70 0a 63 6f 70 79  20 6f 66 20 74 68 65 20  |kup.copy of the |
000002c0  54 61 62 6c 65 43 61 6c  63 20 6d 61 73 74 65 72  |TableCalc master|
000002d0  20 64 69 73 63 20 66 6f  72 20 70 65 72 73 6f 6e  | disc for person|
000002e0  61 6c 0a 75 73 65 2e 0a  0a 49 6e 74 65 72 61 63  |al.use...Interac|
000002f0  74 69 76 65 20 68 65 6c  70 0a 57 68 65 6e 20 79  |tive help.When y|
00000300  6f 75 20 61 72 65 20 72  75 6e 6e 69 6e 67 20 54  |ou are running T|
00000310  61 62 6c 65 43 61 6c 63  2c 20 6d 61 6e 79 20 68  |ableCalc, many h|
00000320  65 6c 70 66 75 6c 0a 6d  65 73 73 61 67 65 73 20  |elpful.messages |
00000330  61 72 65 20 61 76 61 69  6c 61 62 6c 65 2e 20 54  |are available. T|
00000340  6f 20 76 69 65 77 20 74  68 65 6d 2c 20 72 75 6e  |o view them, run|
00000350  20 74 68 65 0a 21 48 65  6c 70 20 61 70 70 6c 69  | the.!Help appli|
00000360  63 61 74 69 6f 6e 20 66  72 6f 6d 20 74 68 65 20  |cation from the |
00000370  41 70 70 73 20 66 6f 6c  64 65 72 2e 20 4e 6f 77  |Apps folder. Now|
00000380  2c 0a 77 68 65 6e 65 76  65 72 20 79 6f 75 20 70  |,.whenever you p|
00000390  6f 69 6e 74 20 61 74 20  61 6e 79 20 6f 66 20 54  |oint at any of T|
000003a0  61 62 6c 65 43 61 6c 63  27 73 20 77 69 6e 64 6f  |ableCalc's windo|
000003b0  77 73 0a 6f 72 20 6d 65  6e 75 73 2c 20 61 20 6d  |ws.or menus, a m|
000003c0  65 73 73 61 67 65 20 77  69 6c 6c 20 62 65 20 64  |essage will be d|
000003d0  69 73 70 6c 61 79 65 64  20 69 6e 20 74 68 65 20  |isplayed in the |
000003e0  48 65 6c 70 0a 77 69 6e  64 6f 77 2e 0a 0a 43 72  |Help.window...Cr|
000003f0  65 61 74 69 6e 67 20 61  20 74 61 62 6c 65 0a 54  |eating a table.T|
00000400  61 62 6c 65 43 61 6c 63  20 63 61 6e 20 62 65 20  |ableCalc can be |
00000410  6c 6f 61 64 65 64 20 69  6e 20 74 68 65 20 6e 6f  |loaded in the no|
00000420  72 6d 61 6c 20 77 61 79  2c 20 62 79 0a 64 6f 75  |rmal way, by.dou|
00000430  62 6c 65 2d 63 6c 69 63  6b 69 6e 67 20 6f 6e 20  |ble-clicking on |
00000440  69 74 73 20 69 63 6f 6e  20 69 6e 20 61 20 64 69  |its icon in a di|
00000450  72 65 63 74 6f 72 79 20  76 69 65 77 65 72 2e 0a  |rectory viewer..|
00000460  4f 6e 63 65 20 54 61 62  6c 65 43 61 6c 63 20 69  |Once TableCalc i|
00000470  73 20 6c 6f 61 64 65 64  2c 20 61 20 6e 65 77 20  |s loaded, a new |
00000480  74 61 62 6c 65 20 63 61  6e 20 62 65 0a 63 72 65  |table can be.cre|
00000490  61 74 65 64 20 62 79 20  63 6c 69 63 6b 69 6e 67  |ated by clicking|
000004a0  20 6f 6e 20 69 74 73 20  69 63 6f 6e 20 62 61 72  | on its icon bar|
000004b0  20 69 63 6f 6e 2e 20 54  61 62 6c 65 0a 66 69 6c  | icon. Table.fil|
000004c0  65 73 20 63 61 6e 20 62  65 20 6c 6f 61 64 65 64  |es can be loaded|
000004d0  20 62 79 20 64 6f 75 62  6c 65 2d 63 6c 69 63 6b  | by double-click|
000004e0  69 6e 67 2c 20 6f 72 20  62 79 0a 64 72 61 67 67  |ing, or by.dragg|
000004f0  69 6e 67 20 74 68 65 6d  20 74 6f 20 74 68 65 20  |ing them to the |
00000500  54 61 62 6c 65 43 61 6c  63 20 69 63 6f 6e 2e 0a  |TableCalc icon..|
00000510  0a 42 75 69 6c 64 69 6e  67 20 74 61 62 6c 65 73  |.Building tables|
00000520  0a 4d 6f 73 74 20 54 61  62 6c 65 43 61 6c 63 20  |.Most TableCalc |
00000530  65 64 69 74 69 6e 67 20  66 75 6e 63 74 69 6f 6e  |editing function|
00000540  73 20 72 65 6c 79 20 6f  6e 20 74 68 65 0a 70 6f  |s rely on the.po|
00000550  73 69 74 69 6f 6e 20 6f  66 20 74 68 65 20 63 61  |sition of the ca|
00000560  72 65 74 2e 20 54 68 69  73 20 69 73 20 61 20 72  |ret. This is a r|
00000570  65 64 20 76 65 72 74 69  63 61 6c 20 62 61 72 2e  |ed vertical bar.|
00000580  0a 57 68 65 6e 20 74 68  65 20 63 61 72 65 74 20  |.When the caret |
00000590  69 73 20 70 6f 73 69 74  69 6f 6e 65 64 20 77 69  |is positioned wi|
000005a0  74 68 69 6e 20 61 20 74  61 62 6c 65 2c 0a 74 65  |thin a table,.te|
000005b0  78 74 20 77 68 69 63 68  20 69 73 20 65 6e 74 65  |xt which is ente|
000005c0  72 65 64 20 66 72 6f 6d  20 74 68 65 20 6b 65 79  |red from the key|
000005d0  62 6f 61 72 64 20 69 73  0a 69 6e 73 65 72 74 65  |board is.inserte|
000005e0  64 20 61 74 20 74 68 65  20 63 61 72 65 74 2e 20  |d at the caret. |
000005f0  57 68 65 6e 20 74 68 65  20 63 61 72 65 74 20 69  |When the caret i|
00000600  73 0a 70 6f 73 69 74 69  6f 6e 65 64 20 69 6e 20  |s.positioned in |
00000610  61 20 73 6c 6f 74 20 6f  6e 20 74 68 65 20 6c 61  |a slot on the la|
00000620  73 74 20 72 6f 77 20 6f  66 20 61 20 74 61 62 6c  |st row of a tabl|
00000630  65 2c 0a 70 72 65 73 73  69 6e 67 20 3c 52 45 54  |e,.pressing <RET|
00000640  55 52 4e 3e 20 61 64 64  73 20 61 20 6e 65 77 20  |URN> adds a new |
00000650  72 6f 77 20 61 74 20 74  68 65 20 62 6f 74 74 6f  |row at the botto|
00000660  6d 20 6f 66 0a 74 68 65  20 74 61 62 6c 65 2e 20  |m of.the table. |
00000670  53 69 6d 69 6c 61 72 6c  79 2c 20 3c 54 41 42 3e  |Similarly, <TAB>|
00000680  20 63 61 6e 20 62 65 20  75 73 65 64 20 74 6f 20  | can be used to |
00000690  61 64 64 0a 63 6f 6c 75  6d 6e 73 20 74 6f 20 74  |add.columns to t|
000006a0  68 65 20 72 69 67 68 74  20 68 61 6e 64 20 73 69  |he right hand si|
000006b0  64 65 20 6f 66 20 74 68  65 20 74 61 62 6c 65 2e  |de of the table.|
000006c0  0a 0a 45 64 69 74 69 6e  67 20 74 65 78 74 0a 54  |..Editing text.T|
000006d0  65 78 74 20 69 73 20 65  6e 74 65 72 65 64 20 69  |ext is entered i|
000006e0  6e 74 6f 20 61 20 73 6c  6f 74 20 62 79 20 70 6f  |nto a slot by po|
000006f0  73 69 74 69 6f 6e 69 6e  67 20 74 68 65 0a 63 61  |sitioning the.ca|
00000700  72 65 74 20 69 6e 20 74  68 65 20 73 6c 6f 74 2c  |ret in the slot,|
00000710  20 74 68 65 6e 20 74 79  70 69 6e 67 20 66 72 6f  | then typing fro|
00000720  6d 20 74 68 65 20 6b 65  79 62 6f 61 72 64 2e 0a  |m the keyboard..|
00000730  49 66 20 79 6f 75 20 74  79 70 65 20 6d 6f 72 65  |If you type more|
00000740  20 74 65 78 74 20 74 68  61 6e 20 63 61 6e 20 62  | text than can b|
00000750  65 20 68 65 6c 64 20 62  79 20 74 68 65 0a 73 6c  |e held by the.sl|
00000760  6f 74 2c 20 74 68 65 20  73 6c 6f 74 20 69 73 20  |ot, the slot is |
00000770  65 78 74 65 6e 64 65 64  20 64 6f 77 6e 77 61 72  |extended downwar|
00000780  64 73 2c 0a 77 6f 72 64  2d 77 72 61 70 70 69 6e  |ds,.word-wrappin|
00000790  67 20 74 68 65 20 74 65  78 74 20 61 70 70 72 6f  |g the text appro|
000007a0  70 72 69 61 74 65 6c 79  2e 20 49 66 20 79 6f 75  |priately. If you|
000007b0  20 74 79 70 65 0a 61 20  77 6f 72 64 20 77 68 69  | type.a word whi|
000007c0  63 68 20 69 73 20 74 6f  6f 20 6c 6f 6e 67 20 74  |ch is too long t|
000007d0  6f 20 66 69 74 20 6f 6e  20 6f 6e 65 20 6c 69 6e  |o fit on one lin|
000007e0  65 2c 20 74 68 65 0a 77  69 64 74 68 20 6f 66 20  |e, the.width of |
000007f0  74 68 65 20 63 6f 6c 75  6d 6e 20 69 73 20 69 6e  |the column is in|
00000800  63 72 65 61 73 65 64 2e  20 41 20 73 69 6e 67 6c  |creased. A singl|
00000810  65 0a 63 68 61 72 61 63  74 65 72 20 63 61 6e 20  |e.character can |
00000820  62 65 20 64 65 6c 65 74  65 64 20 62 79 20 70 72  |be deleted by pr|
00000830  65 73 73 69 6e 67 20 74  68 65 20 3c 44 45 4c 45  |essing the <DELE|
00000840  54 45 3e 0a 6b 65 79 2e  20 41 20 63 6f 6d 70 6c  |TE>.key. A compl|
00000850  65 74 65 20 73 6c 6f 74  20 63 61 6e 20 62 65 20  |ete slot can be |
00000860  63 6c 65 61 72 65 64 20  62 79 20 70 72 65 73 73  |cleared by press|
00000870  69 6e 67 0a 4d 45 4e 55  20 61 6e 64 20 73 65 6c  |ing.MENU and sel|
00000880  65 63 74 69 6e 67 20 74  68 65 20 22 53 6c 6f 74  |ecting the "Slot|
00000890  73 2d 3e 43 6c 65 61 72  22 20 69 74 65 6d 2e 0a  |s->Clear" item..|
000008a0  54 68 65 20 74 6f 6f 6c  20 62 61 72 0a 41 74 74  |The tool bar.Att|
000008b0  61 63 68 65 64 20 74 6f  20 74 68 65 20 74 6f 70  |ached to the top|
000008c0  20 6f 66 20 65 61 63 68  20 54 61 62 6c 65 43 61  | of each TableCa|
000008d0  6c 63 20 77 69 6e 64 6f  77 20 69 73 20 61 0a 74  |lc window is a.t|
000008e0  6f 6f 6c 20 62 61 72 20  61 6c 6c 6f 77 69 6e 67  |ool bar allowing|
000008f0  20 63 65 72 74 61 69 6e  20 69 6d 70 6f 72 74 61  | certain importa|
00000900  6e 74 20 6f 70 65 72 61  74 69 6f 6e 73 20 74 6f  |nt operations to|
00000910  0a 62 65 20 70 65 72 66  6f 72 6d 65 64 20 76 65  |.be performed ve|
00000920  72 79 20 71 75 69 63 6b  6c 79 2e 20 41 20 64 69  |ry quickly. A di|
00000930  61 67 72 61 6d 20 73 68  6f 77 69 6e 67 20 74 68  |agram showing th|
00000940  65 0a 66 75 6e 63 74 69  6f 6e 73 20 6f 66 20 65  |e.functions of e|
00000950  61 63 68 20 6f 66 20 74  68 65 20 62 75 74 74 6f  |ach of the butto|
00000960  6e 73 20 69 73 20 69 6e  63 6c 75 64 65 64 20 6f  |ns is included o|
00000970  6e 0a 74 68 65 20 71 75  69 63 6b 20 72 65 66 65  |n.the quick refe|
00000980  72 65 6e 63 65 20 63 61  72 64 2c 20 77 68 69 63  |rence card, whic|
00000990  68 20 63 61 6e 20 62 65  20 70 72 69 6e 74 65 64  |h can be printed|
000009a0  0a 75 73 69 6e 67 20 74  68 65 20 21 51 75 69 63  |.using the !Quic|
000009b0  6b 52 65 66 73 20 61 70  70 6c 69 63 61 74 69 6f  |kRefs applicatio|
000009c0  6e 2c 20 73 75 70 70 6c  69 65 64 20 6f 6e 20 74  |n, supplied on t|
000009d0  68 65 0a 54 61 62 6c 65  43 61 6c 63 20 6d 61 73  |he.TableCalc mas|
000009e0  74 65 72 20 64 69 73 63  2e 0a 0a 41 64 64 69 6e  |ter disc...Addin|
000009f0  67 20 72 6f 77 73 20 61  6e 64 20 63 6f 6c 75 6d  |g rows and colum|
00000a00  6e 73 20 0a 41 20 72 6f  77 20 63 61 6e 20 62 65  |ns .A row can be|
00000a10  20 61 64 64 65 64 20 61  66 74 65 72 20 74 68 65  | added after the|
00000a20  20 72 6f 77 20 6f 6e 20  77 68 69 63 68 20 74 68  | row on which th|
00000a30  65 0a 63 61 72 65 74 20  69 73 20 70 6f 73 69 74  |e.caret is posit|
00000a40  69 6f 6e 65 64 20 62 79  20 70 72 65 73 73 69 6e  |ioned by pressin|
00000a50  67 20 4d 45 4e 55 20 61  6e 64 20 63 68 6f 6f 73  |g MENU and choos|
00000a60  69 6e 67 0a 74 68 65 20  22 47 72 69 64 2d 3e 41  |ing.the "Grid->A|
00000a70  64 64 20 72 6f 77 22 20  69 74 65 6d 2e 20 49 66  |dd row" item. If|
00000a80  2c 20 69 6e 73 74 65 61  64 20 6f 66 20 63 6c 69  |, instead of cli|
00000a90  63 6b 69 6e 67 0a 6f 6e  20 22 41 64 64 20 72 6f  |cking.on "Add ro|
00000aa0  77 22 2c 20 79 6f 75 20  6d 6f 76 65 20 74 68 65  |w", you move the|
00000ab0  20 70 6f 69 6e 74 65 72  20 74 6f 20 74 68 65 20  | pointer to the |
00000ac0  72 69 67 68 74 2c 20 61  0a 73 75 62 6d 65 6e 75  |right, a.submenu|
00000ad0  20 69 73 20 64 69 73 70  6c 61 79 65 64 2c 20 61  | is displayed, a|
00000ae0  6c 6c 6f 77 69 6e 67 20  79 6f 75 20 74 6f 20 61  |llowing you to a|
00000af0  64 64 20 61 20 72 6f 77  0a 62 65 66 6f 72 65 20  |dd a row.before |
00000b00  6f 72 20 61 66 74 65 72  20 74 68 65 20 63 75 72  |or after the cur|
00000b10  72 65 6e 74 20 72 6f 77  2e 20 54 68 65 20 22 41  |rent row. The "A|
00000b20  64 64 20 63 6f 6c 75 6d  6e 22 0a 69 74 65 6d 20  |dd column".item |
00000b30  77 6f 72 6b 73 20 69 6e  20 65 78 61 63 74 6c 79  |works in exactly|
00000b40  20 74 68 65 20 73 61 6d  65 20 77 61 79 2e 20 0a  | the same way. .|
00000b50  0a 44 65 6c 65 74 69 6e  67 20 72 6f 77 73 20 61  |.Deleting rows a|
00000b60  6e 64 20 63 6f 6c 75 6d  6e 73 0a 41 20 72 6f 77  |nd columns.A row|
00000b70  20 6f 72 20 63 6f 6c 75  6d 6e 20 63 61 6e 20 62  | or column can b|
00000b80  65 20 64 65 6c 65 74 65  64 20 62 79 20 70 6f 73  |e deleted by pos|
00000b90  69 74 69 6f 6e 69 6e 67  20 74 68 65 0a 63 61 72  |itioning the.car|
00000ba0  65 74 2c 20 74 68 65 6e  20 75 73 69 6e 67 20 74  |et, then using t|
00000bb0  68 65 20 22 47 72 69 64  2d 3e 44 65 6c 65 74 65  |he "Grid->Delete|
00000bc0  20 52 6f 77 22 20 6f 72  0a 22 47 72 69 64 2d 3e  | Row" or."Grid->|
00000bd0  44 65 6c 65 74 65 20 43  6f 6c 75 6d 6e 22 20 69  |Delete Column" i|
00000be0  74 65 6d 2e 20 41 20 64  69 61 6c 6f 67 20 62 6f  |tem. A dialog bo|
00000bf0  78 20 77 69 6c 6c 0a 61  70 70 65 61 72 20 72 65  |x will.appear re|
00000c00  71 75 65 73 74 69 6e 67  20 63 6f 6e 66 69 72 6d  |questing confirm|
00000c10  61 74 69 6f 6e 2e 20 43  6c 69 63 6b 20 6f 6e 20  |ation. Click on |
00000c20  74 68 65 20 59 45 53 0a  62 75 74 74 6f 6e 20 74  |the YES.button t|
00000c30  6f 20 70 65 72 66 6f 72  6d 20 74 68 65 20 64 65  |o perform the de|
00000c40  6c 65 74 69 6f 6e 2e 20  49 66 20 79 6f 75 20 66  |letion. If you f|
00000c50  69 6e 64 20 74 68 69 73  0a 61 6e 6e 6f 79 69 6e  |ind this.annoyin|
00000c60  67 2c 20 79 6f 75 20 63  61 6e 20 74 75 72 6e 20  |g, you can turn |
00000c70  69 74 20 6f 66 66 2e 20  53 65 65 20 74 68 65 20  |it off. See the |
00000c80  73 65 63 74 69 6f 6e 20  6f 6e 0a 67 6c 6f 62 61  |section on.globa|
00000c90  6c 20 63 68 6f 69 63 65  73 2e 0a 0a 43 6f 6c 75  |l choices...Colu|
00000ca0  6d 6e 20 77 69 64 74 68  73 0a 54 68 65 20 77 69  |mn widths.The wi|
00000cb0  64 74 68 20 6f 66 20 61  6e 79 20 63 6f 6c 75 6d  |dth of any colum|
00000cc0  6e 20 77 69 74 68 69 6e  20 74 68 65 20 74 61 62  |n within the tab|
00000cd0  6c 65 20 63 61 6e 20 62  65 0a 61 64 6a 75 73 74  |le can be.adjust|
00000ce0  65 64 20 62 79 20 70 6f  69 6e 74 69 6e 67 20 61  |ed by pointing a|
00000cf0  74 20 61 20 6c 69 6e 65  20 73 65 70 61 72 61 74  |t a line separat|
00000d00  69 6e 67 20 63 6f 6c 75  6d 6e 73 2c 0a 61 6e 64  |ing columns,.and|
00000d10  20 64 72 61 67 67 69 6e  67 20 77 69 74 68 20 53  | dragging with S|
00000d20  45 4c 45 43 54 2e 20 57  68 65 6e 20 79 6f 75 20  |ELECT. When you |
00000d30  70 6f 69 6e 74 20 61 74  20 61 20 6c 69 6e 65 0a  |point at a line.|
00000d40  77 68 69 63 68 20 63 61  6e 20 62 65 20 64 72 61  |which can be dra|
00000d50  67 67 65 64 2c 20 74 68  65 20 73 68 61 70 65 20  |gged, the shape |
00000d60  6f 66 20 74 68 65 20 6d  6f 75 73 65 0a 70 6f 69  |of the mouse.poi|
00000d70  6e 74 65 72 20 63 68 61  6e 67 65 73 2e 20 41 20  |nter changes. A |
00000d80  63 6f 6c 75 6d 6e 20 77  69 64 74 68 20 63 61 6e  |column width can|
00000d90  20 62 65 20 73 65 74 0a  61 75 74 6f 6d 61 74 69  | be set.automati|
00000da0  63 61 6c 6c 79 20 74 6f  20 74 68 65 20 6d 69 6e  |cally to the min|
00000db0  69 6d 75 6d 20 77 69 64  74 68 20 6e 65 65 64 65  |imum width neede|
00000dc0  64 20 74 6f 0a 61 63 63  6f 6d 6f 64 61 74 65 20  |d to.accomodate |
00000dd0  61 6c 6c 20 74 68 65 20  74 65 78 74 20 77 69 74  |all the text wit|
00000de0  68 6f 75 74 20 75 73 69  6e 67 20 77 6f 72 64 20  |hout using word |
00000df0  77 72 61 70 62 79 0a 64  6f 75 62 6c 65 2d 63 6c  |wrapby.double-cl|
00000e00  69 63 6b 69 6e 67 20 53  45 4c 45 43 54 20 6f 76  |icking SELECT ov|
00000e10  65 72 20 61 20 63 6f 6c  75 6d 6e 20 62 6f 75 6e  |er a column boun|
00000e20  64 61 72 79 2e 0a 0a 53  65 6c 65 63 74 69 6e 67  |dary...Selecting|
00000e30  20 61 20 62 6c 6f 63 6b  0a 43 65 72 74 61 69 6e  | a block.Certain|
00000e40  20 54 61 62 6c 65 43 61  6c 63 20 6f 70 65 72 61  | TableCalc opera|
00000e50  74 69 6f 6e 73 20 72 65  71 75 69 72 65 20 61 20  |tions require a |
00000e60  62 6c 6f 63 6b 20 6f 66  0a 73 6c 6f 74 73 20 74  |block of.slots t|
00000e70  6f 20 77 6f 72 6b 20 6f  6e 2e 20 4f 74 68 65 72  |o work on. Other|
00000e80  20 6f 70 65 72 61 74 69  6f 6e 73 20 77 68 69 63  | operations whic|
00000e90  68 20 77 6f 72 6b 20 6f  6e 0a 73 69 6e 67 6c 65  |h work on.single|
00000ea0  20 73 6c 6f 74 73 20 63  61 6e 20 61 6c 73 6f 20  | slots can also |
00000eb0  62 65 20 61 70 70 6c 69  65 64 20 74 6f 20 61 6c  |be applied to al|
00000ec0  6c 20 74 68 65 20 73 6c  6f 74 73 0a 69 6e 20 61  |l the slots.in a|
00000ed0  20 73 70 65 63 69 66 69  65 64 20 62 6c 6f 63 6b  | specified block|
00000ee0  2e 20 54 68 65 20 65 61  73 69 65 73 74 20 77 61  |. The easiest wa|
00000ef0  79 20 74 6f 20 73 70 65  63 69 66 79 20 61 0a 62  |y to specify a.b|
00000f00  6c 6f 63 6b 20 69 73 20  74 6f 20 64 72 61 67 20  |lock is to drag |
00000f10  73 65 6c 65 63 74 20 66  72 6f 6d 20 6f 6e 65 20  |select from one |
00000f20  63 6f 72 6e 65 72 20 6f  66 20 74 68 65 0a 64 65  |corner of the.de|
00000f30  73 69 72 65 64 20 72 65  67 69 6f 6e 20 74 6f 20  |sired region to |
00000f40  74 68 65 20 64 69 61 67  6f 6e 61 6c 6c 79 20 6f  |the diagonally o|
00000f50  70 70 6f 73 69 74 65 20  63 6f 72 6e 65 72 2e 0a  |pposite corner..|
00000f60  41 6c 74 65 72 6e 61 74  69 76 65 6c 79 2c 20 70  |Alternatively, p|
00000f70  6f 73 69 74 69 6f 6e 20  74 68 65 20 63 61 72 65  |osition the care|
00000f80  74 20 69 6e 20 6f 6e 65  20 63 6f 72 6e 65 72 2c  |t in one corner,|
00000f90  0a 74 68 65 6e 20 63 6c  69 63 6b 20 41 44 4a 55  |.then click ADJU|
00000fa0  53 54 20 69 6e 20 74 68  65 20 6f 74 68 65 72 2e  |ST in the other.|
00000fb0  20 45 69 74 68 65 72 20  77 61 79 2c 20 74 68 65  | Either way, the|
00000fc0  0a 73 65 6c 65 63 74 65  64 20 62 6c 6f 63 6b 20  |.selected block |
00000fd0  69 73 20 73 68 6f 77 20  69 6e 20 69 6e 76 65 72  |is show in inver|
00000fe0  73 65 20 76 69 64 65 6f  2e 0a 0a 4b 65 79 62 6f  |se video...Keybo|
00000ff0  61 72 64 20 73 68 6f 72  74 20 63 75 74 73 0a 41  |ard short cuts.A|
00001000  6c 6d 6f 73 74 20 61 6c  6c 20 54 61 62 6c 65 43  |lmost all TableC|
00001010  61 6c 63 20 6f 70 65 72  61 74 69 6f 6e 73 20 77  |alc operations w|
00001020  68 69 63 68 20 61 72 65  20 6e 6f 72 6d 61 6c 6c  |hich are normall|
00001030  79 0a 70 65 72 66 6f 72  6d 65 64 20 66 72 6f 6d  |y.performed from|
00001040  20 6d 65 6e 75 73 20 63  61 6e 20 61 6c 73 6f 20  | menus can also |
00001050  62 65 20 70 65 72 66 6f  72 6d 65 64 20 66 72 6f  |be performed fro|
00001060  6d 0a 74 68 65 20 6b 65  79 62 6f 61 72 64 2e 20  |m.the keyboard. |
00001070  54 68 65 20 6b 65 79 62  6f 61 72 64 20 73 68 6f  |The keyboard sho|
00001080  72 74 20 63 75 74 73 20  61 72 65 20 61 6c 6c 0a  |rt cuts are all.|
00001090  73 68 6f 77 6e 20 6f 6e  20 74 68 65 20 6d 65 6e  |shown on the men|
000010a0  75 73 2e 20 54 68 65 20  21 51 75 69 63 6b 52 65  |us. The !QuickRe|
000010b0  66 73 20 61 70 70 6c 69  63 61 74 69 6f 6e 20 63  |fs application c|
000010c0  61 6e 0a 62 65 20 75 73  65 64 20 74 6f 20 70 72  |an.be used to pr|
000010d0  69 6e 74 20 61 20 71 75  69 63 6b 20 72 65 66 65  |int a quick refe|
000010e0  72 65 6e 63 65 20 63 61  72 64 2c 20 77 68 69 63  |rence card, whic|
000010f0  68 0a 69 6e 63 6c 75 64  65 73 20 61 20 63 6f 6d  |h.includes a com|
00001100  70 6c 65 74 65 20 6c 69  73 74 69 6e 67 20 6f 66  |plete listing of|
00001110  20 61 6c 6c 20 73 68 6f  72 74 20 63 75 74 73 2e  | all short cuts.|
00001120  0a 0a 54 61 62 6c 65 43  61 6c 63 20 73 74 79 6c  |..TableCalc styl|
00001130  65 73 0a 54 68 65 20 61  70 70 65 61 72 61 6e 63  |es.The appearanc|
00001140  65 20 6f 66 20 74 65 78  74 20 69 6e 20 73 6c 6f  |e of text in slo|
00001150  74 73 20 69 73 20 63 6f  6e 74 72 6f 6c 6c 65 64  |ts is controlled|
00001160  20 62 79 20 61 0a 73 79  73 74 65 6d 20 6f 66 20  | by a.system of |
00001170  73 74 79 6c 65 73 2e 20  53 74 79 6c 65 73 20 61  |styles. Styles a|
00001180  72 65 20 63 6f 6e 74 72  6f 6c 6c 65 64 20 66 72  |re controlled fr|
00001190  6f 6d 20 74 68 65 0a 73  74 79 6c 65 20 62 72 6f  |om the.style bro|
000011a0  77 73 65 72 2c 20 77 68  69 63 68 20 69 73 20 61  |wser, which is a|
000011b0  63 63 65 73 73 65 64 20  62 79 20 70 72 65 73 73  |ccessed by press|
000011c0  69 6e 67 20 6d 65 6e 75  0a 61 6e 64 20 73 65 6c  |ing menu.and sel|
000011d0  65 63 74 69 6e 67 20 74  68 65 20 22 53 74 79 6c  |ecting the "Styl|
000011e0  65 73 2e 2e 2e 22 20 69  74 65 6d 20 28 49 67 6e  |es..." item (Ign|
000011f0  6f 72 65 20 74 68 65 0a  61 72 72 6f 77 20 73 79  |ore the.arrow sy|
00001200  6d 62 6f 6c 29 2e 20 54  68 69 73 20 6f 70 65 6e  |mbol). This open|
00001210  73 20 61 20 77 69 6e 64  6f 77 20 73 68 6f 77 69  |s a window showi|
00001220  6e 67 20 61 6e 0a 65 78  61 6d 70 6c 65 20 6f 66  |ng an.example of|
00001230  20 65 61 63 68 20 61 76  61 69 6c 61 62 6c 65 20  | each available |
00001240  73 74 79 6c 65 2e 20 45  61 63 68 20 74 61 62 6c  |style. Each tabl|
00001250  65 20 68 61 73 0a 69 74  73 20 6f 77 6e 20 73 65  |e has.its own se|
00001260  74 20 6f 66 20 73 74 79  6c 65 73 2c 20 61 6e 64  |t of styles, and|
00001270  20 69 74 73 20 6f 77 6e  20 73 74 79 6c 65 20 62  | its own style b|
00001280  72 6f 77 73 65 72 2e 0a  54 6f 20 61 70 70 6c 79  |rowser..To apply|
00001290  20 61 20 73 74 79 6c 65  20 74 6f 20 61 20 73 6c  | a style to a sl|
000012a0  6f 74 2c 20 70 6f 73 69  74 69 6f 6e 20 74 68 65  |ot, position the|
000012b0  20 63 61 72 65 74 2c 0a  74 68 65 6e 20 64 6f 75  | caret,.then dou|
000012c0  62 6c 65 2d 63 6c 69 63  6b 20 53 45 4c 45 43 54  |ble-click SELECT|
000012d0  20 6f 76 65 72 20 74 68  65 20 64 65 73 69 72 65  | over the desire|
000012e0  64 20 73 74 79 6c 65 2e  0a 53 74 79 6c 65 73 20  |d style..Styles |
000012f0  63 61 6e 20 62 65 20 61  70 70 6c 69 65 64 20 74  |can be applied t|
00001300  6f 20 62 6c 6f 63 6b 73  20 69 6e 20 74 68 65 20  |o blocks in the |
00001310  73 61 6d 65 20 77 61 79  2e 0a 45 64 69 74 69 6e  |same way..Editin|
00001320  67 20 61 20 73 74 79 6c  65 20 0a 41 20 73 74 79  |g a style .A sty|
00001330  6c 65 20 63 61 6e 20 62  65 20 65 64 69 74 65 64  |le can be edited|
00001340  20 66 72 6f 6d 20 74 68  65 20 73 74 79 6c 65 20  | from the style |
00001350  62 72 6f 77 73 65 72 20  62 79 0a 64 6f 75 62 6c  |browser by.doubl|
00001360  65 2d 63 6c 69 63 6b 69  6e 67 20 41 44 4a 55 53  |e-clicking ADJUS|
00001370  54 20 6f 76 65 72 20 61  20 73 74 79 6c 65 27 73  |T over a style's|
00001380  20 65 6e 74 72 79 2e 20  54 68 69 73 0a 6f 70 65  | entry. This.ope|
00001390  6e 73 20 61 20 77 69 6e  64 6f 77 20 61 6c 6c 6f  |ns a window allo|
000013a0  77 69 6e 67 20 61 6c 6c  20 74 68 65 20 73 74 79  |wing all the sty|
000013b0  6c 65 27 73 20 61 74 74  72 69 62 75 74 65 73 0a  |le's attributes.|
000013c0  74 6f 20 62 65 20 61 6c  74 65 72 65 64 2e 20 53  |to be altered. S|
000013d0  74 79 6c 65 20 61 74 74  72 69 62 75 74 65 73 20  |tyle attributes |
000013e0  61 72 65 20 64 69 76 69  64 65 64 20 69 6e 74 6f  |are divided into|
000013f0  0a 66 6f 75 72 20 67 72  6f 75 70 73 2e 20 49 6e  |.four groups. In|
00001400  20 61 6c 6c 20 73 74 79  6c 65 73 20 28 65 78 63  | all styles (exc|
00001410  65 70 74 20 74 68 65 20  6e 6f 72 6d 61 6c 0a 73  |ept the normal.s|
00001420  74 79 6c 65 29 20 65 61  63 68 20 67 72 6f 75 70  |tyle) each group|
00001430  20 63 61 6e 20 62 65 20  74 75 72 6e 65 64 20 6f  | can be turned o|
00001440  6e 20 61 6e 64 20 6f 66  66 2e 20 57 68 65 6e 20  |n and off. When |
00001450  61 0a 67 72 6f 75 70 20  69 73 20 74 75 72 6e 65  |a.group is turne|
00001460  64 20 6f 66 66 2c 20 74  68 65 20 64 65 66 61 75  |d off, the defau|
00001470  6c 74 20 76 61 6c 75 65  73 20 66 72 6f 6d 20 74  |lt values from t|
00001480  68 65 0a 6e 6f 72 6d 61  6c 20 73 74 79 6c 65 20  |he.normal style |
00001490  61 72 65 20 75 73 65 64  20 69 6e 73 74 65 61 64  |are used instead|
000014a0  2e 20 54 68 65 20 73 74  79 6c 65 20 65 64 69 74  |. The style edit|
000014b0  6f 72 0a 63 61 6e 20 61  6c 73 6f 20 62 65 20 61  |or.can also be a|
000014c0  63 63 65 73 73 65 64 20  62 79 20 70 72 65 73 73  |ccessed by press|
000014d0  69 6e 67 20 3c 43 54 52  4c 2d 54 3e 2e 20 54 68  |ing <CTRL-T>. Th|
000014e0  69 73 0a 65 64 69 74 73  20 74 68 65 20 73 74 79  |is.edits the sty|
000014f0  6c 65 20 75 73 65 64 20  69 6e 20 74 68 65 20 63  |le used in the c|
00001500  75 72 72 65 6e 74 20 73  6c 6f 74 2e 20 20 0a 53  |urrent slot.  .S|
00001510  74 79 6c 65 73 3a 20 41  6e 20 65 78 61 6d 70 6c  |tyles: An exampl|
00001520  65 20 0a 4f 70 65 6e 20  61 20 6e 65 77 a0 74 61  |e .Open a new.ta|
00001530  62 6c 65 20 62 79 20 63  6c 69 63 6b 69 6e 67 20  |ble by clicking |
00001540  6f 6e 20 74 68 65 20 54  61 62 6c 65 43 61 6c 63  |on the TableCalc|
00001550  20 69 63 6f 6e 0a 62 61  72 20 69 63 6f 6e 2c 20  | icon.bar icon, |
00001560  74 68 65 6e 20 6f 70 65  6e 20 74 68 65 20 73 74  |then open the st|
00001570  79 6c 65 20 62 72 6f 77  73 65 72 2e 20 45 64 69  |yle browser. Edi|
00001580  74 20 74 68 65 0a 48 65  61 64 69 6e 67 20 73 74  |t the.Heading st|
00001590  79 6c 65 2c 20 61 6e 64  20 6e 6f 74 69 63 65 20  |yle, and notice |
000015a0  74 68 61 74 20 74 68 65  20 43 6f 6c 6f 75 72 73  |that the Colours|
000015b0  20 73 65 63 74 69 6f 6e  0a 69 73 20 6e 6f 74 20  | section.is not |
000015c0  74 69 63 6b 65 64 2e 20  43 6c 6f 73 65 20 74 68  |ticked. Close th|
000015d0  65 20 73 74 79 6c 65 20  65 64 69 74 6f 72 2c 20  |e style editor, |
000015e0  74 68 65 6e 20 65 64 69  74 0a 74 68 65 20 48 69  |then edit.the Hi|
000015f0  67 68 6c 69 67 68 74 20  33 20 73 74 79 6c 65 2e  |ghlight 3 style.|
00001600  20 59 6f 75 20 77 69 6c  6c 20 73 65 65 20 74 68  | You will see th|
00001610  61 74 20 74 68 65 0a 63  6f 6c 6f 75 72 73 20 69  |at the.colours i|
00001620  74 65 6d 20 69 73 20 74  69 63 6b 65 64 2e 20 4e  |tem is ticked. N|
00001630  6f 77 20 65 64 69 74 20  4e 6f 72 6d 61 6c 2c 20  |ow edit Normal, |
00001640  61 6e 64 0a 63 68 61 6e  67 65 20 74 68 65 20 62  |and.change the b|
00001650  61 63 6b 67 72 6f 75 6e  64 20 63 6f 6c 6f 75 72  |ackground colour|
00001660  2c 20 74 68 65 6e 20 63  6c 69 63 6b 20 6f 6e 20  |, then click on |
00001670  74 68 65 0a 53 65 74 20  62 75 74 74 6f 6e 2e 20  |the.Set button. |
00001680  4e 6f 74 69 63 65 20 74  68 61 74 20 74 68 69 73  |Notice that this|
00001690  20 63 68 61 6e 67 65 73  20 74 68 65 0a 62 61 63  | changes the.bac|
000016a0  6b 67 72 6f 75 6e 64 20  63 6f 6c 6f 75 72 20 66  |kground colour f|
000016b0  6f 72 20 61 6c 6c 20 73  74 79 6c 65 73 20 65 78  |or all styles ex|
000016c0  63 65 70 74 20 48 69 67  68 6c 69 67 68 74 a0 33  |cept Highlight.3|
000016d0  2e 0a 41 6c 6c 20 73 74  79 6c 65 73 20 69 6e 68  |..All styles inh|
000016e0  65 72 69 74 20 6f 70 74  69 6f 6e 73 20 66 72 6f  |erit options fro|
000016f0  6d 20 4e 6f 72 6d 61 6c  20 75 6e 6c 65 73 73 20  |m Normal unless |
00001700  6f 76 65 72 72 69 64 64  65 6e 2e 0a 54 68 65 20  |overridden..The |
00001710  53 74 79 6c 65 73 20 6d  65 6e 75 0a 49 66 2c 20  |Styles menu.If, |
00001720  66 6f 72 20 61 6e 79 20  72 65 61 73 6f 6e 2c 20  |for any reason, |
00001730  79 6f 75 20 64 6f 20 6e  6f 74 20 77 69 73 68 20  |you do not wish |
00001740  74 6f 20 68 61 76 65 20  74 68 65 0a 73 74 79 6c  |to have the.styl|
00001750  65 20 62 72 6f 77 73 65  72 20 77 69 6e 64 6f 77  |e browser window|
00001760  20 6f 70 65 6e 2c 20 79  6f 75 20 63 61 6e 20 61  | open, you can a|
00001770  63 63 65 73 73 20 74 68  65 0a 73 74 79 6c 65 20  |ccess the.style |
00001780  73 79 73 74 65 6d 20 64  69 72 65 63 74 6c 79 20  |system directly |
00001790  66 72 6f 6d 20 74 68 65  20 6d 65 6e 75 2e 20 54  |from the menu. T|
000017a0  68 65 20 53 74 79 6c 65  73 2e 2e 2e 0a 69 74 65  |he Styles....ite|
000017b0  6d 20 6c 65 61 64 73 20  74 6f 20 61 20 6d 65 6e  |m leads to a men|
000017c0  75 20 6c 69 73 74 69 6e  67 20 61 6c 6c 20 74 68  |u listing all th|
000017d0  65 20 61 76 61 69 6c 61  62 6c 65 0a 73 74 79 6c  |e available.styl|
000017e0  65 73 2e 20 45 61 63 68  20 6f 66 20 74 68 65 73  |es. Each of thes|
000017f0  65 20 69 74 65 6d 73 20  69 6e 20 74 75 72 6e 20  |e items in turn |
00001800  6c 65 61 64 20 74 6f 20  61 20 6d 65 6e 75 0a 6f  |lead to a menu.o|
00001810  66 66 65 72 69 6e 67 20  41 70 70 6c 79 20 61 6e  |ffering Apply an|
00001820  64 20 45 64 69 74 20 6f  70 74 69 6f 6e 73 2e 20  |d Edit options. |
00001830  0a 0a 4a 6f 69 6e 69 6e  67 20 61 20 73 6c 6f 74  |..Joining a slot|
00001840  20 0a 49 66 20 73 6c 6f  74 73 20 69 6e 20 6d 6f  | .If slots in mo|
00001850  72 65 20 74 68 61 6e 20  74 77 6f 20 63 6f 6c 75  |re than two colu|
00001860  6d 6e 73 20 61 72 65 20  73 65 6c 65 63 74 65 64  |mns are selected|
00001870  2c 0a 74 68 65 20 22 47  72 69 64 2d 3e 4a 6f 69  |,.the "Grid->Joi|
00001880  6e 20 73 6c 6f 74 73 22  20 6d 65 6e 75 20 69 74  |n slots" menu it|
00001890  65 6d 20 77 69 6c 6c 20  62 65 0a 61 76 61 69 6c  |em will be.avail|
000018a0  61 62 6c 65 2e 20 54 68  69 73 20 63 61 6e 20 62  |able. This can b|
000018b0  65 20 75 73 65 64 20 74  6f 20 6a 6f 69 6e 20 73  |e used to join s|
000018c0  6c 6f 74 73 20 66 72 6f  6d 20 74 77 6f 0a 6f 72  |lots from two.or|
000018d0  20 6d 6f 72 65 20 63 6f  6c 75 6d 6e 73 20 74 6f  | more columns to|
000018e0  67 65 74 68 65 72 20 74  6f 20 6d 61 6b 65 20 61  |gether to make a|
000018f0  20 77 69 64 65 72 0a 22  73 75 70 65 72 2d 73 6c  | wider."super-sl|
00001900  6f 74 22 2e 20 54 68 65  73 65 20 77 69 64 65 20  |ot". These wide |
00001910  73 6c 6f 74 73 20 63 61  6e 20 62 65 20 73 70 6c  |slots can be spl|
00001920  69 74 20 75 70 0a 61 67  61 69 6e 20 62 79 20 70  |it up.again by p|
00001930  6f 73 69 74 69 6f 6e 69  6e 67 20 74 68 65 20 63  |ositioning the c|
00001940  61 72 65 74 20 61 6e 64  20 75 73 69 6e 67 20 74  |aret and using t|
00001950  68 65 0a 22 47 72 69 64  2d 3e 53 70 6c 69 74 20  |he."Grid->Split |
00001960  73 6c 6f 74 73 22 20 69  74 65 6d 2e 0a 0a 4c 69  |slots" item...Li|
00001970  6e 65 20 63 6f 6e 74 72  6f 6c 0a 54 68 65 20 68  |ne control.The h|
00001980  6f 72 69 7a 6f 6e 74 61  6c 20 6c 69 6e 65 73 20  |orizontal lines |
00001990  62 65 74 77 65 65 6e 20  72 6f 77 73 20 63 61 6e  |between rows can|
000019a0  20 62 65 0a 63 6f 6e 74  72 6f 6c 6c 65 64 20 75  | be.controlled u|
000019b0  73 69 6e 67 20 74 77 6f  20 6f 70 74 69 6f 6e 73  |sing two options|
000019c0  20 66 72 6f 6d 20 74 68  65 20 22 47 72 69 64 22  | from the "Grid"|
000019d0  0a 73 75 62 6d 65 6e 75  2e 20 54 68 65 73 65 20  |.submenu. These |
000019e0  61 72 65 20 62 6f 74 68  20 75 73 65 64 20 69 6e  |are both used in|
000019f0  20 74 68 65 20 73 61 6d  65 20 77 61 79 3a 20 20  | the same way:  |
00001a00  41 0a 62 6c 6f 63 6b 20  69 73 20 73 65 6c 65 63  |A.block is selec|
00001a10  74 65 64 2c 20 63 6f 76  65 72 69 6e 67 20 61 74  |ted, covering at|
00001a20  20 6c 65 61 73 74 20 74  77 6f 20 72 6f 77 73 2c  | least two rows,|
00001a30  0a 74 68 65 6e 20 74 68  65 20 6d 65 6e 75 20 69  |.then the menu i|
00001a40  74 65 6d 20 69 73 20 75  73 65 64 20 74 6f 20 74  |tem is used to t|
00001a50  75 72 6e 20 61 6c 6c 20  72 6f 77 20 6c 69 6e 65  |urn all row line|
00001a60  73 0a 63 6f 6e 74 61 69  6e 65 64 20 77 69 74 68  |s.contained with|
00001a70  69 6e 20 74 68 61 74 20  62 6c 6f 63 6b 20 6f 6e  |in that block on|
00001a80  20 6f 72 20 6f 66 66 2e  20 57 68 65 6e 20 61 20  | or off. When a |
00001a90  6c 69 6e 65 0a 68 61 73  20 62 65 65 6e 20 74 75  |line.has been tu|
00001aa0  72 6e 65 64 20 6f 66 66  2c 20 69 74 20 69 73 20  |rned off, it is |
00001ab0  73 68 6f 77 6e 20 77 69  74 68 20 61 20 22 64 6f  |shown with a "do|
00001ac0  74 74 69 6e 67 22 0a 65  66 66 65 63 74 2e 20 22  |tting".effect. "|
00001ad0  4f 66 66 22 20 6c 69 6e  65 73 20 61 72 65 20 6e  |Off" lines are n|
00001ae0  65 76 65 72 20 73 68 6f  77 6e 20 69 6e 20 70 72  |ever shown in pr|
00001af0  69 6e 74 6f 75 74 73 2c  0a 6f 72 20 77 68 65 6e  |intouts,.or when|
00001b00  20 64 72 61 77 20 66 69  6c 65 73 20 61 72 65 20  | draw files are |
00001b10  65 78 70 6f 72 74 65 64  2e 20 43 6f 6c 75 6d 6e  |exported. Column|
00001b20  20 6c 69 6e 65 73 20 63  61 6e 0a 62 65 20 63 6f  | lines can.be co|
00001b30  6e 74 72 6f 6c 6c 65 64  20 69 6e 20 61 20 73 69  |ntrolled in a si|
00001b40  6d 69 6c 61 72 20 77 61  79 2e 20 20 0a 53 61 76  |milar way.  .Sav|
00001b50  69 6e 67 20 61 20 74 61  62 6c 65 20 0a 54 6f 20  |ing a table .To |
00001b60  73 61 76 65 20 79 6f 75  72 20 74 61 62 6c 65 2c  |save your table,|
00001b70  20 70 72 65 73 73 20 4d  45 4e 55 20 61 6e 64 20  | press MENU and |
00001b80  66 6f 6c 6c 6f 77 20 74  68 65 0a 22 46 69 6c 65  |follow the."File|
00001b90  2d 3e 53 61 76 65 22 20  69 74 65 6d 2e 20 54 68  |->Save" item. Th|
00001ba0  69 73 20 64 69 73 70 6c  61 79 73 20 61 20 73 74  |is displays a st|
00001bb0  61 6e 64 61 72 64 20 52  49 53 43 0a 4f 53 20 73  |andard RISC.OS s|
00001bc0  61 76 65 20 62 6f 78 2c  20 61 6c 6c 6f 77 69 6e  |ave box, allowin|
00001bd0  67 20 74 68 65 20 74 61  62 6c 65 20 74 6f 20 62  |g the table to b|
00001be0  65 20 73 61 76 65 64 2e  20 54 68 65 72 65 0a 61  |e saved. There.a|
00001bf0  72 65 20 74 77 6f 20 73  6c 69 67 68 74 6c 79 20  |re two slightly |
00001c00  64 69 66 66 65 72 65 6e  74 20 66 6f 72 6d 61 74  |different format|
00001c10  73 20 69 6e 20 77 68 69  63 68 20 74 68 65 0a 74  |s in which the.t|
00001c20  61 62 6c 65 20 63 61 6e  20 62 65 20 73 61 76 65  |able can be save|
00001c30  64 2e 20 53 65 65 20 74  68 65 20 73 65 63 74 69  |d. See the secti|
00001c40  6f 6e 20 22 4f 4c 45 20  73 75 70 70 6f 72 74 0a  |on "OLE support.|
00001c50  49 49 22 20 66 6f 72 20  6d 6f 72 65 20 69 6e 66  |II" for more inf|
00001c60  6f 72 6d 61 74 69 6f 6e  2e 0a 0a 50 72 69 6e 74  |ormation...Print|
00001c70  69 6e 67 20 61 20 74 61  62 6c 65 0a 54 6f 20 70  |ing a table.To p|
00001c80  72 69 6e 74 20 61 20 74  61 62 6c 65 2c 20 65 6e  |rint a table, en|
00001c90  73 75 72 65 20 74 68 61  74 20 79 6f 75 20 68 61  |sure that you ha|
00001ca0  76 65 20 61 20 52 49 53  43 20 4f 53 0a 70 72 69  |ve a RISC OS.pri|
00001cb0  6e 74 65 72 20 64 72 69  76 65 72 20 6c 6f 61 64  |nter driver load|
00001cc0  65 64 20 61 6e 64 20 63  6f 72 72 65 63 74 6c 79  |ed and correctly|
00001cd0  20 73 65 74 20 75 70 2e  20 4e 6f 77 0a 73 65 6c  | set up. Now.sel|
00001ce0  65 63 74 20 74 68 65 20  22 46 69 6c 65 2d 3e 50  |ect the "File->P|
00001cf0  72 69 6e 74 2e 2e 2e 22  20 69 74 65 6d 2e 20 41  |rint..." item. A|
00001d00  20 64 69 61 6c 6f 67 20  62 6f 78 0a 77 69 6c 6c  | dialog box.will|
00001d10  20 61 70 70 65 61 72 2c  20 74 65 6c 6c 69 6e 67  | appear, telling|
00001d20  20 79 6f 75 20 68 6f 77  20 6d 61 6e 79 20 70 61  | you how many pa|
00001d30  67 65 73 20 77 69 6c 6c  20 62 65 0a 6e 65 65 64  |ges will be.need|
00001d40  65 64 20 74 6f 20 70 72  69 6e 74 20 74 68 65 20  |ed to print the |
00001d50  74 61 62 6c 65 2e 20 45  6e 74 65 72 20 74 68 65  |table. Enter the|
00001d60  20 6e 75 6d 62 65 72 20  6f 66 0a 63 6f 70 69 65  | number of.copie|
00001d70  73 20 79 6f 75 20 77 69  73 68 20 74 6f 20 70 72  |s you wish to pr|
00001d80  69 6e 74 2c 20 74 68 65  6e 20 63 6c 69 63 6b 20  |int, then click |
00001d90  6f 6e 20 74 68 65 20 50  72 69 6e 74 0a 62 75 74  |on the Print.but|
00001da0  74 6f 6e 2e 0a 0a 57 6f  72 6b 69 6e 67 20 77 69  |ton...Working wi|
00001db0  74 68 20 44 54 50 20 70  61 63 6b 61 67 65 73 0a  |th DTP packages.|
00001dc0  54 61 62 6c 65 43 61 6c  63 20 63 61 6e 20 65 78  |TableCalc can ex|
00001dd0  70 6f 72 74 20 73 74 61  6e 64 61 72 64 20 64 72  |port standard dr|
00001de0  61 77 20 66 69 6c 65 73  20 66 6f 72 20 75 73 65  |aw files for use|
00001df0  0a 77 69 74 68 20 61 20  77 69 64 65 20 72 61 6e  |.with a wide ran|
00001e00  67 65 20 6f 66 20 44 54  50 20 61 6e 64 20 6d 75  |ge of DTP and mu|
00001e10  6c 74 69 6d 65 64 69 61  20 70 61 63 6b 61 67 65  |ltimedia package|
00001e20  73 2e 0a 54 6f 20 65 78  70 6f 72 74 20 61 20 64  |s..To export a d|
00001e30  72 61 77 20 66 69 6c 65  2c 20 70 72 65 73 73 20  |raw file, press |
00001e40  4d 45 4e 55 20 61 6e 64  20 66 6f 6c 6c 6f 77 20  |MENU and follow |
00001e50  74 68 65 0a 22 46 69 6c  65 2d 3e 45 78 70 6f 72  |the."File->Expor|
00001e60  74 2d 3e 44 72 61 77 22  20 69 74 65 6d 2e 20 54  |t->Draw" item. T|
00001e70  68 69 73 20 6c 65 61 64  73 20 74 6f 20 61 20 73  |his leads to a s|
00001e80  61 76 65 0a 62 6f 78 2e  20 48 61 76 69 6e 67 20  |ave.box. Having |
00001e90  73 61 76 65 64 20 61 20  64 72 61 77 20 66 69 6c  |saved a draw fil|
00001ea0  65 2c 20 69 74 20 63 61  6e 20 62 65 20 64 72 6f  |e, it can be dro|
00001eb0  70 70 65 64 0a 73 74 72  61 69 67 68 74 20 69 6e  |pped.straight in|
00001ec0  74 6f 20 61 20 44 54 50  20 70 72 6f 67 72 61 6d  |to a DTP program|
00001ed0  2c 20 6f 72 20 6c 6f 61  64 65 64 20 69 6e 74 6f  |, or loaded into|
00001ee0  20 21 44 72 61 77 0a 66  6f 72 20 66 75 72 74 68  | !Draw.for furth|
00001ef0  65 72 20 65 64 69 74 69  6e 67 2e 20 4e 6f 74 65  |er editing. Note|
00001f00  20 74 68 61 74 20 63 65  72 74 61 69 6e 20 44 54  | that certain DT|
00001f10  50 0a 70 61 63 6b 61 67  65 73 20 73 75 70 70 6f  |P.packages suppo|
00001f20  72 74 20 4f 4c 45 2c 20  77 68 69 63 68 20 70 72  |rt OLE, which pr|
00001f30  6f 76 69 64 65 73 20 61  6e 20 65 61 73 69 65 72  |ovides an easier|
00001f40  0a 61 6c 74 65 72 6e 61  74 69 76 65 2e 20 53 65  |.alternative. Se|
00001f50  65 20 74 68 65 20 6e 65  78 74 20 73 65 63 74 69  |e the next secti|
00001f60  6f 6e 20 66 6f 72 20 6d  6f 72 65 0a 64 65 74 61  |on for more.deta|
00001f70  69 6c 73 2e 0a 4f 4c 45  20 73 75 70 70 6f 72 74  |ils..OLE support|
00001f80  0a 54 61 62 6c 65 43 61  6c 63 20 73 75 70 70 6f  |.TableCalc suppo|
00001f90  72 74 73 20 6f 62 6a 65  63 74 20 6c 69 6e 6b 69  |rts object linki|
00001fa0  6e 67 20 61 6e 64 20 65  6d 62 65 64 64 69 6e 67  |ng and embedding|
00001fb0  0a 28 4f 4c 45 29 20 77  69 74 68 20 61 70 70 72  |.(OLE) with appr|
00001fc0  6f 70 72 69 61 74 65 20  70 72 6f 67 72 61 6d 73  |opriate programs|
00001fd0  2e 20 50 72 6f 67 72 61  6d 73 20 77 68 69 63 68  |. Programs which|
00001fe0  0a 63 75 72 72 65 6e 74  6c 79 20 73 75 70 70 6f  |.currently suppo|
00001ff0  72 74 20 4f 4c 45 20 69  6e 63 6c 75 64 65 20 43  |rt OLE include C|
00002000  6f 6d 70 75 74 65 72 20  43 6f 6e 63 65 70 74 73  |omputer Concepts|
00002010  27 0a 49 6d 70 72 65 73  73 69 6f 6e 2e 20 54 6f  |'.Impression. To|
00002020  20 70 65 72 66 6f 72 6d  20 4f 4c 45 2c 20 73 69  | perform OLE, si|
00002030  6d 70 6c 79 20 64 72 6f  70 20 61 20 74 61 62 6c  |mply drop a tabl|
00002040  65 0a 66 69 6c 65 20 69  6e 74 6f 20 61 20 66 72  |e.file into a fr|
00002050  61 6d 65 20 6f 72 20 64  6f 63 75 6d 65 6e 74 2e  |ame or document.|
00002060  20 49 74 20 77 69 6c 6c  20 62 65 0a 64 69 73 70  | It will be.disp|
00002070  6c 61 79 65 64 20 61 73  20 6e 6f 72 6d 61 6c 2e  |layed as normal.|
00002080  20 49 66 20 79 6f 75 20  77 69 73 68 20 74 6f 20  | If you wish to |
00002090  65 64 69 74 20 74 68 65  0a 74 61 62 6c 65 2c 20  |edit the.table, |
000020a0  68 6f 6c 64 20 64 6f 77  6e 20 3c 43 54 52 4c 3e  |hold down <CTRL>|
000020b0  20 61 6e 64 20 64 6f 75  62 6c 65 20 63 6c 69 63  | and double clic|
000020c0  6b 20 6f 6e 20 74 68 65  0a 66 72 61 6d 65 2e 20  |k on the.frame. |
000020d0  48 61 76 69 6e 67 20 65  64 69 74 65 64 20 61 20  |Having edited a |
000020e0  74 61 62 6c 65 20 77 68  69 63 68 20 77 61 73 20  |table which was |
000020f0  6c 6f 61 64 65 64 20 62  79 0a 4f 4c 45 2c 20 74  |loaded by.OLE, t|
00002100  68 65 20 6f 72 69 67 69  6e 61 6c 20 63 61 6e 20  |he original can |
00002110  62 65 20 61 6c 74 65 72  65 64 20 62 79 20 70 72  |be altered by pr|
00002120  65 73 73 69 6e 67 20 3c  46 33 3e 0a 74 68 65 6e  |essing <F3>.then|
00002130  20 3c 52 45 54 55 52 4e  3e 0a 4f 4c 45 20 73 75  | <RETURN>.OLE su|
00002140  70 70 6f 72 74 20 49 49  0a 4f 4c 45 20 6f 6e 6c  |pport II.OLE onl|
00002150  79 20 77 6f 72 6b 73 20  63 6f 72 72 65 63 74 6c  |y works correctl|
00002160  79 20 69 66 20 74 68 65  20 22 73 61 76 65 20 77  |y if the "save w|
00002170  69 74 68 0a 67 72 61 70  68 69 63 73 22 20 6f 70  |ith.graphics" op|
00002180  74 69 6f 6e 20 69 73 20  74 75 72 6e 65 64 20 6f  |tion is turned o|
00002190  6e 20 66 72 6f 6d 20 74  68 65 20 74 61 62 6c 65  |n from the table|
000021a0  0a 63 68 6f 69 63 65 73  20 64 69 61 6c 6f 67 20  |.choices dialog |
000021b0  62 6f 78 2e 20 4e 6f 74  65 2c 20 68 6f 77 65 76  |box. Note, howev|
000021c0  65 72 2c 20 74 68 61 74  20 66 69 6c 65 73 20 77  |er, that files w|
000021d0  68 69 63 68 0a 61 72 65  20 73 61 76 65 64 20 77  |hich.are saved w|
000021e0  69 74 68 20 67 72 61 70  68 69 63 73 20 61 72 65  |ith graphics are|
000021f0  20 73 69 67 6e 69 66 69  63 61 6e 74 6c 79 20 6c  | significantly l|
00002200  61 72 67 65 72 0a 74 68  61 6e 20 74 68 6f 73 65  |arger.than those|
00002210  20 77 68 69 63 68 20 61  72 65 20 6e 6f 74 2e 20  | which are not. |
00002220  54 68 65 72 65 66 6f 72  65 2c 20 69 74 20 69 73  |Therefore, it is|
00002230  0a 72 65 63 6f 6d 6d 65  6e 64 65 64 20 74 68 61  |.recommended tha|
00002240  74 20 74 68 65 20 22 53  61 76 65 20 77 69 74 68  |t the "Save with|
00002250  20 67 72 61 70 68 69 63  73 22 20 6f 70 74 69 6f  | graphics" optio|
00002260  6e 0a 69 73 20 74 75 72  6e 65 64 20 6f 66 66 20  |n.is turned off |
00002270  69 66 20 79 6f 75 20 61  72 65 20 6e 6f 74 20 75  |if you are not u|
00002280  73 69 6e 67 20 4f 4c 45  2e 20 54 68 65 20 67 6c  |sing OLE. The gl|
00002290  6f 62 61 6c 0a 63 68 6f  69 63 65 73 20 64 69 61  |obal.choices dia|
000022a0  6c 6f 67 20 62 6f 78 20  61 6c 6c 6f 77 73 20 79  |log box allows y|
000022b0  6f 75 20 74 6f 20 73 70  65 63 69 66 79 20 74 68  |ou to specify th|
000022c0  65 0a 64 65 66 61 75 6c  74 20 76 61 6c 75 65 20  |e.default value |
000022d0  6f 66 20 74 68 65 20 22  53 61 76 65 20 77 69 74  |of the "Save wit|
000022e0  68 20 67 72 61 70 68 69  63 73 22 20 6f 70 74 69  |h graphics" opti|
000022f0  6f 6e 2e 0a 0a 53 70 72  65 61 64 73 68 65 65 74  |on...Spreadsheet|
00002300  73 0a 41 73 20 77 65 6c  6c 20 61 73 20 6e 6f 72  |s.As well as nor|
00002310  6d 61 6c 20 74 65 78 74  2c 20 73 6c 6f 74 73 20  |mal text, slots |
00002320  69 6e 20 54 61 62 6c 65  43 61 6c 63 20 74 61 62  |in TableCalc tab|
00002330  6c 65 73 0a 63 61 6e 20  63 6f 6e 74 61 69 6e 20  |les.can contain |
00002340  6e 75 6d 62 65 72 20 73  6c 6f 74 73 2e 20 54 6f  |number slots. To|
00002350  20 63 72 65 61 74 65 20  61 20 6e 75 6d 62 65 72  | create a number|
00002360  20 73 6c 6f 74 2c 0a 70  6f 73 69 74 69 6f 6e 20  | slot,.position |
00002370  74 68 65 20 63 61 72 65  74 20 69 6e 20 61 20 62  |the caret in a b|
00002380  6c 61 6e 6b 20 73 6c 6f  74 2c 20 74 68 65 6e 20  |lank slot, then |
00002390  73 65 6c 65 63 74 0a 74  68 65 20 22 53 6c 6f 74  |select.the "Slot|
000023a0  73 2d 3e 45 64 69 74 20  45 78 70 72 65 73 73 69  |s->Edit Expressi|
000023b0  6f 6e 22 20 6d 65 6e 75  20 69 74 65 6d 2e 20 45  |on" menu item. E|
000023c0  6e 74 65 72 20 61 0a 6e  75 6d 62 65 72 20 69 6e  |nter a.number in|
000023d0  74 6f 20 74 68 65 20 77  72 69 74 61 62 6c 65 20  |to the writable |
000023e0  69 63 6f 6e 2c 20 74 68  65 6e 20 63 6c 69 63 6b  |icon, then click|
000023f0  20 6f 6e 20 74 68 65 0a  53 65 74 20 62 75 74 74  | on the.Set butt|
00002400  6f 6e 2c 20 6f 72 20 70  72 65 73 73 20 72 65 74  |on, or press ret|
00002410  75 72 6e 2e 0a 0a 4f 74  68 65 72 20 6e 75 6d 62  |urn...Other numb|
00002420  65 72 20 65 6e 74 72 79  20 6d 65 74 68 6f 64 73  |er entry methods|
00002430  0a 49 66 20 79 6f 75 20  77 69 73 68 20 74 6f 20  |.If you wish to |
00002440  65 6e 74 65 72 20 61 20  73 65 71 75 65 6e 63 65  |enter a sequence|
00002450  20 6f 66 20 6e 75 6d 62  65 72 73 20 77 69 74 68  | of numbers with|
00002460  20 61 0a 63 6f 6e 73 74  61 6e 74 20 64 69 66 66  | a.constant diff|
00002470  65 72 65 6e 63 65 20 28  65 2e 67 2e 20 31 2c 33  |erence (e.g. 1,3|
00002480  2c 35 2c 2e 2e 2e 29 2c  20 74 68 65 20 73 6c 6f  |,5,...), the slo|
00002490  74 0a 69 6e 69 74 69 61  6c 69 73 65 72 20 63 61  |t.initialiser ca|
000024a0  6e 20 62 65 20 75 73 65  64 2e 20 54 6f 20 75 73  |n be used. To us|
000024b0  65 20 69 74 2c 20 73 65  6c 65 63 74 20 61 20 62  |e it, select a b|
000024c0  6c 6f 63 6b 0a 74 68 65  6e 20 70 72 65 73 73 20  |lock.then press |
000024d0  4d 45 4e 55 20 61 6e 64  20 73 65 6c 65 63 74 20  |MENU and select |
000024e0  74 68 65 0a 53 6c 6f 74  73 2d 3e 49 6e 69 74 69  |the.Slots->Initi|
000024f0  61 6c 69 73 65 2e 2e 2e  20 69 74 65 6d 2e 20 45  |alise... item. E|
00002500  6e 74 65 72 20 74 68 65  20 69 6e 69 74 69 61 6c  |nter the initial|
00002510  20 76 61 6c 75 65 0a 61  6e 64 20 64 69 66 66 65  | value.and diffe|
00002520  72 65 6e 63 65 2c 20 74  68 65 6e 20 63 6c 69 63  |rence, then clic|
00002530  6b 20 6f 6e 20 74 68 65  20 46 69 6c 6c 20 62 75  |k on the Fill bu|
00002540  74 74 6f 6e 2e 20 49 66  0a 79 6f 75 20 77 69 73  |tton. If.you wis|
00002550  68 20 74 6f 20 65 6e 74  65 72 20 61 20 6c 61 72  |h to enter a lar|
00002560  67 65 20 6e 75 6d 62 65  72 20 6f 66 20 66 69 67  |ge number of fig|
00002570  75 72 65 73 20 77 69 74  68 0a 6e 6f 20 63 6f 6e  |ures with.no con|
00002580  73 74 61 6e 74 20 64 69  66 66 65 72 65 6e 63 65  |stant difference|
00002590  2c 20 74 68 65 79 20 63  61 6e 20 62 65 20 65 6e  |, they can be en|
000025a0  74 65 72 65 64 20 69 6e  0a 73 74 61 6e 64 61 72  |tered in.standar|
000025b0  64 20 74 65 78 74 20 73  6c 6f 74 73 2c 20 74 68  |d text slots, th|
000025c0  65 6e 20 63 6f 6e 76 65  72 74 65 64 20 74 6f 20  |en converted to |
000025d0  6e 75 6d 62 65 72 73 0a  73 6c 6f 74 73 20 75 73  |numbers.slots us|
000025e0  69 6e 67 20 74 68 65 20  22 53 6c 6f 74 73 2d 3e  |ing the "Slots->|
000025f0  54 65 78 74 20 74 6f 20  6e 75 6d 62 65 72 73 22  |Text to numbers"|
00002600  20 69 74 65 6d 2e 0a 45  78 70 72 65 73 73 69 6f  | item..Expressio|
00002610  6e 73 0a 41 73 20 77 65  6c 6c 20 61 73 20 73 69  |ns.As well as si|
00002620  6d 70 6c 65 20 6e 75 6d  62 65 72 73 2c 20 6e 75  |mple numbers, nu|
00002630  6d 62 65 72 20 73 6c 6f  74 73 20 63 61 6e 0a 63  |mber slots can.c|
00002640  6f 6e 74 61 69 6e 20 6d  61 74 68 65 6d 61 74 69  |ontain mathemati|
00002650  63 61 6c 20 65 78 70 72  65 73 73 69 6f 6e 73 2e  |cal expressions.|
00002660  20 45 78 70 72 65 73 73  69 6f 6e 73 20 63 61 6e  | Expressions can|
00002670  0a 62 65 20 69 6e 20 74  65 72 6d 73 20 6f 66 20  |.be in terms of |
00002680  6e 75 6d 62 65 72 73 20  28 65 2e 67 2e 20 32 2b  |numbers (e.g. 2+|
00002690  32 29 2c 20 6f 72 20 74  68 65 79 20 63 61 6e 0a  |2), or they can.|
000026a0  72 65 66 65 72 20 74 6f  20 6f 74 68 65 72 20 73  |refer to other s|
000026b0  6c 6f 74 73 20 77 69 74  68 69 6e 20 74 68 65 20  |lots within the |
000026c0  74 61 62 6c 65 2e 20 53  6c 6f 74 73 20 61 72 65  |table. Slots are|
000026d0  0a 72 65 66 65 72 72 65  64 20 74 6f 20 62 79 20  |.referred to by |
000026e0  61 20 6c 65 74 74 65 72  20 61 6e 64 20 61 20 6e  |a letter and a n|
000026f0  75 6d 62 65 72 2e 20 28  65 2e 67 2e 20 42 34 29  |umber. (e.g. B4)|
00002700  2e 0a 54 68 65 20 6c 65  74 74 65 72 20 72 65 66  |..The letter ref|
00002710  65 72 73 20 74 6f 20 74  68 65 20 63 6f 6c 75 6d  |ers to the colum|
00002720  6e 20 28 42 20 62 65 69  6e 67 20 74 68 65 0a 73  |n (B being the.s|
00002730  65 63 6f 6e 64 20 66 72  6f 6d 20 74 68 65 20 6c  |econd from the l|
00002740  65 66 74 29 2c 20 61 6e  64 20 74 68 65 20 6e 75  |eft), and the nu|
00002750  6d 62 65 72 20 72 65 66  65 72 73 20 74 6f 0a 74  |mber refers to.t|
00002760  68 65 20 72 6f 77 2e 20  41 20 74 79 70 69 63 61  |he row. A typica|
00002770  6c 20 65 78 70 72 65 73  73 69 6f 6e 20 75 73 69  |l expression usi|
00002780  6e 67 20 61 20 73 6c 6f  74 0a 72 65 66 65 72 65  |ng a slot.refere|
00002790  6e 63 65 20 77 6f 75 6c  64 20 62 65 20 28 43 33  |nce would be (C3|
000027a0  2b 32 29 2a 33 2e 0a 0a  54 68 65 20 65 78 70 72  |+2)*3...The expr|
000027b0  65 73 73 69 6f 6e 20 65  64 69 74 6f 72 0a 41 6e  |ession editor.An|
000027c0  79 20 65 78 70 72 65 73  73 69 6f 6e 20 63 61 6e  |y expression can|
000027d0  20 62 65 20 65 6e 74 65  72 65 64 20 69 6e 74 6f  | be entered into|
000027e0  20 74 68 65 20 77 72 69  74 61 62 6c 65 0a 66 69  | the writable.fi|
000027f0  65 6c 64 20 69 6e 20 74  68 65 20 65 78 70 72 65  |eld in the expre|
00002800  73 73 69 6f 6e 20 65 64  69 74 6f 72 20 66 72 6f  |ssion editor fro|
00002810  6d 20 74 68 65 20 6b 65  79 62 6f 61 72 64 2c 0a  |m the keyboard,.|
00002820  62 75 74 20 6d 61 6e 79  20 65 78 70 72 65 73 73  |but many express|
00002830  69 6f 6e 73 20 63 61 6e  20 62 65 20 22 62 75 69  |ions can be "bui|
00002840  6c 74 22 20 75 73 69 6e  67 20 74 68 65 0a 6f 74  |lt" using the.ot|
00002850  68 65 72 20 62 75 74 74  6f 6e 73 20 69 6e 20 74  |her buttons in t|
00002860  68 65 20 65 78 70 72 65  73 73 69 6f 6e 20 65 64  |he expression ed|
00002870  69 74 6f 72 2e 20 54 68  65 72 65 20 61 72 65 0a  |itor. There are.|
00002880  62 75 74 74 6f 6e 73 20  74 6f 20 69 6e 73 65 72  |buttons to inser|
00002890  74 20 74 68 65 20 62 61  73 69 63 20 61 72 69 74  |t the basic arit|
000028a0  68 6d 65 74 69 63 20 6f  70 65 72 61 74 6f 72 73  |hmetic operators|
000028b0  2c 0a 66 75 6e 63 74 69  6f 6e 73 20 28 73 65 65  |,.functions (see|
000028c0  20 6c 61 74 65 72 20 73  65 63 74 69 6f 6e 73 29  | later sections)|
000028d0  2c 20 70 61 69 72 73 20  6f 66 20 62 72 61 63 6b  |, pairs of brack|
000028e0  65 74 73 2c 0a 61 6e 64  20 61 6c 73 6f 20 74 68  |ets,.and also th|
000028f0  65 20 5e 20 73 79 6d 62  6f 6c 20 77 68 69 63 68  |e ^ symbol which|
00002900  20 69 73 20 75 73 65 64  20 74 6f 20 72 61 69 73  | is used to rais|
00002910  65 20 6f 6e 65 0a 6e 75  6d 62 65 72 20 74 6f 20  |e one.number to |
00002920  74 68 65 20 70 6f 77 65  72 20 6f 66 20 61 6e 6f  |the power of ano|
00002930  74 68 65 72 2e 20 53 6c  6f 74 20 72 65 66 65 72  |ther. Slot refer|
00002940  65 6e 63 65 73 0a 63 61  6e 20 62 65 20 69 6e 73  |ences.can be ins|
00002950  65 72 74 65 64 20 62 79  20 63 6c 69 63 6b 69 6e  |erted by clickin|
00002960  67 20 6f 6e 20 61 20 73  6c 6f 74 20 69 6e 20 74  |g on a slot in t|
00002970  68 65 20 6d 61 69 6e 0a  77 69 6e 64 6f 77 2e 0a  |he main.window..|
00002980  46 75 6e 63 74 69 6f 6e  73 0a 54 61 62 6c 65 43  |Functions.TableC|
00002990  61 6c 63 20 70 72 6f 76  69 64 65 73 20 61 20 72  |alc provides a r|
000029a0  61 6e 67 65 20 6f 66 20  66 75 6e 63 74 69 6f 6e  |ange of function|
000029b0  73 20 77 68 69 63 68 20  61 63 74 0a 6f 6e 20 6e  |s which act.on n|
000029c0  75 6d 62 65 72 73 2c 20  73 6c 6f 74 20 72 65 66  |umbers, slot ref|
000029d0  65 72 65 6e 63 65 73 2c  20 6f 72 20 65 78 70 72  |erences, or expr|
000029e0  65 73 73 69 6f 6e 73 2e  20 41 0a 66 75 6e 63 74  |essions. A.funct|
000029f0  69 6f 6e 20 69 73 20 75  73 65 64 20 66 72 6f 6d  |ion is used from|
00002a00  20 77 69 74 68 69 6e 20  61 6e 20 65 78 70 72 65  | within an expre|
00002a10  73 73 69 6f 6e 20 62 79  0a 65 6e 74 65 72 69 6e  |ssion by.enterin|
00002a20  67 20 74 68 65 20 6e 61  6d 65 20 6f 66 20 74 68  |g the name of th|
00002a30  65 20 66 75 6e 63 74 69  6f 6e 20 66 6f 6c 6c 6f  |e function follo|
00002a40  77 65 64 20 62 79 20 61  0a 70 61 69 72 20 6f 66  |wed by a.pair of|
00002a50  20 62 72 61 63 6b 65 74  73 20 63 6f 6e 74 61 69  | brackets contai|
00002a60  6e 69 6e 67 20 74 68 65  20 6e 75 6d 62 65 72 20  |ning the number |
00002a70  6f 72 0a 65 78 70 72 65  73 73 69 6f 6e 20 6f 6e  |or.expression on|
00002a80  20 77 68 69 63 68 20 79  6f 75 20 77 69 73 68 20  | which you wish |
00002a90  74 68 65 20 66 75 6e 63  74 69 6f 6e 20 74 6f 20  |the function to |
00002aa0  77 6f 72 6b 2e 0a 46 75  6e 63 74 69 6f 6e 73 20  |work..Functions |
00002ab0  63 61 6e 20 62 65 20 69  6e 73 65 72 74 65 64 20  |can be inserted |
00002ac0  69 6e 74 6f 20 65 78 70  72 65 73 73 69 6f 6e 73  |into expressions|
00002ad0  20 75 73 69 6e 67 0a 74  68 65 20 6d 6f 75 73 65  | using.the mouse|
00002ae0  20 62 79 20 63 6c 69 63  6b 69 6e 67 20 6f 6e 20  | by clicking on |
00002af0  74 68 65 20 66 6e 28 29  20 62 75 74 74 6f 6e 2c  |the fn() button,|
00002b00  20 61 6e 64 0a 73 65 6c  65 63 74 69 6e 67 20 61  | and.selecting a|
00002b10  20 66 75 6e 63 74 69 6f  6e 20 66 72 6f 6d 20 74  | function from t|
00002b20  68 65 20 72 65 73 75 6c  74 69 6e 67 20 6d 65 6e  |he resulting men|
00002b30  75 2e 0a 0a 46 75 6e 63  74 69 6f 6e 73 20 61 76  |u...Functions av|
00002b40  61 69 6c 61 62 6c 65 0a  54 61 62 6c 65 63 61 6c  |ailable.Tablecal|
00002b50  63 20 63 75 72 72 65 6e  74 6c 79 20 70 72 6f 76  |c currently prov|
00002b60  69 64 65 73 20 61 20 73  71 75 61 72 65 20 72 6f  |ides a square ro|
00002b70  6f 74 0a 66 75 6e 63 74  69 6f 6e 2c 20 61 20 56  |ot.function, a V|
00002b80  41 54 20 66 75 6e 63 74  69 6f 6e 20 61 6e 64 20  |AT function and |
00002b90  61 20 73 65 74 20 6f 66  20 74 72 69 67 6f 6e 6f  |a set of trigono|
00002ba0  6d 65 74 72 69 63 0a 61  6e 64 20 69 6e 76 65 72  |metric.and inver|
00002bb0  73 65 20 74 72 69 67 6f  6e 6f 6d 65 74 72 69 63  |se trigonometric|
00002bc0  20 66 75 6e 63 74 69 6f  6e 73 2c 20 74 6f 67 65  | functions, toge|
00002bd0  74 68 65 72 20 77 69 74  68 0a 61 20 70 61 69 72  |ther with.a pair|
00002be0  20 6f 66 20 66 75 6e 63  74 69 6f 6e 73 20 74 6f  | of functions to|
00002bf0  20 63 6f 6e 76 65 72 74  20 66 72 6f 6d 20 64 65  | convert from de|
00002c00  67 72 65 65 73 20 74 6f  0a 72 61 64 69 61 6e 73  |grees to.radians|
00002c10  20 61 6e 64 20 62 61 63  6b 20 61 67 61 69 6e 2e  | and back again.|
00002c20  20 4e 6f 74 65 20 74 68  61 74 20 61 6c 6c 20 74  | Note that all t|
00002c30  68 65 20 74 72 69 67 0a  66 75 6e 63 74 69 6f 6e  |he trig.function|
00002c40  73 20 63 75 72 72 65 6e  74 6c 79 20 77 6f 72 6b  |s currently work|
00002c50  20 69 6e 20 64 65 67 72  65 65 73 2c 20 4e 4f 54  | in degrees, NOT|
00002c60  20 72 61 64 69 61 6e 73  2e 0a 0a 53 70 72 65 61  | radians...Sprea|
00002c70  64 73 68 65 65 74 20 62  6c 6f 63 6b 20 66 75 6e  |dsheet block fun|
00002c80  63 74 69 6f 6e 73 0a 41  73 20 77 65 6c 6c 20 61  |ctions.As well a|
00002c90  73 20 74 68 65 20 66 75  6e 63 74 69 6f 6e 73 20  |s the functions |
00002ca0  64 65 73 63 72 69 62 65  64 20 61 62 6f 76 65 2c  |described above,|
00002cb0  20 77 68 69 63 68 0a 61  63 74 20 6f 6e 20 6e 75  | which.act on nu|
00002cc0  6d 62 65 72 73 2c 20 54  61 62 6c 65 43 61 6c 63  |mbers, TableCalc|
00002cd0  20 70 72 6f 76 69 64 65  73 20 73 65 76 65 72 61  | provides severa|
00002ce0  6c 0a 66 75 6e 63 74 69  6f 6e 73 20 77 68 69 63  |l.functions whic|
00002cf0  68 20 61 63 74 20 6f 6e  20 62 6c 6f 63 6b 73 20  |h act on blocks |
00002d00  6f 66 20 73 6c 6f 74 73  2e 20 43 75 72 72 65 6e  |of slots. Curren|
00002d10  74 6c 79 0a 61 76 61 69  6c 61 62 6c 65 20 62 6c  |tly.available bl|
00002d20  6f 63 6b 20 20 66 75 6e  63 74 69 6f 6e 73 20 61  |ock  functions a|
00002d30  72 65 20 73 75 6d 28 29  20 61 6e 64 0a 61 76 65  |re sum() and.ave|
00002d40  72 61 67 65 28 29 2e 20  42 6f 74 68 20 74 68 65  |rage(). Both the|
00002d50  73 65 20 66 75 6e 63 74  69 6f 6e 73 20 73 68 6f  |se functions sho|
00002d60  75 6c 64 20 62 65 20 70  61 73 73 65 64 0a 54 57  |uld be passed.TW|
00002d70  4f 20 73 6c 6f 74 20 72  65 66 65 72 65 6e 63 65  |O slot reference|
00002d80  73 20 72 65 66 65 72 72  69 6e 67 20 74 6f 20 64  |s referring to d|
00002d90  69 61 67 6f 6e 61 6c 6c  79 0a 6f 70 70 6f 73 69  |iagonally.opposi|
00002da0  74 65 20 63 6f 72 6e 65  72 73 20 6f 66 20 61 20  |te corners of a |
00002db0  62 6c 6f 63 6b 20 65 2e  67 2e 20 73 75 6d 28 61  |block e.g. sum(a|
00002dc0  32 62 36 29 2e 20 54 68  65 73 65 0a 66 75 6e 63  |2b6). These.func|
00002dd0  74 69 6f 6e 73 20 68 61  76 65 20 73 70 65 63 69  |tions have speci|
00002de0  61 6c 20 62 75 74 74 6f  6e 73 20 74 6f 20 69 6e  |al buttons to in|
00002df0  73 65 72 74 20 74 68 65  6d 2e 20 54 68 65 0a 22  |sert them. The."|
00002e00  73 69 67 6d 61 22 20 62  75 74 74 6f 6e 20 69 6e  |sigma" button in|
00002e10  73 65 72 74 73 20 73 75  6d 28 29 2c 20 61 6e 64  |serts sum(), and|
00002e20  20 74 68 65 20 22 58 20  62 61 72 22 0a 62 75 74  | the "X bar".but|
00002e30  74 6f 6e 20 69 6e 73 65  72 74 73 20 61 76 65 72  |ton inserts aver|
00002e40  61 67 65 28 29 2e 0a 43  6f 6e 73 74 61 6e 74 20  |age()..Constant |
00002e50  66 75 6e 63 74 69 6f 6e  73 0a 54 61 62 6c 65 43  |functions.TableC|
00002e60  61 6c 63 20 70 72 6f 76  69 64 65 73 20 74 77 6f  |alc provides two|
00002e70  20 22 63 6f 6e 73 74 61  6e 74 22 20 66 75 6e 63  | "constant" func|
00002e80  74 69 6f 6e 73 2c 0a 6e  61 6d 65 6c 79 20 63 6f  |tions,.namely co|
00002e90  6e 73 74 5f 70 69 28 29  20 61 6e 64 20 63 6f 6e  |nst_pi() and con|
00002ea0  73 74 5f 65 28 29 2e 20  54 68 65 73 65 20 74 61  |st_e(). These ta|
00002eb0  6b 65 20 6e 6f 0a 61 72  67 75 6d 65 6e 74 73 2c  |ke no.arguments,|
00002ec0  20 61 6e 64 20 72 65 74  75 72 6e 20 74 68 65 20  | and return the |
00002ed0  61 70 70 72 6f 70 72 69  61 74 65 20 6d 61 74 68  |appropriate math|
00002ee0  65 6d 61 74 69 63 61 6c  0a 63 6f 6e 73 74 61 6e  |ematical.constan|
00002ef0  74 20 28 63 6f 72 72 65  63 74 20 74 6f 20 31 30  |t (correct to 10|
00002f00  20 73 69 67 6e 69 66 69  63 61 6e 74 20 66 69 67  | significant fig|
00002f10  75 72 65 73 29 2e 20 41  0a 74 79 70 69 63 61 6c  |ures). A.typical|
00002f20  20 75 73 65 20 77 6f 75  6c 64 20 62 65 20 69 6e  | use would be in|
00002f30  20 74 68 65 20 65 78 70  72 65 73 73 69 6f 6e 0a  | the expression.|
00002f40  28 63 6f 6e 73 74 5f 70  69 28 29 2a 28 31 30 5e  |(const_pi()*(10^|
00002f50  32 29 29 2c 20 77 68 69  63 68 20 72 65 74 75 72  |2)), which retur|
00002f60  6e 73 20 74 68 65 20 61  72 65 61 20 6f 66 20 61  |ns the area of a|
00002f70  0a 63 69 72 63 6c 65 20  6f 66 20 72 61 64 69 75  |.circle of radiu|
00002f80  73 20 31 30 20 75 6e 69  74 73 2e 0a 0a 46 6f 72  |s 10 units...For|
00002f90  6d 75 6c 61 20 72 65 70  6c 69 63 61 74 69 6f 6e  |mula replication|
00002fa0  0a 49 66 20 79 6f 75 20  68 61 76 65 20 65 6e 74  |.If you have ent|
00002fb0  65 72 65 64 20 61 6e 20  65 78 70 72 65 73 73 69  |ered an expressi|
00002fc0  6f 6e 20 69 6e 74 6f 20  61 20 73 6c 6f 74 2c 20  |on into a slot, |
00002fd0  69 74 0a 69 73 20 70 6f  73 73 69 62 6c 65 20 74  |it.is possible t|
00002fe0  6f 20 63 6f 70 79 20 69  74 20 69 6e 74 6f 20 74  |o copy it into t|
00002ff0  68 65 20 73 6c 6f 74 73  20 62 65 6c 6f 77 20 6f  |he slots below o|
00003000  72 20 74 6f 0a 74 68 65  20 72 69 67 68 74 2c 20  |r to.the right, |
00003010  62 79 20 73 65 6c 65 63  74 69 6e 67 20 61 20 62  |by selecting a b|
00003020  6c 6f 63 6b 20 74 68 65  6e 20 75 73 69 6e 67 20  |lock then using |
00003030  74 68 65 0a 22 53 6c 6f  74 73 2d 3e 43 6f 70 79  |the."Slots->Copy|
00003040  20 64 6f 77 6e 22 20 6f  72 20 22 43 6f 70 79 20  | down" or "Copy |
00003050  72 69 67 68 74 22 20 6d  65 6e 75 20 69 74 65 6d  |right" menu item|
00003060  73 2e 20 49 66 0a 74 68  65 20 65 78 70 72 65 73  |s. If.the expres|
00003070  73 69 6f 6e 20 63 6f 6e  74 61 69 6e 73 20 73 6c  |sion contains sl|
00003080  6f 74 20 72 65 66 65 72  65 6e 63 65 73 2c 20 74  |ot references, t|
00003090  68 65 73 65 20 61 72 65  0a 61 64 6a 75 73 74 65  |hese are.adjuste|
000030a0  64 20 61 70 70 72 6f 70  72 69 61 74 65 6c 79 20  |d appropriately |
000030b0  28 65 2e 67 2e 2c 20 69  66 20 41 31 2b 31 20 77  |(e.g., if A1+1 w|
000030c0  61 73 20 63 6f 70 69 65  64 0a 64 6f 77 6e 2c 20  |as copied.down, |
000030d0  69 74 20 77 6f 75 6c 64  20 62 65 63 6f 6d 65 20  |it would become |
000030e0  41 32 2b 31 20 69 6e 20  74 68 65 20 6e 65 78 74  |A2+1 in the next|
000030f0  20 73 6c 6f 74 20 64 6f  77 6e 29 2e 20 0a 0a 41  | slot down). ..A|
00003100  62 73 6f 6c 75 74 65 20  73 6c 6f 74 20 72 65 66  |bsolute slot ref|
00003110  65 72 65 6e 63 65 73 0a  49 66 20 79 6f 75 20 64  |erences.If you d|
00003120  6f 20 6e 6f 74 20 77 69  73 68 20 61 20 72 65 66  |o not wish a ref|
00003130  65 72 65 6e 63 65 20 74  6f 20 62 65 20 61 64 6a  |erence to be adj|
00003140  75 73 74 65 64 20 77 68  65 6e 0a 61 20 66 6f 72  |usted when.a for|
00003150  6d 75 6c 61 20 72 65 70  6c 69 63 61 74 69 6f 6e  |mula replication|
00003160  20 69 73 20 70 65 72 66  6f 72 6d 65 64 20 28 73  | is performed (s|
00003170  65 65 20 74 68 65 0a 70  72 65 76 69 6f 75 73 20  |ee the.previous |
00003180  73 65 63 74 69 6f 6e 29  2c 20 69 74 20 73 68 6f  |section), it sho|
00003190  75 6c 64 20 62 65 20 70  72 65 66 69 78 65 64 20  |uld be prefixed |
000031a0  62 79 20 74 68 65 0a 68  61 73 68 20 63 68 61 72  |by the.hash char|
000031b0  61 63 74 65 72 20 28 23  29 2e 20 53 75 63 68 20  |acter (#). Such |
000031c0  61 20 73 6c 6f 74 20 72  65 66 65 72 65 6e 63 65  |a slot reference|
000031d0  20 63 61 6e 20 62 65 0a  69 6e 73 65 72 74 65 64  | can be.inserted|
000031e0  20 62 79 20 63 6c 69 63  6b 69 6e 67 20 6f 6e 20  | by clicking on |
000031f0  61 20 73 6c 6f 74 20 77  69 74 68 20 74 68 65 20  |a slot with the |
00003200  61 64 6a 75 73 74 0a 62  75 74 74 6f 6e 2c 20 69  |adjust.button, i|
00003210  6e 73 74 65 61 64 20 6f  66 20 73 65 6c 65 63 74  |nstead of select|
00003220  2e 0a 0a 4f 74 68 65 72  20 73 70 72 65 61 64 73  |...Other spreads|
00003230  68 65 65 74 20 6f 70 65  72 61 74 69 6f 6e 73 0a  |heet operations.|
00003240  41 73 20 77 65 6c 6c 20  61 73 20 74 68 65 20 6f  |As well as the o|
00003250  70 65 72 61 74 69 6f 6e  73 20 64 65 73 63 72 69  |perations descri|
00003260  62 65 64 20 69 6e 20 74  68 65 0a 70 72 65 76 69  |bed in the.previ|
00003270  6f 75 73 20 73 65 63 74  69 6f 6e 73 2c 20 74 68  |ous sections, th|
00003280  65 72 65 20 61 72 65 20  74 77 6f 20 6f 74 68 65  |ere are two othe|
00003290  72 20 6d 65 6e 75 0a 6f  70 74 69 6f 6e 73 20 63  |r menu.options c|
000032a0  6f 6e 63 65 72 6e 69 6e  67 20 73 70 72 65 61 64  |oncerning spread|
000032b0  73 68 65 65 74 73 2e 20  54 68 65 79 20 61 72 65  |sheets. They are|
000032c0  20 62 6f 74 68 0a 6c 6f  63 61 74 65 64 20 6f 6e  | both.located on|
000032d0  20 74 68 65 20 22 53 6c  6f 74 73 22 20 73 75 62  | the "Slots" sub|
000032e0  6d 65 6e 75 2e 20 54 68  65 20 22 53 6e 61 70 73  |menu. The "Snaps|
000032f0  68 6f 74 22 0a 69 74 65  6d 20 63 6f 6e 76 65 72  |hot".item conver|
00003300  74 73 20 65 78 70 72 65  73 73 69 6f 6e 73 20 69  |ts expressions i|
00003310  6e 74 6f 20 6e 75 6d 62  65 72 73 2c 20 6d 61 6b  |nto numbers, mak|
00003320  69 6e 67 0a 74 68 65 6d  20 69 6e 64 65 70 65 6e  |ing.them indepen|
00003330  64 65 6e 74 20 6f 66 20  61 6e 79 20 63 68 61 6e  |dent of any chan|
00003340  67 65 73 20 74 6f 20 72  65 66 65 72 65 6e 63 65  |ges to reference|
00003350  64 0a 73 6c 6f 74 73 2e  20 54 68 65 20 22 4e 75  |d.slots. The "Nu|
00003360  6d 62 65 72 73 20 74 6f  20 74 65 78 74 22 20 69  |mbers to text" i|
00003370  74 65 6d 20 63 6f 6e 76  65 72 74 73 20 62 6f 74  |tem converts bot|
00003380  68 0a 6e 75 6d 62 65 72  20 61 6e 64 20 65 78 70  |h.number and exp|
00003390  72 65 73 73 69 6f 6e 20  73 6c 6f 74 73 20 74 6f  |ression slots to|
000033a0  20 74 65 78 74 20 73 6c  6f 74 73 2e 20 42 6f 74  | text slots. Bot|
000033b0  68 0a 74 68 65 73 65 20  6f 70 65 72 61 74 69 6f  |h.these operatio|
000033c0  6e 73 20 77 6f 72 6b 20  62 6f 74 68 20 6f 6e 20  |ns work both on |
000033d0  73 69 6e 67 6c 65 20 73  6c 6f 74 73 20 61 6e 64  |single slots and|
000033e0  0a 73 65 6c 65 63 74 65  64 20 62 6c 6f 63 6b 73  |.selected blocks|
000033f0  2e 0a 43 53 56 20 66 69  6c 65 20 73 75 70 70 6f  |..CSV file suppo|
00003400  72 74 0a 54 61 62 6c 65  43 61 6c 63 20 63 61 6e  |rt.TableCalc can|
00003410  20 6c 6f 61 64 20 61 6e  64 20 73 61 76 65 20 73  | load and save s|
00003420  74 61 6e 64 61 72 64 20  43 6f 6d 6d 61 0a 53 65  |tandard Comma.Se|
00003430  70 61 72 61 74 65 64 20  56 61 6c 75 65 20 28 43  |parated Value (C|
00003440  53 56 29 20 66 69 6c 65  73 2e 20 54 6f 20 6c 6f  |SV) files. To lo|
00003450  61 64 20 61 20 43 53 56  20 66 69 6c 65 2c 0a 64  |ad a CSV file,.d|
00003460  72 6f 70 20 69 74 20 6f  6e 20 74 68 65 20 54 61  |rop it on the Ta|
00003470  62 6c 65 43 61 6c 63 20  69 63 6f 6e 20 6f 6e 20  |bleCalc icon on |
00003480  74 68 65 20 69 63 6f 6e  20 62 61 72 20 28 43 53  |the icon bar (CS|
00003490  56 0a 66 69 6c 65 73 20  63 61 6e 6e 6f 74 20 62  |V.files cannot b|
000034a0  65 20 6c 6f 61 64 65 64  20 62 79 20 64 6f 75 62  |e loaded by doub|
000034b0  6c 65 2d 63 6c 69 63 6b  69 6e 67 29 2e 20 54 6f  |le-clicking). To|
000034c0  0a 73 61 76 65 20 61 20  74 61 62 6c 65 20 61 73  |.save a table as|
000034d0  20 61 20 43 53 56 20 66  69 6c 65 2c 20 75 73 65  | a CSV file, use|
000034e0  20 74 68 65 0a 46 69 6c  65 2d 3e 45 78 70 6f 72  | the.File->Expor|
000034f0  74 2d 3e 43 53 56 20 6d  65 6e 75 20 69 74 65 6d  |t->CSV menu item|
00003500  2e 20 49 66 20 61 20 62  6c 6f 63 6b 20 69 73 0a  |. If a block is.|
00003510  73 65 6c 65 63 74 65 64  2c 20 79 6f 75 20 77 69  |selected, you wi|
00003520  6c 6c 20 62 65 20 6f 66  66 65 72 65 64 20 74 68  |ll be offered th|
00003530  65 20 63 68 6f 69 63 65  20 74 6f 20 73 61 76 65  |e choice to save|
00003540  0a 6f 6e 6c 79 20 74 68  65 20 73 65 6c 65 63 74  |.only the select|
00003550  65 64 20 72 65 67 69 6f  6e 2e 0a 0a 54 61 62 6c  |ed region...Tabl|
00003560  65 20 63 68 6f 69 63 65  73 0a 45 61 63 68 20 74  |e choices.Each t|
00003570  61 62 6c 65 20 63 75 72  72 65 6e 74 6c 79 20 68  |able currently h|
00003580  61 73 20 74 77 6f 20 6f  70 74 69 6f 6e 73 20 61  |as two options a|
00003590  73 73 6f 63 69 61 74 65  64 0a 77 69 74 68 20 69  |ssociated.with i|
000035a0  74 2e 20 53 61 76 69 6e  67 20 6f 66 20 67 72 61  |t. Saving of gra|
000035b0  70 68 69 63 73 20 77 69  74 68 20 74 61 62 6c 65  |phics with table|
000035c0  20 66 69 6c 65 73 20 63  61 6e 0a 62 65 20 74 75  | files can.be tu|
000035d0  72 6e 65 64 20 6f 6e 20  61 6e 64 20 6f 66 66 20  |rned on and off |
000035e0  28 73 65 65 20 74 68 65  20 73 65 63 74 69 6f 6e  |(see the section|
000035f0  20 22 4f 4c 45 20 73 75  70 70 6f 72 74 0a 49 49  | "OLE support.II|
00003600  22 29 2c 20 61 73 20 63  61 6e 20 61 20 73 70 72  |"), as can a spr|
00003610  65 61 64 73 68 65 65 74  20 62 6f 72 64 65 72 20  |eadsheet border |
00003620  73 75 72 72 6f 75 6e 64  69 6e 67 20 74 68 65 0a  |surrounding the.|
00003630  74 61 62 6c 65 2c 20 77  68 69 63 68 20 73 68 6f  |table, which sho|
00003640  77 20 72 6f 77 20 6c 65  74 74 65 72 73 20 61 6e  |w row letters an|
00003650  64 20 63 6f 6c 75 6d 6e  20 6e 75 6d 62 65 72 73  |d column numbers|
00003660  2e 0a 0a 54 61 62 6c 65  43 61 6c 63 20 67 6c 6f  |...TableCalc glo|
00003670  62 61 6c 20 63 68 6f 69  63 65 73 0a 41 20 6e 75  |bal choices.A nu|
00003680  6d 62 65 72 20 6f 66 20  54 61 62 6c 65 43 61 6c  |mber of TableCal|
00003690  63 27 73 20 66 65 61 74  75 72 65 73 20 63 61 6e  |c's features can|
000036a0  20 62 65 20 63 75 73 74  6f 6d 69 73 65 64 0a 62  | be customised.b|
000036b0  79 20 74 68 65 20 75 73  65 72 2e 20 53 75 63 68  |y the user. Such|
000036c0  20 66 65 61 74 75 72 65  73 20 61 72 65 20 63 6f  | features are co|
000036d0  6e 74 72 6f 6c 6c 65 64  20 62 79 0a 63 6c 69 63  |ntrolled by.clic|
000036e0  6b 69 6e 67 20 4d 45 4e  55 20 6f 76 65 72 20 74  |king MENU over t|
000036f0  68 65 20 69 63 6f 6e 20  62 61 72 20 69 63 6f 6e  |he icon bar icon|
00003700  2c 20 74 68 65 6e 0a 73  65 6c 65 63 74 69 6e 67  |, then.selecting|
00003710  20 22 43 68 6f 69 63 65  73 2e 2e 2e 22 2e 20 43  | "Choices...". C|
00003720  68 6f 69 63 65 73 20 63  75 72 72 65 6e 74 6c 79  |hoices currently|
00003730  0a 61 76 61 69 6c 61 62  6c 65 20 69 6e 63 6c 75  |.available inclu|
00003740  64 65 3a 20 43 6f 6e 66  69 72 6d 61 74 69 6f 6e  |de: Confirmation|
00003750  20 77 68 65 6e 20 72 6f  77 73 20 61 6e 64 0a 63  | when rows and.c|
00003760  6f 6c 75 6d 6e 73 20 61  72 65 20 64 65 6c 65 74  |olumns are delet|
00003770  65 64 2c 20 74 68 65 20  69 6e 69 74 69 61 6c 20  |ed, the initial |
00003780  73 74 61 74 65 20 6f 66  20 74 68 65 0a 22 53 61  |state of the."Sa|
00003790  76 65 20 77 69 74 68 20  67 72 61 70 68 69 63 73  |ve with graphics|
000037a0  22 20 66 6c 61 67 20 66  6f 72 20 6e 65 77 6c 79  |" flag for newly|
000037b0  20 63 72 65 61 74 65 64  0a 64 6f 63 75 6d 65 6e  | created.documen|
000037c0  74 73 2c 20 61 75 74 6f  6d 61 74 69 63 20 64 69  |ts, automatic di|
000037d0  73 70 6c 61 79 20 6f 66  20 74 68 65 20 73 70 72  |splay of the spr|
000037e0  65 61 64 73 68 65 65 74  0a 62 6f 72 64 65 72 20  |eadsheet.border |
000037f0  77 68 65 6e 20 74 68 65  20 65 78 70 72 65 73 73  |when the express|
00003800  69 6f 6e 20 65 64 69 74  6f 72 20 69 73 20 75 73  |ion editor is us|
00003810  65 64 2c 20 61 6e 64 20  74 68 65 0a 63 75 72 72  |ed, and the.curr|
00003820  65 6e 74 20 56 41 54 20  72 61 74 65 2e 0a 43 6f  |ent VAT rate..Co|
00003830  70 79 72 69 67 68 74 20  6d 65 73 73 61 67 65 0a  |pyright message.|
00003840  54 61 62 6c 65 43 61 6c  63 20 20 69 73 20 a9 20  |TableCalc  is . |
00003850  69 53 56 2f 54 68 6f 6d  61 73 20 44 6f 77 6e 20  |iSV/Thomas Down |
00003860  31 39 39 34 0a 21 69 53  56 4d 61 6e 75 61 6c 20  |1994.!iSVManual |
00003870  69 73 20 a9 20 69 53 56  20 50 72 6f 64 75 63 74  |is . iSV Product|
00003880  73 20 31 39 39 33 0a 54  68 65 20 61 75 74 68 6f  |s 1993.The autho|
00003890  72 20 61 63 6b 6e 6f 77  6c 65 64 67 65 73 20 74  |r acknowledges t|
000038a0  68 65 20 75 73 65 20 6f  66 20 74 68 65 20 44 65  |he use of the De|
000038b0  73 6b 4c 69 62 0a 6c 69  62 72 61 72 79 20 69 6e  |skLib.library in|
000038c0  20 74 68 65 20 70 72 6f  64 75 63 74 69 6f 6e 20  | the production |
000038d0  6f 66 20 74 68 69 73 20  70 72 6f 67 72 61 6d 2e  |of this program.|
000038e0

Our privacy policy is here.
Last updated: 01 May 2025, 21:49 UTC
Website designed by .