Home » Archimedes archive » Apps » PipeDream 3 ()(Colton Software).adf » Documents/Features

Documents/Features

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 » Apps » PipeDream 3 ()(Colton Software).adf
Filename: Documents/Features
Read OK:
File size: 3F52 bytes
Load address: FFFDDE41
Exec address: D305DDB0
File contents
%OP%DFT
%OP%TM4
%OP%HM4
%OP%FM4
%OP%BM4
%CO:A,72,72%%H2%Changes between PipeDream 2 and PipeDream 3

The following is a brief introduction to the differences between 
versions 2 and 3 of PipeDream.  It is intended as a quick reference for 
users of previous versions of PipeDream to see what is available.  It 
does not attempt to go into detail over the new facilities - for this 
you will need to refer to the PipeDream User Guide.

%H2%Operating Systems

PipeDream version 3 works only under RISC OS and not under Arthur 1.2 
or earlier versions.  PipeDream version 2 works under both Arthur 1.2 
and RISC OS. 

%H2%SpellCheck

PipeDream version 3 incorporates PipeDream SpellCheck whereas 
SpellCheck was a separate option for PipeDream version 2.

%H2%Installation

Installation is much easier.  It comprises making a backup of the 
PipeDream master disc to a PipeDream working disc from which you will 
run PipeDream 3. The first time you run PipeDream 3 you will be asked 
to enter your name which will be included in the PipeDream program from 
then on.  Your PipeDream 3 disc also has a unique registration number 
identifying all working discs as having come from your master.

Having installed PipeDream fill in the registration card and return it 
to Colton Software.  You will then be a registered user. Only 
registered users are entitled to telephone support and upgrades to new 
releases.

Note that the unique registration number on the disc enables us to 
trace copies of your master disc.  You are allowed and welcome to make 
backup copies of the disc for your own use but you are not allowed to 
make copies of the disc for anyone else to use.  If you are unsure of 
your rights read the disc envelope carefully or phone Colton Software 
for guidance.

Software piracy is theft.  Thieves hurt genuine users just as much as 
they hurt software houses through giving upwards pressure on prices.  
We don't believe that the best way to stamp out software piracy is to 
protect discs because that makes life difficult for genuine users - the 
overwhelming majority.  Having unique registration numbers enables us 
to trace illegal copies very easily and to prosecute offenders 
effectively.

%H2%User Interface

PipeDream has been completely rewritten to take advantage of RISC OS in 
as many ways as possible.  A PipeDream document now appears in a window 
on the screen.  All of the resizing, scrolling and pointing operations 
are available, as are many drag and clicking operations.  The result is 
that PipeDream operates very much like Edit, rather than previous 
versions of PipeDream which took over the screen and took (almost) all 
input from the keyboard.

%H2%Many documents

PipeDream can cope with as many documents all loaded at once as can be 
fitted into memory.  Each document appears in its own window.  Note 
that it is one copy of PipeDream in the computer that is doing this, 
not one PipeDream for each window, so many documents can be loaded even 
on a 1Mbyte computer.

To see this in action make a selection of files in a directory viewer 
and drag the selection to the PipeDream icon on the icon bar.  Each 
file will be loaded into a new PipeDream window.

Blocks of data can be copied and moved between windows by marking a 
block in one window, positioning the caret in another and giving the 
relevant command.

%H2%Recovering deletions

PipeDream 2 remembered words and phrases that had been deleted and they 
could be recovered using the Paste command.  PipeDream 3 can also 
recover deleted rows, columns and blocks.  It maintains a list of up to 
255 deletions (the default is 50 and is configurable between 0-255) 
which can be pasted back into the text and any point by positioning the 
caret at the insertion point and giving the Paste command.

A block can be moved between windows by deleting it from one window and 
pasting it into another.

A new command Copy Block to Buffer is also provided which copies the 
the marked block to the paste list without deleting it from the text. 
It can be pasted in at any point, so that a copy of it is made.

%H2%Natural Recalculation

In addition to recalculating by row or column PipeDream 3 has natural 
recalculation.  This resolves problems of forward references where the 
spreadsheet might have to be recalculated more than once before all of 
the values were up-to-date.  With automatic recalculation on, it is 
usually significantly faster, as only those slots that change value, 
rather than all slots in the spreadsheet, are recalculated.

Natural recalculation requires extra memory to record the information 
as to which slots affect which others.  If PipeDream runs out of memory 
it will automatically switch to recalculation by column, giving a 
message saying it is doing so.  

%H2%Background, interruptible recalculation

PipeDream's recalculation is performed in short time-slices in the 
background so you can continue with other tasks whilst recalculation is 
proceeding.

%H2%Memory Usage

PipeDream 3 employs greater data compaction and more sparse matrix 
techniques enabling larger files to be loaded into the same amount of 
memory.  The amount of improvement will depend upon the data but, in 
general, the sparser the file (ie the more blank slots there are) the 
greater the improvement. 

Additionally PipeDream communicates intelligently with RISC OS to use 
only the amount of memory it needs at any time, giving memory back to 
the system when it is no longer needed.  It is very important for 
applications to cooperate in this way in a multi-tasking environment so 
that the very most may be made of the available memory (because there 
is never enough of it).  Applications cooperating in this manner are 
more usable and less frustrating.

%H2%Insert on return

Users of other word processors often prefer the current line to be 
split when they press the Return key and for the two lines to be joined 
again when a delete backwards is made at the beginning of the line or a 
delete forwards at the end of the line.  Others don't.

A new option Insert on return in the Options dialogue box enables users 
to set this either way.  Its status can also be saved in the 
initialisation file so that it is permanently the way you want it to 
be.

%H2%Replicate

There are two new commands which, in most cases, make replication 
faster and smoother than the using the Replicate command.  Replicate 
Right (Ctrl BRR) copies the left-most column of a marked block to all 
of the other columns in the block.  Replicate Down (Ctrl BRD) copies 
the top row of a block to all of the other rows in the block.  Since 
blocks can be marked very easily by dragging the mouse from one corner 
to an opposite corner and the commands can be selected from the menu 
with the mouse a replicate can be done very quickly without touching 
the keyboard.

The old command Replicate is still present and is the same as before.  

%H2%Alt-key sequences

In addition to the selection of commands from menus by using the mouse 
the hot-key sequences have been retained and are similar to those on 
all other versions of PipeDream.  Unfortunately however it was 
necessary for PipeDream to change to use the Ctrl key rather than the 
Alt keys as the shifting key.  This is because the specification of the 
Alt key was changed by Acorn to be used with foreign character sets, 
after PipeDream version 2 was written .  It was not possible within the 
rules of RISC OS for PipeDream to use the Alt key as a shifting key.

So on the Z88 the shifting key is <>, on the PC and Archimedes 
PipeDream version 2 it is Alt, and on RISC OS PipeDream it is Ctrl.  It 
is, of course, usually preferable to select commands from menus with 
the mouse.

The changes to the Alt key also mean that it is no longer possible for 
Alt + function key to be defined by the user.

%H2%Previous match (Ctrl BPM)

Previous match is the opposite of Next match and moves the caret back 
to the previous occurrence of the string given in the Search dialogue 
box.  It is most useful when inadvertently giving too many Next match 
commands but can be used for searching a file backwards if you so 
desire.

%H2%Subgrams (Ctrl SH)

Subgrams are like anagrams without the restriction that all letters of 
the original word must be used.  eg a, me, mad, dame and armed are all 
subgrams of Dream.  This feature will help you to impress your friends 
with your massive vocabulary and win newspaper competitions.

%H2%Carriage return and linefeed

The position with Archimedes software and carriage returns (CR) and 
linefeeds (LF) seems to be a little confused.  Some editors use CR as 
their line separator (deriving from BBC days), some editors use LF 
(deriving from UNIX), some editors use CR,LF (deriving from CP/M and 
MS-DOS).  It would be helpful if all editors could automatically load 
files of any type (like PipeDream can) but, sadly, this is not the 
case.  So PipeDream 3 has an option in the Save dialogue box which 
enables to specify what line separator to save the file with.  The 
options are CR, LF, CR+LF, LF+CR.

%H2%Negative numbers

Negative numbers in expression slots can be displayed on the screen in 
a different colour to the rest of the text.  This can be very striking 
when the colour chosen is red.

%H2%Centre window

This new command is provided to position the line containing the caret 
in the middle of the window.

%H2%Fixed rows and columns

The status of fixed rows and columns is now saved with the file.

%H2%Sorting

Sorting in PipeDream 3 is several times faster than version 2 (the 
exact factor depending on the data file).  PipeDream 3 can now sort 
multi-row records. Rows that are blank in the first key field are bound 
to the first row above that is not blank in the first key field.  This 
enables records containing paragraphs of text, for example, to be 
sorted.

%H2%Date format

A textual date format has been provided in addition to displaying dates 
in English or American formats.

%H2%File formats

PipeDream can now load and save VIEW files, can load ViewSheet files 
and can save Acorn DTP files.

%H2%Thousands

PipeDream 3 can display large numbers in a variety of ways.  Several 
separators can be used to separate thousands and millions.  For example

  1234567.89
1 234 567.78
1,234,567.89
1.234.567,89

%H2%Database functions

The syntax of database functions has been improved.  In PipeDream 2 the 
$ operator was used to determine both whether the slot reference should 
be updated during replication and also whether the slot reference 
should be updated during recalculation.  In PipeDream 3 each od these 
has its own operator.  $ is still used to determine whether the slot 
reference should be updated during replication.  # is used to determine 
whether the slot reference should be updated during recalculation.

This change means that database functions written in files for 
PipeDream 2 may produce different results in PipeDream 3 and database 
functions written in files for Pipedream 3 may not be accepted in 
Pipedream 2.  When converting files from PipeDream 2 to Pipedream 3 it 
is usually necessary to either replace $ signs in the condition string 
with a # or add a # and retain the $.

%H2%Spreadsheet functions

The following new spreadsheet functions have been provided:

ATN2(x,y)
MONTHDAYS(date)

RAND(n)
ROUND(n,p)
ROW(),COL()

DCOUNTA(range,condition)

%H2%Printing

As well as having its own printer driver system, PipeDream 3 can also 
print using the RISC OS printer drivers supplied by Acorn.  Which 
method you use is up to you.  The PipeDream drivers will usually be 
much faster than the RISC OS drivers because they just sending out 
lines of characters, whereas the RISC OS drivers build up pages of 
bit-mapped graphics.  Only the RISC OS drivers can print pictures and 
fonts.

Extra options have been added to the Print dialogue box to print 
multiple copies and two-sided printing.  Two-sided printing is 
reversing the order of parameters in headers and footers on even 
numbered (left-hand) pages and printing extra characters in the left 
margin of odd numbered (right-hand) pages.  Note that it is not the far 
more useful ability to print on both sides of the paper without your 
turning it over.  (That's a hardware problem.)

%H2%External references

With more than one file loaded it is possible to access slots in files 
in other windows, and so you can link several spreadsheets together to 
generate grand totals or create 3-dimensional models.

%H2%Save

After saving a file with a new name the file in memory is renamed also.

%H2%Save/Restore/Swap position

Save Position has been assigned to function key Shift F11.  Restore 
position has been assigned to function key Ctrl F11.  Swap position and 
caret has been assigned to function key F11.  This enables you to set a 
position with Shift F11, move somewhere else and toggle between the 
positions be pressing F11.

%H2%Macro recorder

PipeDream 3 has a macro recorder which enables you to build macro files 
very easily.  The procedure is very similar to using the *Spool 
command.  Giving the Record Macro File prompts you for the name of the 
file for the macros to be inserted into.  Then all text that 
you type and commands that you give, but not mouse movements, are 
stored in the file ready for you to use with the Do Macro File command.

Creating macro files in this way is much easier than typing the 
commands in yourself.  An additional benefit is that it generates files 
which you can load into PipeDream windows to examine, and edit if you 
wish.

One point to bear in mind if you have macro files that you have built 
for use with PipeDream 2 is that the format has been simplified a 
little.  Now only one command is allowed on a line in the macro file - 
any text after the |m is treated as comment and ignored.  This enables 
macro files to be a lot more understandable but it means that any 
existing files that you have will do different things with PipeDream 3 
and PipeDream 3 files that you create will not generally work with 
PipeDream 2.

%H2%Slot Protection

Arbitrary blocks of slots can be protected in PipeDream 3.  The 
protection prevents you from accidentally overwriting or deleting the 
slot contents. Protected slots are displayed using a different 
background colour than normal to make them stand out; this colour may 
be changed using the Colours dialogue box.

%H2%Iteration

Recalculation can be made to iterate which gives the ability to 
recalculate a set of formulae until a specified result has been 
achieved.

%H2%Pictures

PipeDream 3 can display pictures that have been created by Draw, Paint 
or other drawing applications.  These are displayed over blank slots on 
screen and can be printed via the RISC OS printer drivers.

%H2%Z88 filing system

PipeDream 2 has the ability to load and save files directly to the Z88.  
PipeDream 3 provides a Z88 filing system which makes the process rather 
more general and fits in better with the RISC OS philosophy.  The Z88 
Filer icon sits on the icon bar with the other filing system icons and 
provides a device viewer and directory viewers in a similar way to the 
drive icons.  Files can be dragged from directories in the Z88 straight 
into PipeDream and can be saved back again in a similar way.  Files can 
also be saved to the Z88 by dragging them from other applications.

Note that the A3000 does not come with a complete serial port and needs 
to have a simple upgrade before you will be able to plug in the Z88 or 
a serial printer.  This upgrade should be available from your dealer.

%H2%Help

PipeDream supports the RISC OS help system and provides useful context 
sensitive help, mainly of mouse operations in different areas of the 
window.  A useful summary of mouse operations is given at the end of 
Section 3, Chapter 1.

%H2%Fonts

PipeDream 3 can use all of the fonts provided with RISC OS.  New 
facilities are provided to set the global font for a document, to 
insert font changes within documents and to specify font sizes.  Fonts 
are printed using the RISC OS printer drivers and cannot be printed 
using the PipeDream printer drivers.
00000000  25 4f 50 25 44 46 54 0a  25 4f 50 25 54 4d 34 0a  |%OP%DFT.%OP%TM4.|
00000010  25 4f 50 25 48 4d 34 0a  25 4f 50 25 46 4d 34 0a  |%OP%HM4.%OP%FM4.|
00000020  25 4f 50 25 42 4d 34 0a  25 43 4f 3a 41 2c 37 32  |%OP%BM4.%CO:A,72|
00000030  2c 37 32 25 25 48 32 25  43 68 61 6e 67 65 73 20  |,72%%H2%Changes |
00000040  62 65 74 77 65 65 6e 20  50 69 70 65 44 72 65 61  |between PipeDrea|
00000050  6d 20 32 20 61 6e 64 20  50 69 70 65 44 72 65 61  |m 2 and PipeDrea|
00000060  6d 20 33 0a 0a 54 68 65  20 66 6f 6c 6c 6f 77 69  |m 3..The followi|
00000070  6e 67 20 69 73 20 61 20  62 72 69 65 66 20 69 6e  |ng is a brief in|
00000080  74 72 6f 64 75 63 74 69  6f 6e 20 74 6f 20 74 68  |troduction to th|
00000090  65 20 64 69 66 66 65 72  65 6e 63 65 73 20 62 65  |e differences be|
000000a0  74 77 65 65 6e 20 0a 76  65 72 73 69 6f 6e 73 20  |tween .versions |
000000b0  32 20 61 6e 64 20 33 20  6f 66 20 50 69 70 65 44  |2 and 3 of PipeD|
000000c0  72 65 61 6d 2e 20 20 49  74 20 69 73 20 69 6e 74  |ream.  It is int|
000000d0  65 6e 64 65 64 20 61 73  20 61 20 71 75 69 63 6b  |ended as a quick|
000000e0  20 72 65 66 65 72 65 6e  63 65 20 66 6f 72 20 0a  | reference for .|
000000f0  75 73 65 72 73 20 6f 66  20 70 72 65 76 69 6f 75  |users of previou|
00000100  73 20 76 65 72 73 69 6f  6e 73 20 6f 66 20 50 69  |s versions of Pi|
00000110  70 65 44 72 65 61 6d 20  74 6f 20 73 65 65 20 77  |peDream to see w|
00000120  68 61 74 20 69 73 20 61  76 61 69 6c 61 62 6c 65  |hat is available|
00000130  2e 20 20 49 74 20 0a 64  6f 65 73 20 6e 6f 74 20  |.  It .does not |
00000140  61 74 74 65 6d 70 74 20  74 6f 20 67 6f 20 69 6e  |attempt to go in|
00000150  74 6f 20 64 65 74 61 69  6c 20 6f 76 65 72 20 74  |to detail over t|
00000160  68 65 20 6e 65 77 20 66  61 63 69 6c 69 74 69 65  |he new facilitie|
00000170  73 20 2d 20 66 6f 72 20  74 68 69 73 20 0a 79 6f  |s - for this .yo|
00000180  75 20 77 69 6c 6c 20 6e  65 65 64 20 74 6f 20 72  |u will need to r|
00000190  65 66 65 72 20 74 6f 20  74 68 65 20 50 69 70 65  |efer to the Pipe|
000001a0  44 72 65 61 6d 20 55 73  65 72 20 47 75 69 64 65  |Dream User Guide|
000001b0  2e 0a 0a 25 48 32 25 4f  70 65 72 61 74 69 6e 67  |...%H2%Operating|
000001c0  20 53 79 73 74 65 6d 73  0a 0a 50 69 70 65 44 72  | Systems..PipeDr|
000001d0  65 61 6d 20 76 65 72 73  69 6f 6e 20 33 20 77 6f  |eam version 3 wo|
000001e0  72 6b 73 20 6f 6e 6c 79  20 75 6e 64 65 72 20 52  |rks only under R|
000001f0  49 53 43 20 4f 53 20 61  6e 64 20 6e 6f 74 20 75  |ISC OS and not u|
00000200  6e 64 65 72 20 41 72 74  68 75 72 20 31 2e 32 20  |nder Arthur 1.2 |
00000210  0a 6f 72 20 65 61 72 6c  69 65 72 20 76 65 72 73  |.or earlier vers|
00000220  69 6f 6e 73 2e 20 20 50  69 70 65 44 72 65 61 6d  |ions.  PipeDream|
00000230  20 76 65 72 73 69 6f 6e  20 32 20 77 6f 72 6b 73  | version 2 works|
00000240  20 75 6e 64 65 72 20 62  6f 74 68 20 41 72 74 68  | under both Arth|
00000250  75 72 20 31 2e 32 20 0a  61 6e 64 20 52 49 53 43  |ur 1.2 .and RISC|
00000260  20 4f 53 2e 20 0a 0a 25  48 32 25 53 70 65 6c 6c  | OS. ..%H2%Spell|
00000270  43 68 65 63 6b 0a 0a 50  69 70 65 44 72 65 61 6d  |Check..PipeDream|
00000280  20 76 65 72 73 69 6f 6e  20 33 20 69 6e 63 6f 72  | version 3 incor|
00000290  70 6f 72 61 74 65 73 20  50 69 70 65 44 72 65 61  |porates PipeDrea|
000002a0  6d 20 53 70 65 6c 6c 43  68 65 63 6b 20 77 68 65  |m SpellCheck whe|
000002b0  72 65 61 73 20 0a 53 70  65 6c 6c 43 68 65 63 6b  |reas .SpellCheck|
000002c0  20 77 61 73 20 61 20 73  65 70 61 72 61 74 65 20  | was a separate |
000002d0  6f 70 74 69 6f 6e 20 66  6f 72 20 50 69 70 65 44  |option for PipeD|
000002e0  72 65 61 6d 20 76 65 72  73 69 6f 6e 20 32 2e 0a  |ream version 2..|
000002f0  0a 25 48 32 25 49 6e 73  74 61 6c 6c 61 74 69 6f  |.%H2%Installatio|
00000300  6e 0a 0a 49 6e 73 74 61  6c 6c 61 74 69 6f 6e 20  |n..Installation |
00000310  69 73 20 6d 75 63 68 20  65 61 73 69 65 72 2e 20  |is much easier. |
00000320  20 49 74 20 63 6f 6d 70  72 69 73 65 73 20 6d 61  | It comprises ma|
00000330  6b 69 6e 67 20 61 20 62  61 63 6b 75 70 20 6f 66  |king a backup of|
00000340  20 74 68 65 20 0a 50 69  70 65 44 72 65 61 6d 20  | the .PipeDream |
00000350  6d 61 73 74 65 72 20 64  69 73 63 20 74 6f 20 61  |master disc to a|
00000360  20 50 69 70 65 44 72 65  61 6d 20 77 6f 72 6b 69  | PipeDream worki|
00000370  6e 67 20 64 69 73 63 20  66 72 6f 6d 20 77 68 69  |ng disc from whi|
00000380  63 68 20 79 6f 75 20 77  69 6c 6c 20 0a 72 75 6e  |ch you will .run|
00000390  20 50 69 70 65 44 72 65  61 6d 20 33 2e 20 54 68  | PipeDream 3. Th|
000003a0  65 20 66 69 72 73 74 20  74 69 6d 65 20 79 6f 75  |e first time you|
000003b0  20 72 75 6e 20 50 69 70  65 44 72 65 61 6d 20 33  | run PipeDream 3|
000003c0  20 79 6f 75 20 77 69 6c  6c 20 62 65 20 61 73 6b  | you will be ask|
000003d0  65 64 20 0a 74 6f 20 65  6e 74 65 72 20 79 6f 75  |ed .to enter you|
000003e0  72 20 6e 61 6d 65 20 77  68 69 63 68 20 77 69 6c  |r name which wil|
000003f0  6c 20 62 65 20 69 6e 63  6c 75 64 65 64 20 69 6e  |l be included in|
00000400  20 74 68 65 20 50 69 70  65 44 72 65 61 6d 20 70  | the PipeDream p|
00000410  72 6f 67 72 61 6d 20 66  72 6f 6d 20 0a 74 68 65  |rogram from .the|
00000420  6e 20 6f 6e 2e 20 20 59  6f 75 72 20 50 69 70 65  |n on.  Your Pipe|
00000430  44 72 65 61 6d 20 33 20  64 69 73 63 20 61 6c 73  |Dream 3 disc als|
00000440  6f 20 68 61 73 20 61 20  75 6e 69 71 75 65 20 72  |o has a unique r|
00000450  65 67 69 73 74 72 61 74  69 6f 6e 20 6e 75 6d 62  |egistration numb|
00000460  65 72 20 0a 69 64 65 6e  74 69 66 79 69 6e 67 20  |er .identifying |
00000470  61 6c 6c 20 77 6f 72 6b  69 6e 67 20 64 69 73 63  |all working disc|
00000480  73 20 61 73 20 68 61 76  69 6e 67 20 63 6f 6d 65  |s as having come|
00000490  20 66 72 6f 6d 20 79 6f  75 72 20 6d 61 73 74 65  | from your maste|
000004a0  72 2e 0a 0a 48 61 76 69  6e 67 20 69 6e 73 74 61  |r...Having insta|
000004b0  6c 6c 65 64 20 50 69 70  65 44 72 65 61 6d 20 66  |lled PipeDream f|
000004c0  69 6c 6c 20 69 6e 20 74  68 65 20 72 65 67 69 73  |ill in the regis|
000004d0  74 72 61 74 69 6f 6e 20  63 61 72 64 20 61 6e 64  |tration card and|
000004e0  20 72 65 74 75 72 6e 20  69 74 20 0a 74 6f 20 43  | return it .to C|
000004f0  6f 6c 74 6f 6e 20 53 6f  66 74 77 61 72 65 2e 20  |olton Software. |
00000500  20 59 6f 75 20 77 69 6c  6c 20 74 68 65 6e 20 62  | You will then b|
00000510  65 20 61 20 72 65 67 69  73 74 65 72 65 64 20 75  |e a registered u|
00000520  73 65 72 2e 20 4f 6e 6c  79 20 0a 72 65 67 69 73  |ser. Only .regis|
00000530  74 65 72 65 64 20 75 73  65 72 73 20 61 72 65 20  |tered users are |
00000540  65 6e 74 69 74 6c 65 64  20 74 6f 20 74 65 6c 65  |entitled to tele|
00000550  70 68 6f 6e 65 20 73 75  70 70 6f 72 74 20 61 6e  |phone support an|
00000560  64 20 75 70 67 72 61 64  65 73 20 74 6f 20 6e 65  |d upgrades to ne|
00000570  77 20 0a 72 65 6c 65 61  73 65 73 2e 0a 0a 4e 6f  |w .releases...No|
00000580  74 65 20 74 68 61 74 20  74 68 65 20 75 6e 69 71  |te that the uniq|
00000590  75 65 20 72 65 67 69 73  74 72 61 74 69 6f 6e 20  |ue registration |
000005a0  6e 75 6d 62 65 72 20 6f  6e 20 74 68 65 20 64 69  |number on the di|
000005b0  73 63 20 65 6e 61 62 6c  65 73 20 75 73 20 74 6f  |sc enables us to|
000005c0  20 0a 74 72 61 63 65 20  63 6f 70 69 65 73 20 6f  | .trace copies o|
000005d0  66 20 79 6f 75 72 20 6d  61 73 74 65 72 20 64 69  |f your master di|
000005e0  73 63 2e 20 20 59 6f 75  20 61 72 65 20 61 6c 6c  |sc.  You are all|
000005f0  6f 77 65 64 20 61 6e 64  20 77 65 6c 63 6f 6d 65  |owed and welcome|
00000600  20 74 6f 20 6d 61 6b 65  20 0a 62 61 63 6b 75 70  | to make .backup|
00000610  20 63 6f 70 69 65 73 20  6f 66 20 74 68 65 20 64  | copies of the d|
00000620  69 73 63 20 66 6f 72 20  79 6f 75 72 20 6f 77 6e  |isc for your own|
00000630  20 75 73 65 20 62 75 74  20 79 6f 75 20 61 72 65  | use but you are|
00000640  20 6e 6f 74 20 61 6c 6c  6f 77 65 64 20 74 6f 20  | not allowed to |
00000650  0a 6d 61 6b 65 20 63 6f  70 69 65 73 20 6f 66 20  |.make copies of |
00000660  74 68 65 20 64 69 73 63  20 66 6f 72 20 61 6e 79  |the disc for any|
00000670  6f 6e 65 20 65 6c 73 65  20 74 6f 20 75 73 65 2e  |one else to use.|
00000680  20 20 49 66 20 79 6f 75  20 61 72 65 20 75 6e 73  |  If you are uns|
00000690  75 72 65 20 6f 66 20 0a  79 6f 75 72 20 72 69 67  |ure of .your rig|
000006a0  68 74 73 20 72 65 61 64  20 74 68 65 20 64 69 73  |hts read the dis|
000006b0  63 20 65 6e 76 65 6c 6f  70 65 20 63 61 72 65 66  |c envelope caref|
000006c0  75 6c 6c 79 20 6f 72 20  70 68 6f 6e 65 20 43 6f  |ully or phone Co|
000006d0  6c 74 6f 6e 20 53 6f 66  74 77 61 72 65 20 0a 66  |lton Software .f|
000006e0  6f 72 20 67 75 69 64 61  6e 63 65 2e 0a 0a 53 6f  |or guidance...So|
000006f0  66 74 77 61 72 65 20 70  69 72 61 63 79 20 69 73  |ftware piracy is|
00000700  20 74 68 65 66 74 2e 20  20 54 68 69 65 76 65 73  | theft.  Thieves|
00000710  20 68 75 72 74 20 67 65  6e 75 69 6e 65 20 75 73  | hurt genuine us|
00000720  65 72 73 20 6a 75 73 74  20 61 73 20 6d 75 63 68  |ers just as much|
00000730  20 61 73 20 0a 74 68 65  79 20 68 75 72 74 20 73  | as .they hurt s|
00000740  6f 66 74 77 61 72 65 20  68 6f 75 73 65 73 20 74  |oftware houses t|
00000750  68 72 6f 75 67 68 20 67  69 76 69 6e 67 20 75 70  |hrough giving up|
00000760  77 61 72 64 73 20 70 72  65 73 73 75 72 65 20 6f  |wards pressure o|
00000770  6e 20 70 72 69 63 65 73  2e 20 20 0a 57 65 20 64  |n prices.  .We d|
00000780  6f 6e 27 74 20 62 65 6c  69 65 76 65 20 74 68 61  |on't believe tha|
00000790  74 20 74 68 65 20 62 65  73 74 20 77 61 79 20 74  |t the best way t|
000007a0  6f 20 73 74 61 6d 70 20  6f 75 74 20 73 6f 66 74  |o stamp out soft|
000007b0  77 61 72 65 20 70 69 72  61 63 79 20 69 73 20 74  |ware piracy is t|
000007c0  6f 20 0a 70 72 6f 74 65  63 74 20 64 69 73 63 73  |o .protect discs|
000007d0  20 62 65 63 61 75 73 65  20 74 68 61 74 20 6d 61  | because that ma|
000007e0  6b 65 73 20 6c 69 66 65  20 64 69 66 66 69 63 75  |kes life difficu|
000007f0  6c 74 20 66 6f 72 20 67  65 6e 75 69 6e 65 20 75  |lt for genuine u|
00000800  73 65 72 73 20 2d 20 74  68 65 20 0a 6f 76 65 72  |sers - the .over|
00000810  77 68 65 6c 6d 69 6e 67  20 6d 61 6a 6f 72 69 74  |whelming majorit|
00000820  79 2e 20 20 48 61 76 69  6e 67 20 75 6e 69 71 75  |y.  Having uniqu|
00000830  65 20 72 65 67 69 73 74  72 61 74 69 6f 6e 20 6e  |e registration n|
00000840  75 6d 62 65 72 73 20 65  6e 61 62 6c 65 73 20 75  |umbers enables u|
00000850  73 20 0a 74 6f 20 74 72  61 63 65 20 69 6c 6c 65  |s .to trace ille|
00000860  67 61 6c 20 63 6f 70 69  65 73 20 76 65 72 79 20  |gal copies very |
00000870  65 61 73 69 6c 79 20 61  6e 64 20 74 6f 20 70 72  |easily and to pr|
00000880  6f 73 65 63 75 74 65 20  6f 66 66 65 6e 64 65 72  |osecute offender|
00000890  73 20 0a 65 66 66 65 63  74 69 76 65 6c 79 2e 0a  |s .effectively..|
000008a0  0a 25 48 32 25 55 73 65  72 20 49 6e 74 65 72 66  |.%H2%User Interf|
000008b0  61 63 65 0a 0a 50 69 70  65 44 72 65 61 6d 20 68  |ace..PipeDream h|
000008c0  61 73 20 62 65 65 6e 20  63 6f 6d 70 6c 65 74 65  |as been complete|
000008d0  6c 79 20 72 65 77 72 69  74 74 65 6e 20 74 6f 20  |ly rewritten to |
000008e0  74 61 6b 65 20 61 64 76  61 6e 74 61 67 65 20 6f  |take advantage o|
000008f0  66 20 52 49 53 43 20 4f  53 20 69 6e 20 0a 61 73  |f RISC OS in .as|
00000900  20 6d 61 6e 79 20 77 61  79 73 20 61 73 20 70 6f  | many ways as po|
00000910  73 73 69 62 6c 65 2e 20  20 41 20 50 69 70 65 44  |ssible.  A PipeD|
00000920  72 65 61 6d 20 64 6f 63  75 6d 65 6e 74 20 6e 6f  |ream document no|
00000930  77 20 61 70 70 65 61 72  73 20 69 6e 20 61 20 77  |w appears in a w|
00000940  69 6e 64 6f 77 20 0a 6f  6e 20 74 68 65 20 73 63  |indow .on the sc|
00000950  72 65 65 6e 2e 20 20 41  6c 6c 20 6f 66 20 74 68  |reen.  All of th|
00000960  65 20 72 65 73 69 7a 69  6e 67 2c 20 73 63 72 6f  |e resizing, scro|
00000970  6c 6c 69 6e 67 20 61 6e  64 20 70 6f 69 6e 74 69  |lling and pointi|
00000980  6e 67 20 6f 70 65 72 61  74 69 6f 6e 73 20 0a 61  |ng operations .a|
00000990  72 65 20 61 76 61 69 6c  61 62 6c 65 2c 20 61 73  |re available, as|
000009a0  20 61 72 65 20 6d 61 6e  79 20 64 72 61 67 20 61  | are many drag a|
000009b0  6e 64 20 63 6c 69 63 6b  69 6e 67 20 6f 70 65 72  |nd clicking oper|
000009c0  61 74 69 6f 6e 73 2e 20  20 54 68 65 20 72 65 73  |ations.  The res|
000009d0  75 6c 74 20 69 73 20 0a  74 68 61 74 20 50 69 70  |ult is .that Pip|
000009e0  65 44 72 65 61 6d 20 6f  70 65 72 61 74 65 73 20  |eDream operates |
000009f0  76 65 72 79 20 6d 75 63  68 20 6c 69 6b 65 20 45  |very much like E|
00000a00  64 69 74 2c 20 72 61 74  68 65 72 20 74 68 61 6e  |dit, rather than|
00000a10  20 70 72 65 76 69 6f 75  73 20 0a 76 65 72 73 69  | previous .versi|
00000a20  6f 6e 73 20 6f 66 20 50  69 70 65 44 72 65 61 6d  |ons of PipeDream|
00000a30  20 77 68 69 63 68 20 74  6f 6f 6b 20 6f 76 65 72  | which took over|
00000a40  20 74 68 65 20 73 63 72  65 65 6e 20 61 6e 64 20  | the screen and |
00000a50  74 6f 6f 6b 20 28 61 6c  6d 6f 73 74 29 20 61 6c  |took (almost) al|
00000a60  6c 20 0a 69 6e 70 75 74  20 66 72 6f 6d 20 74 68  |l .input from th|
00000a70  65 20 6b 65 79 62 6f 61  72 64 2e 0a 0a 25 48 32  |e keyboard...%H2|
00000a80  25 4d 61 6e 79 20 64 6f  63 75 6d 65 6e 74 73 0a  |%Many documents.|
00000a90  0a 50 69 70 65 44 72 65  61 6d 20 63 61 6e 20 63  |.PipeDream can c|
00000aa0  6f 70 65 20 77 69 74 68  20 61 73 20 6d 61 6e 79  |ope with as many|
00000ab0  20 64 6f 63 75 6d 65 6e  74 73 20 61 6c 6c 20 6c  | documents all l|
00000ac0  6f 61 64 65 64 20 61 74  20 6f 6e 63 65 20 61 73  |oaded at once as|
00000ad0  20 63 61 6e 20 62 65 20  0a 66 69 74 74 65 64 20  | can be .fitted |
00000ae0  69 6e 74 6f 20 6d 65 6d  6f 72 79 2e 20 20 45 61  |into memory.  Ea|
00000af0  63 68 20 64 6f 63 75 6d  65 6e 74 20 61 70 70 65  |ch document appe|
00000b00  61 72 73 20 69 6e 20 69  74 73 20 6f 77 6e 20 77  |ars in its own w|
00000b10  69 6e 64 6f 77 2e 20 20  4e 6f 74 65 20 0a 74 68  |indow.  Note .th|
00000b20  61 74 20 69 74 20 69 73  20 6f 6e 65 20 63 6f 70  |at it is one cop|
00000b30  79 20 6f 66 20 50 69 70  65 44 72 65 61 6d 20 69  |y of PipeDream i|
00000b40  6e 20 74 68 65 20 63 6f  6d 70 75 74 65 72 20 74  |n the computer t|
00000b50  68 61 74 20 69 73 20 64  6f 69 6e 67 20 74 68 69  |hat is doing thi|
00000b60  73 2c 20 0a 6e 6f 74 20  6f 6e 65 20 50 69 70 65  |s, .not one Pipe|
00000b70  44 72 65 61 6d 20 66 6f  72 20 65 61 63 68 20 77  |Dream for each w|
00000b80  69 6e 64 6f 77 2c 20 73  6f 20 6d 61 6e 79 20 64  |indow, so many d|
00000b90  6f 63 75 6d 65 6e 74 73  20 63 61 6e 20 62 65 20  |ocuments can be |
00000ba0  6c 6f 61 64 65 64 20 65  76 65 6e 20 0a 6f 6e 20  |loaded even .on |
00000bb0  61 20 31 4d 62 79 74 65  20 63 6f 6d 70 75 74 65  |a 1Mbyte compute|
00000bc0  72 2e 0a 0a 54 6f 20 73  65 65 20 74 68 69 73 20  |r...To see this |
00000bd0  69 6e 20 61 63 74 69 6f  6e 20 6d 61 6b 65 20 61  |in action make a|
00000be0  20 73 65 6c 65 63 74 69  6f 6e 20 6f 66 20 66 69  | selection of fi|
00000bf0  6c 65 73 20 69 6e 20 61  20 64 69 72 65 63 74 6f  |les in a directo|
00000c00  72 79 20 76 69 65 77 65  72 20 0a 61 6e 64 20 64  |ry viewer .and d|
00000c10  72 61 67 20 74 68 65 20  73 65 6c 65 63 74 69 6f  |rag the selectio|
00000c20  6e 20 74 6f 20 74 68 65  20 50 69 70 65 44 72 65  |n to the PipeDre|
00000c30  61 6d 20 69 63 6f 6e 20  6f 6e 20 74 68 65 20 69  |am icon on the i|
00000c40  63 6f 6e 20 62 61 72 2e  20 20 45 61 63 68 20 0a  |con bar.  Each .|
00000c50  66 69 6c 65 20 77 69 6c  6c 20 62 65 20 6c 6f 61  |file will be loa|
00000c60  64 65 64 20 69 6e 74 6f  20 61 20 6e 65 77 20 50  |ded into a new P|
00000c70  69 70 65 44 72 65 61 6d  20 77 69 6e 64 6f 77 2e  |ipeDream window.|
00000c80  0a 0a 42 6c 6f 63 6b 73  20 6f 66 20 64 61 74 61  |..Blocks of data|
00000c90  20 63 61 6e 20 62 65 20  63 6f 70 69 65 64 20 61  | can be copied a|
00000ca0  6e 64 20 6d 6f 76 65 64  20 62 65 74 77 65 65 6e  |nd moved between|
00000cb0  20 77 69 6e 64 6f 77 73  20 62 79 20 6d 61 72 6b  | windows by mark|
00000cc0  69 6e 67 20 61 20 0a 62  6c 6f 63 6b 20 69 6e 20  |ing a .block in |
00000cd0  6f 6e 65 20 77 69 6e 64  6f 77 2c 20 70 6f 73 69  |one window, posi|
00000ce0  74 69 6f 6e 69 6e 67 20  74 68 65 20 63 61 72 65  |tioning the care|
00000cf0  74 20 69 6e 20 61 6e 6f  74 68 65 72 20 61 6e 64  |t in another and|
00000d00  20 67 69 76 69 6e 67 20  74 68 65 20 0a 72 65 6c  | giving the .rel|
00000d10  65 76 61 6e 74 20 63 6f  6d 6d 61 6e 64 2e 0a 0a  |evant command...|
00000d20  25 48 32 25 52 65 63 6f  76 65 72 69 6e 67 20 64  |%H2%Recovering d|
00000d30  65 6c 65 74 69 6f 6e 73  0a 0a 50 69 70 65 44 72  |eletions..PipeDr|
00000d40  65 61 6d 20 32 20 72 65  6d 65 6d 62 65 72 65 64  |eam 2 remembered|
00000d50  20 77 6f 72 64 73 20 61  6e 64 20 70 68 72 61 73  | words and phras|
00000d60  65 73 20 74 68 61 74 20  68 61 64 20 62 65 65 6e  |es that had been|
00000d70  20 64 65 6c 65 74 65 64  20 61 6e 64 20 74 68 65  | deleted and the|
00000d80  79 20 0a 63 6f 75 6c 64  20 62 65 20 72 65 63 6f  |y .could be reco|
00000d90  76 65 72 65 64 20 75 73  69 6e 67 20 74 68 65 20  |vered using the |
00000da0  50 61 73 74 65 20 63 6f  6d 6d 61 6e 64 2e 20 20  |Paste command.  |
00000db0  50 69 70 65 44 72 65 61  6d 20 33 20 63 61 6e 20  |PipeDream 3 can |
00000dc0  61 6c 73 6f 20 0a 72 65  63 6f 76 65 72 20 64 65  |also .recover de|
00000dd0  6c 65 74 65 64 20 72 6f  77 73 2c 20 63 6f 6c 75  |leted rows, colu|
00000de0  6d 6e 73 20 61 6e 64 20  62 6c 6f 63 6b 73 2e 20  |mns and blocks. |
00000df0  20 49 74 20 6d 61 69 6e  74 61 69 6e 73 20 61 20  | It maintains a |
00000e00  6c 69 73 74 20 6f 66 20  75 70 20 74 6f 20 0a 32  |list of up to .2|
00000e10  35 35 20 64 65 6c 65 74  69 6f 6e 73 20 28 74 68  |55 deletions (th|
00000e20  65 20 64 65 66 61 75 6c  74 20 69 73 20 35 30 20  |e default is 50 |
00000e30  61 6e 64 20 69 73 20 63  6f 6e 66 69 67 75 72 61  |and is configura|
00000e40  62 6c 65 20 62 65 74 77  65 65 6e 20 30 2d 32 35  |ble between 0-25|
00000e50  35 29 20 0a 77 68 69 63  68 20 63 61 6e 20 62 65  |5) .which can be|
00000e60  20 70 61 73 74 65 64 20  62 61 63 6b 20 69 6e 74  | pasted back int|
00000e70  6f 20 74 68 65 20 74 65  78 74 20 61 6e 64 20 61  |o the text and a|
00000e80  6e 79 20 70 6f 69 6e 74  20 62 79 20 70 6f 73 69  |ny point by posi|
00000e90  74 69 6f 6e 69 6e 67 20  74 68 65 20 0a 63 61 72  |tioning the .car|
00000ea0  65 74 20 61 74 20 74 68  65 20 69 6e 73 65 72 74  |et at the insert|
00000eb0  69 6f 6e 20 70 6f 69 6e  74 20 61 6e 64 20 67 69  |ion point and gi|
00000ec0  76 69 6e 67 20 74 68 65  20 50 61 73 74 65 20 63  |ving the Paste c|
00000ed0  6f 6d 6d 61 6e 64 2e 0a  0a 41 20 62 6c 6f 63 6b  |ommand...A block|
00000ee0  20 63 61 6e 20 62 65 20  6d 6f 76 65 64 20 62 65  | can be moved be|
00000ef0  74 77 65 65 6e 20 77 69  6e 64 6f 77 73 20 62 79  |tween windows by|
00000f00  20 64 65 6c 65 74 69 6e  67 20 69 74 20 66 72 6f  | deleting it fro|
00000f10  6d 20 6f 6e 65 20 77 69  6e 64 6f 77 20 61 6e 64  |m one window and|
00000f20  20 0a 70 61 73 74 69 6e  67 20 69 74 20 69 6e 74  | .pasting it int|
00000f30  6f 20 61 6e 6f 74 68 65  72 2e 0a 0a 41 20 6e 65  |o another...A ne|
00000f40  77 20 63 6f 6d 6d 61 6e  64 20 43 6f 70 79 20 42  |w command Copy B|
00000f50  6c 6f 63 6b 20 74 6f 20  42 75 66 66 65 72 20 69  |lock to Buffer i|
00000f60  73 20 61 6c 73 6f 20 70  72 6f 76 69 64 65 64 20  |s also provided |
00000f70  77 68 69 63 68 20 63 6f  70 69 65 73 20 74 68 65  |which copies the|
00000f80  20 0a 74 68 65 20 6d 61  72 6b 65 64 20 62 6c 6f  | .the marked blo|
00000f90  63 6b 20 74 6f 20 74 68  65 20 70 61 73 74 65 20  |ck to the paste |
00000fa0  6c 69 73 74 20 77 69 74  68 6f 75 74 20 64 65 6c  |list without del|
00000fb0  65 74 69 6e 67 20 69 74  20 66 72 6f 6d 20 74 68  |eting it from th|
00000fc0  65 20 74 65 78 74 2e 20  0a 49 74 20 63 61 6e 20  |e text. .It can |
00000fd0  62 65 20 70 61 73 74 65  64 20 69 6e 20 61 74 20  |be pasted in at |
00000fe0  61 6e 79 20 70 6f 69 6e  74 2c 20 73 6f 20 74 68  |any point, so th|
00000ff0  61 74 20 61 20 63 6f 70  79 20 6f 66 20 69 74 20  |at a copy of it |
00001000  69 73 20 6d 61 64 65 2e  0a 0a 25 48 32 25 4e 61  |is made...%H2%Na|
00001010  74 75 72 61 6c 20 52 65  63 61 6c 63 75 6c 61 74  |tural Recalculat|
00001020  69 6f 6e 0a 0a 49 6e 20  61 64 64 69 74 69 6f 6e  |ion..In addition|
00001030  20 74 6f 20 72 65 63 61  6c 63 75 6c 61 74 69 6e  | to recalculatin|
00001040  67 20 62 79 20 72 6f 77  20 6f 72 20 63 6f 6c 75  |g by row or colu|
00001050  6d 6e 20 50 69 70 65 44  72 65 61 6d 20 33 20 68  |mn PipeDream 3 h|
00001060  61 73 20 6e 61 74 75 72  61 6c 20 0a 72 65 63 61  |as natural .reca|
00001070  6c 63 75 6c 61 74 69 6f  6e 2e 20 20 54 68 69 73  |lculation.  This|
00001080  20 72 65 73 6f 6c 76 65  73 20 70 72 6f 62 6c 65  | resolves proble|
00001090  6d 73 20 6f 66 20 66 6f  72 77 61 72 64 20 72 65  |ms of forward re|
000010a0  66 65 72 65 6e 63 65 73  20 77 68 65 72 65 20 74  |ferences where t|
000010b0  68 65 20 0a 73 70 72 65  61 64 73 68 65 65 74 20  |he .spreadsheet |
000010c0  6d 69 67 68 74 20 68 61  76 65 20 74 6f 20 62 65  |might have to be|
000010d0  20 72 65 63 61 6c 63 75  6c 61 74 65 64 20 6d 6f  | recalculated mo|
000010e0  72 65 20 74 68 61 6e 20  6f 6e 63 65 20 62 65 66  |re than once bef|
000010f0  6f 72 65 20 61 6c 6c 20  6f 66 20 0a 74 68 65 20  |ore all of .the |
00001100  76 61 6c 75 65 73 20 77  65 72 65 20 75 70 2d 74  |values were up-t|
00001110  6f 2d 64 61 74 65 2e 20  20 57 69 74 68 20 61 75  |o-date.  With au|
00001120  74 6f 6d 61 74 69 63 20  72 65 63 61 6c 63 75 6c  |tomatic recalcul|
00001130  61 74 69 6f 6e 20 6f 6e  2c 20 69 74 20 69 73 20  |ation on, it is |
00001140  0a 75 73 75 61 6c 6c 79  20 73 69 67 6e 69 66 69  |.usually signifi|
00001150  63 61 6e 74 6c 79 20 66  61 73 74 65 72 2c 20 61  |cantly faster, a|
00001160  73 20 6f 6e 6c 79 20 74  68 6f 73 65 20 73 6c 6f  |s only those slo|
00001170  74 73 20 74 68 61 74 20  63 68 61 6e 67 65 20 76  |ts that change v|
00001180  61 6c 75 65 2c 20 0a 72  61 74 68 65 72 20 74 68  |alue, .rather th|
00001190  61 6e 20 61 6c 6c 20 73  6c 6f 74 73 20 69 6e 20  |an all slots in |
000011a0  74 68 65 20 73 70 72 65  61 64 73 68 65 65 74 2c  |the spreadsheet,|
000011b0  20 61 72 65 20 72 65 63  61 6c 63 75 6c 61 74 65  | are recalculate|
000011c0  64 2e 0a 0a 4e 61 74 75  72 61 6c 20 72 65 63 61  |d...Natural reca|
000011d0  6c 63 75 6c 61 74 69 6f  6e 20 72 65 71 75 69 72  |lculation requir|
000011e0  65 73 20 65 78 74 72 61  20 6d 65 6d 6f 72 79 20  |es extra memory |
000011f0  74 6f 20 72 65 63 6f 72  64 20 74 68 65 20 69 6e  |to record the in|
00001200  66 6f 72 6d 61 74 69 6f  6e 20 0a 61 73 20 74 6f  |formation .as to|
00001210  20 77 68 69 63 68 20 73  6c 6f 74 73 20 61 66 66  | which slots aff|
00001220  65 63 74 20 77 68 69 63  68 20 6f 74 68 65 72 73  |ect which others|
00001230  2e 20 20 49 66 20 50 69  70 65 44 72 65 61 6d 20  |.  If PipeDream |
00001240  72 75 6e 73 20 6f 75 74  20 6f 66 20 6d 65 6d 6f  |runs out of memo|
00001250  72 79 20 0a 69 74 20 77  69 6c 6c 20 61 75 74 6f  |ry .it will auto|
00001260  6d 61 74 69 63 61 6c 6c  79 20 73 77 69 74 63 68  |matically switch|
00001270  20 74 6f 20 72 65 63 61  6c 63 75 6c 61 74 69 6f  | to recalculatio|
00001280  6e 20 62 79 20 63 6f 6c  75 6d 6e 2c 20 67 69 76  |n by column, giv|
00001290  69 6e 67 20 61 20 0a 6d  65 73 73 61 67 65 20 73  |ing a .message s|
000012a0  61 79 69 6e 67 20 69 74  20 69 73 20 64 6f 69 6e  |aying it is doin|
000012b0  67 20 73 6f 2e 20 20 0a  0a 25 48 32 25 42 61 63  |g so.  ..%H2%Bac|
000012c0  6b 67 72 6f 75 6e 64 2c  20 69 6e 74 65 72 72 75  |kground, interru|
000012d0  70 74 69 62 6c 65 20 72  65 63 61 6c 63 75 6c 61  |ptible recalcula|
000012e0  74 69 6f 6e 0a 0a 50 69  70 65 44 72 65 61 6d 27  |tion..PipeDream'|
000012f0  73 20 72 65 63 61 6c 63  75 6c 61 74 69 6f 6e 20  |s recalculation |
00001300  69 73 20 70 65 72 66 6f  72 6d 65 64 20 69 6e 20  |is performed in |
00001310  73 68 6f 72 74 20 74 69  6d 65 2d 73 6c 69 63 65  |short time-slice|
00001320  73 20 69 6e 20 74 68 65  20 0a 62 61 63 6b 67 72  |s in the .backgr|
00001330  6f 75 6e 64 20 73 6f 20  79 6f 75 20 63 61 6e 20  |ound so you can |
00001340  63 6f 6e 74 69 6e 75 65  20 77 69 74 68 20 6f 74  |continue with ot|
00001350  68 65 72 20 74 61 73 6b  73 20 77 68 69 6c 73 74  |her tasks whilst|
00001360  20 72 65 63 61 6c 63 75  6c 61 74 69 6f 6e 20 69  | recalculation i|
00001370  73 20 0a 70 72 6f 63 65  65 64 69 6e 67 2e 0a 0a  |s .proceeding...|
00001380  25 48 32 25 4d 65 6d 6f  72 79 20 55 73 61 67 65  |%H2%Memory Usage|
00001390  0a 0a 50 69 70 65 44 72  65 61 6d 20 33 20 65 6d  |..PipeDream 3 em|
000013a0  70 6c 6f 79 73 20 67 72  65 61 74 65 72 20 64 61  |ploys greater da|
000013b0  74 61 20 63 6f 6d 70 61  63 74 69 6f 6e 20 61 6e  |ta compaction an|
000013c0  64 20 6d 6f 72 65 20 73  70 61 72 73 65 20 6d 61  |d more sparse ma|
000013d0  74 72 69 78 20 0a 74 65  63 68 6e 69 71 75 65 73  |trix .techniques|
000013e0  20 65 6e 61 62 6c 69 6e  67 20 6c 61 72 67 65 72  | enabling larger|
000013f0  20 66 69 6c 65 73 20 74  6f 20 62 65 20 6c 6f 61  | files to be loa|
00001400  64 65 64 20 69 6e 74 6f  20 74 68 65 20 73 61 6d  |ded into the sam|
00001410  65 20 61 6d 6f 75 6e 74  20 6f 66 20 0a 6d 65 6d  |e amount of .mem|
00001420  6f 72 79 2e 20 20 54 68  65 20 61 6d 6f 75 6e 74  |ory.  The amount|
00001430  20 6f 66 20 69 6d 70 72  6f 76 65 6d 65 6e 74 20  | of improvement |
00001440  77 69 6c 6c 20 64 65 70  65 6e 64 20 75 70 6f 6e  |will depend upon|
00001450  20 74 68 65 20 64 61 74  61 20 62 75 74 2c 20 69  | the data but, i|
00001460  6e 20 0a 67 65 6e 65 72  61 6c 2c 20 74 68 65 20  |n .general, the |
00001470  73 70 61 72 73 65 72 20  74 68 65 20 66 69 6c 65  |sparser the file|
00001480  20 28 69 65 20 74 68 65  20 6d 6f 72 65 20 62 6c  | (ie the more bl|
00001490  61 6e 6b 20 73 6c 6f 74  73 20 74 68 65 72 65 20  |ank slots there |
000014a0  61 72 65 29 20 74 68 65  20 0a 67 72 65 61 74 65  |are) the .greate|
000014b0  72 20 74 68 65 20 69 6d  70 72 6f 76 65 6d 65 6e  |r the improvemen|
000014c0  74 2e 20 0a 0a 41 64 64  69 74 69 6f 6e 61 6c 6c  |t. ..Additionall|
000014d0  79 20 50 69 70 65 44 72  65 61 6d 20 63 6f 6d 6d  |y PipeDream comm|
000014e0  75 6e 69 63 61 74 65 73  20 69 6e 74 65 6c 6c 69  |unicates intelli|
000014f0  67 65 6e 74 6c 79 20 77  69 74 68 20 52 49 53 43  |gently with RISC|
00001500  20 4f 53 20 74 6f 20 75  73 65 20 0a 6f 6e 6c 79  | OS to use .only|
00001510  20 74 68 65 20 61 6d 6f  75 6e 74 20 6f 66 20 6d  | the amount of m|
00001520  65 6d 6f 72 79 20 69 74  20 6e 65 65 64 73 20 61  |emory it needs a|
00001530  74 20 61 6e 79 20 74 69  6d 65 2c 20 67 69 76 69  |t any time, givi|
00001540  6e 67 20 6d 65 6d 6f 72  79 20 62 61 63 6b 20 74  |ng memory back t|
00001550  6f 20 0a 74 68 65 20 73  79 73 74 65 6d 20 77 68  |o .the system wh|
00001560  65 6e 20 69 74 20 69 73  20 6e 6f 20 6c 6f 6e 67  |en it is no long|
00001570  65 72 20 6e 65 65 64 65  64 2e 20 20 49 74 20 69  |er needed.  It i|
00001580  73 20 76 65 72 79 20 69  6d 70 6f 72 74 61 6e 74  |s very important|
00001590  20 66 6f 72 20 0a 61 70  70 6c 69 63 61 74 69 6f  | for .applicatio|
000015a0  6e 73 20 74 6f 20 63 6f  6f 70 65 72 61 74 65 20  |ns to cooperate |
000015b0  69 6e 20 74 68 69 73 20  77 61 79 20 69 6e 20 61  |in this way in a|
000015c0  20 6d 75 6c 74 69 2d 74  61 73 6b 69 6e 67 20 65  | multi-tasking e|
000015d0  6e 76 69 72 6f 6e 6d 65  6e 74 20 73 6f 20 0a 74  |nvironment so .t|
000015e0  68 61 74 20 74 68 65 20  76 65 72 79 20 6d 6f 73  |hat the very mos|
000015f0  74 20 6d 61 79 20 62 65  20 6d 61 64 65 20 6f 66  |t may be made of|
00001600  20 74 68 65 20 61 76 61  69 6c 61 62 6c 65 20 6d  | the available m|
00001610  65 6d 6f 72 79 20 28 62  65 63 61 75 73 65 20 74  |emory (because t|
00001620  68 65 72 65 20 0a 69 73  20 6e 65 76 65 72 20 65  |here .is never e|
00001630  6e 6f 75 67 68 20 6f 66  20 69 74 29 2e 20 20 41  |nough of it).  A|
00001640  70 70 6c 69 63 61 74 69  6f 6e 73 20 63 6f 6f 70  |pplications coop|
00001650  65 72 61 74 69 6e 67 20  69 6e 20 74 68 69 73 20  |erating in this |
00001660  6d 61 6e 6e 65 72 20 61  72 65 20 0a 6d 6f 72 65  |manner are .more|
00001670  20 75 73 61 62 6c 65 20  61 6e 64 20 6c 65 73 73  | usable and less|
00001680  20 66 72 75 73 74 72 61  74 69 6e 67 2e 0a 0a 25  | frustrating...%|
00001690  48 32 25 49 6e 73 65 72  74 20 6f 6e 20 72 65 74  |H2%Insert on ret|
000016a0  75 72 6e 0a 0a 55 73 65  72 73 20 6f 66 20 6f 74  |urn..Users of ot|
000016b0  68 65 72 20 77 6f 72 64  20 70 72 6f 63 65 73 73  |her word process|
000016c0  6f 72 73 20 6f 66 74 65  6e 20 70 72 65 66 65 72  |ors often prefer|
000016d0  20 74 68 65 20 63 75 72  72 65 6e 74 20 6c 69 6e  | the current lin|
000016e0  65 20 74 6f 20 62 65 20  0a 73 70 6c 69 74 20 77  |e to be .split w|
000016f0  68 65 6e 20 74 68 65 79  20 70 72 65 73 73 20 74  |hen they press t|
00001700  68 65 20 52 65 74 75 72  6e 20 6b 65 79 20 61 6e  |he Return key an|
00001710  64 20 66 6f 72 20 74 68  65 20 74 77 6f 20 6c 69  |d for the two li|
00001720  6e 65 73 20 74 6f 20 62  65 20 6a 6f 69 6e 65 64  |nes to be joined|
00001730  20 0a 61 67 61 69 6e 20  77 68 65 6e 20 61 20 64  | .again when a d|
00001740  65 6c 65 74 65 20 62 61  63 6b 77 61 72 64 73 20  |elete backwards |
00001750  69 73 20 6d 61 64 65 20  61 74 20 74 68 65 20 62  |is made at the b|
00001760  65 67 69 6e 6e 69 6e 67  20 6f 66 20 74 68 65 20  |eginning of the |
00001770  6c 69 6e 65 20 6f 72 20  61 20 0a 64 65 6c 65 74  |line or a .delet|
00001780  65 20 66 6f 72 77 61 72  64 73 20 61 74 20 74 68  |e forwards at th|
00001790  65 20 65 6e 64 20 6f 66  20 74 68 65 20 6c 69 6e  |e end of the lin|
000017a0  65 2e 20 20 4f 74 68 65  72 73 20 64 6f 6e 27 74  |e.  Others don't|
000017b0  2e 0a 0a 41 20 6e 65 77  20 6f 70 74 69 6f 6e 20  |...A new option |
000017c0  49 6e 73 65 72 74 20 6f  6e 20 72 65 74 75 72 6e  |Insert on return|
000017d0  20 69 6e 20 74 68 65 20  4f 70 74 69 6f 6e 73 20  | in the Options |
000017e0  64 69 61 6c 6f 67 75 65  20 62 6f 78 20 65 6e 61  |dialogue box ena|
000017f0  62 6c 65 73 20 75 73 65  72 73 20 0a 74 6f 20 73  |bles users .to s|
00001800  65 74 20 74 68 69 73 20  65 69 74 68 65 72 20 77  |et this either w|
00001810  61 79 2e 20 20 49 74 73  20 73 74 61 74 75 73 20  |ay.  Its status |
00001820  63 61 6e 20 61 6c 73 6f  20 62 65 20 73 61 76 65  |can also be save|
00001830  64 20 69 6e 20 74 68 65  20 0a 69 6e 69 74 69 61  |d in the .initia|
00001840  6c 69 73 61 74 69 6f 6e  20 66 69 6c 65 20 73 6f  |lisation file so|
00001850  20 74 68 61 74 20 69 74  20 69 73 20 70 65 72 6d  | that it is perm|
00001860  61 6e 65 6e 74 6c 79 20  74 68 65 20 77 61 79 20  |anently the way |
00001870  79 6f 75 20 77 61 6e 74  20 69 74 20 74 6f 20 0a  |you want it to .|
00001880  62 65 2e 0a 0a 25 48 32  25 52 65 70 6c 69 63 61  |be...%H2%Replica|
00001890  74 65 0a 0a 54 68 65 72  65 20 61 72 65 20 74 77  |te..There are tw|
000018a0  6f 20 6e 65 77 20 63 6f  6d 6d 61 6e 64 73 20 77  |o new commands w|
000018b0  68 69 63 68 2c 20 69 6e  20 6d 6f 73 74 20 63 61  |hich, in most ca|
000018c0  73 65 73 2c 20 6d 61 6b  65 20 72 65 70 6c 69 63  |ses, make replic|
000018d0  61 74 69 6f 6e 20 0a 66  61 73 74 65 72 20 61 6e  |ation .faster an|
000018e0  64 20 73 6d 6f 6f 74 68  65 72 20 74 68 61 6e 20  |d smoother than |
000018f0  74 68 65 20 75 73 69 6e  67 20 74 68 65 20 52 65  |the using the Re|
00001900  70 6c 69 63 61 74 65 20  63 6f 6d 6d 61 6e 64 2e  |plicate command.|
00001910  20 20 52 65 70 6c 69 63  61 74 65 20 0a 52 69 67  |  Replicate .Rig|
00001920  68 74 20 28 43 74 72 6c  20 42 52 52 29 20 63 6f  |ht (Ctrl BRR) co|
00001930  70 69 65 73 20 74 68 65  20 6c 65 66 74 2d 6d 6f  |pies the left-mo|
00001940  73 74 20 63 6f 6c 75 6d  6e 20 6f 66 20 61 20 6d  |st column of a m|
00001950  61 72 6b 65 64 20 62 6c  6f 63 6b 20 74 6f 20 61  |arked block to a|
00001960  6c 6c 20 0a 6f 66 20 74  68 65 20 6f 74 68 65 72  |ll .of the other|
00001970  20 63 6f 6c 75 6d 6e 73  20 69 6e 20 74 68 65 20  | columns in the |
00001980  62 6c 6f 63 6b 2e 20 20  52 65 70 6c 69 63 61 74  |block.  Replicat|
00001990  65 20 44 6f 77 6e 20 28  43 74 72 6c 20 42 52 44  |e Down (Ctrl BRD|
000019a0  29 20 63 6f 70 69 65 73  20 0a 74 68 65 20 74 6f  |) copies .the to|
000019b0  70 20 72 6f 77 20 6f 66  20 61 20 62 6c 6f 63 6b  |p row of a block|
000019c0  20 74 6f 20 61 6c 6c 20  6f 66 20 74 68 65 20 6f  | to all of the o|
000019d0  74 68 65 72 20 72 6f 77  73 20 69 6e 20 74 68 65  |ther rows in the|
000019e0  20 62 6c 6f 63 6b 2e 20  20 53 69 6e 63 65 20 0a  | block.  Since .|
000019f0  62 6c 6f 63 6b 73 20 63  61 6e 20 62 65 20 6d 61  |blocks can be ma|
00001a00  72 6b 65 64 20 76 65 72  79 20 65 61 73 69 6c 79  |rked very easily|
00001a10  20 62 79 20 64 72 61 67  67 69 6e 67 20 74 68 65  | by dragging the|
00001a20  20 6d 6f 75 73 65 20 66  72 6f 6d 20 6f 6e 65 20  | mouse from one |
00001a30  63 6f 72 6e 65 72 20 0a  74 6f 20 61 6e 20 6f 70  |corner .to an op|
00001a40  70 6f 73 69 74 65 20 63  6f 72 6e 65 72 20 61 6e  |posite corner an|
00001a50  64 20 74 68 65 20 63 6f  6d 6d 61 6e 64 73 20 63  |d the commands c|
00001a60  61 6e 20 62 65 20 73 65  6c 65 63 74 65 64 20 66  |an be selected f|
00001a70  72 6f 6d 20 74 68 65 20  6d 65 6e 75 20 0a 77 69  |rom the menu .wi|
00001a80  74 68 20 74 68 65 20 6d  6f 75 73 65 20 61 20 72  |th the mouse a r|
00001a90  65 70 6c 69 63 61 74 65  20 63 61 6e 20 62 65 20  |eplicate can be |
00001aa0  64 6f 6e 65 20 76 65 72  79 20 71 75 69 63 6b 6c  |done very quickl|
00001ab0  79 20 77 69 74 68 6f 75  74 20 74 6f 75 63 68 69  |y without touchi|
00001ac0  6e 67 20 0a 74 68 65 20  6b 65 79 62 6f 61 72 64  |ng .the keyboard|
00001ad0  2e 0a 0a 54 68 65 20 6f  6c 64 20 63 6f 6d 6d 61  |...The old comma|
00001ae0  6e 64 20 52 65 70 6c 69  63 61 74 65 20 69 73 20  |nd Replicate is |
00001af0  73 74 69 6c 6c 20 70 72  65 73 65 6e 74 20 61 6e  |still present an|
00001b00  64 20 69 73 20 74 68 65  20 73 61 6d 65 20 61 73  |d is the same as|
00001b10  20 62 65 66 6f 72 65 2e  20 20 0a 0a 25 48 32 25  | before.  ..%H2%|
00001b20  41 6c 74 2d 6b 65 79 20  73 65 71 75 65 6e 63 65  |Alt-key sequence|
00001b30  73 0a 0a 49 6e 20 61 64  64 69 74 69 6f 6e 20 74  |s..In addition t|
00001b40  6f 20 74 68 65 20 73 65  6c 65 63 74 69 6f 6e 20  |o the selection |
00001b50  6f 66 20 63 6f 6d 6d 61  6e 64 73 20 66 72 6f 6d  |of commands from|
00001b60  20 6d 65 6e 75 73 20 62  79 20 75 73 69 6e 67 20  | menus by using |
00001b70  74 68 65 20 6d 6f 75 73  65 20 0a 74 68 65 20 68  |the mouse .the h|
00001b80  6f 74 2d 6b 65 79 20 73  65 71 75 65 6e 63 65 73  |ot-key sequences|
00001b90  20 68 61 76 65 20 62 65  65 6e 20 72 65 74 61 69  | have been retai|
00001ba0  6e 65 64 20 61 6e 64 20  61 72 65 20 73 69 6d 69  |ned and are simi|
00001bb0  6c 61 72 20 74 6f 20 74  68 6f 73 65 20 6f 6e 20  |lar to those on |
00001bc0  0a 61 6c 6c 20 6f 74 68  65 72 20 76 65 72 73 69  |.all other versi|
00001bd0  6f 6e 73 20 6f 66 20 50  69 70 65 44 72 65 61 6d  |ons of PipeDream|
00001be0  2e 20 20 55 6e 66 6f 72  74 75 6e 61 74 65 6c 79  |.  Unfortunately|
00001bf0  20 68 6f 77 65 76 65 72  20 69 74 20 77 61 73 20  | however it was |
00001c00  0a 6e 65 63 65 73 73 61  72 79 20 66 6f 72 20 50  |.necessary for P|
00001c10  69 70 65 44 72 65 61 6d  20 74 6f 20 63 68 61 6e  |ipeDream to chan|
00001c20  67 65 20 74 6f 20 75 73  65 20 74 68 65 20 43 74  |ge to use the Ct|
00001c30  72 6c 20 6b 65 79 20 72  61 74 68 65 72 20 74 68  |rl key rather th|
00001c40  61 6e 20 74 68 65 20 0a  41 6c 74 20 6b 65 79 73  |an the .Alt keys|
00001c50  20 61 73 20 74 68 65 20  73 68 69 66 74 69 6e 67  | as the shifting|
00001c60  20 6b 65 79 2e 20 20 54  68 69 73 20 69 73 20 62  | key.  This is b|
00001c70  65 63 61 75 73 65 20 74  68 65 20 73 70 65 63 69  |ecause the speci|
00001c80  66 69 63 61 74 69 6f 6e  20 6f 66 20 74 68 65 20  |fication of the |
00001c90  0a 41 6c 74 20 6b 65 79  20 77 61 73 20 63 68 61  |.Alt key was cha|
00001ca0  6e 67 65 64 20 62 79 20  41 63 6f 72 6e 20 74 6f  |nged by Acorn to|
00001cb0  20 62 65 20 75 73 65 64  20 77 69 74 68 20 66 6f  | be used with fo|
00001cc0  72 65 69 67 6e 20 63 68  61 72 61 63 74 65 72 20  |reign character |
00001cd0  73 65 74 73 2c 20 0a 61  66 74 65 72 20 50 69 70  |sets, .after Pip|
00001ce0  65 44 72 65 61 6d 20 76  65 72 73 69 6f 6e 20 32  |eDream version 2|
00001cf0  20 77 61 73 20 77 72 69  74 74 65 6e 20 2e 20 20  | was written .  |
00001d00  49 74 20 77 61 73 20 6e  6f 74 20 70 6f 73 73 69  |It was not possi|
00001d10  62 6c 65 20 77 69 74 68  69 6e 20 74 68 65 20 0a  |ble within the .|
00001d20  72 75 6c 65 73 20 6f 66  20 52 49 53 43 20 4f 53  |rules of RISC OS|
00001d30  20 66 6f 72 20 50 69 70  65 44 72 65 61 6d 20 74  | for PipeDream t|
00001d40  6f 20 75 73 65 20 74 68  65 20 41 6c 74 20 6b 65  |o use the Alt ke|
00001d50  79 20 61 73 20 61 20 73  68 69 66 74 69 6e 67 20  |y as a shifting |
00001d60  6b 65 79 2e 0a 0a 53 6f  20 6f 6e 20 74 68 65 20  |key...So on the |
00001d70  5a 38 38 20 74 68 65 20  73 68 69 66 74 69 6e 67  |Z88 the shifting|
00001d80  20 6b 65 79 20 69 73 20  3c 3e 2c 20 6f 6e 20 74  | key is <>, on t|
00001d90  68 65 20 50 43 20 61 6e  64 20 41 72 63 68 69 6d  |he PC and Archim|
00001da0  65 64 65 73 20 0a 50 69  70 65 44 72 65 61 6d 20  |edes .PipeDream |
00001db0  76 65 72 73 69 6f 6e 20  32 20 69 74 20 69 73 20  |version 2 it is |
00001dc0  41 6c 74 2c 20 61 6e 64  20 6f 6e 20 52 49 53 43  |Alt, and on RISC|
00001dd0  20 4f 53 20 50 69 70 65  44 72 65 61 6d 20 69 74  | OS PipeDream it|
00001de0  20 69 73 20 43 74 72 6c  2e 20 20 49 74 20 0a 69  | is Ctrl.  It .i|
00001df0  73 2c 20 6f 66 20 63 6f  75 72 73 65 2c 20 75 73  |s, of course, us|
00001e00  75 61 6c 6c 79 20 70 72  65 66 65 72 61 62 6c 65  |ually preferable|
00001e10  20 74 6f 20 73 65 6c 65  63 74 20 63 6f 6d 6d 61  | to select comma|
00001e20  6e 64 73 20 66 72 6f 6d  20 6d 65 6e 75 73 20 77  |nds from menus w|
00001e30  69 74 68 20 0a 74 68 65  20 6d 6f 75 73 65 2e 0a  |ith .the mouse..|
00001e40  0a 54 68 65 20 63 68 61  6e 67 65 73 20 74 6f 20  |.The changes to |
00001e50  74 68 65 20 41 6c 74 20  6b 65 79 20 61 6c 73 6f  |the Alt key also|
00001e60  20 6d 65 61 6e 20 74 68  61 74 20 69 74 20 69 73  | mean that it is|
00001e70  20 6e 6f 20 6c 6f 6e 67  65 72 20 70 6f 73 73 69  | no longer possi|
00001e80  62 6c 65 20 66 6f 72 20  0a 41 6c 74 20 2b 20 66  |ble for .Alt + f|
00001e90  75 6e 63 74 69 6f 6e 20  6b 65 79 20 74 6f 20 62  |unction key to b|
00001ea0  65 20 64 65 66 69 6e 65  64 20 62 79 20 74 68 65  |e defined by the|
00001eb0  20 75 73 65 72 2e 0a 0a  25 48 32 25 50 72 65 76  | user...%H2%Prev|
00001ec0  69 6f 75 73 20 6d 61 74  63 68 20 28 43 74 72 6c  |ious match (Ctrl|
00001ed0  20 42 50 4d 29 0a 0a 50  72 65 76 69 6f 75 73 20  | BPM)..Previous |
00001ee0  6d 61 74 63 68 20 69 73  20 74 68 65 20 6f 70 70  |match is the opp|
00001ef0  6f 73 69 74 65 20 6f 66  20 4e 65 78 74 20 6d 61  |osite of Next ma|
00001f00  74 63 68 20 61 6e 64 20  6d 6f 76 65 73 20 74 68  |tch and moves th|
00001f10  65 20 63 61 72 65 74 20  62 61 63 6b 20 0a 74 6f  |e caret back .to|
00001f20  20 74 68 65 20 70 72 65  76 69 6f 75 73 20 6f 63  | the previous oc|
00001f30  63 75 72 72 65 6e 63 65  20 6f 66 20 74 68 65 20  |currence of the |
00001f40  73 74 72 69 6e 67 20 67  69 76 65 6e 20 69 6e 20  |string given in |
00001f50  74 68 65 20 53 65 61 72  63 68 20 64 69 61 6c 6f  |the Search dialo|
00001f60  67 75 65 20 0a 62 6f 78  2e 20 20 49 74 20 69 73  |gue .box.  It is|
00001f70  20 6d 6f 73 74 20 75 73  65 66 75 6c 20 77 68 65  | most useful whe|
00001f80  6e 20 69 6e 61 64 76 65  72 74 65 6e 74 6c 79 20  |n inadvertently |
00001f90  67 69 76 69 6e 67 20 74  6f 6f 20 6d 61 6e 79 20  |giving too many |
00001fa0  4e 65 78 74 20 6d 61 74  63 68 20 0a 63 6f 6d 6d  |Next match .comm|
00001fb0  61 6e 64 73 20 62 75 74  20 63 61 6e 20 62 65 20  |ands but can be |
00001fc0  75 73 65 64 20 66 6f 72  20 73 65 61 72 63 68 69  |used for searchi|
00001fd0  6e 67 20 61 20 66 69 6c  65 20 62 61 63 6b 77 61  |ng a file backwa|
00001fe0  72 64 73 20 69 66 20 79  6f 75 20 73 6f 20 0a 64  |rds if you so .d|
00001ff0  65 73 69 72 65 2e 0a 0a  25 48 32 25 53 75 62 67  |esire...%H2%Subg|
00002000  72 61 6d 73 20 28 43 74  72 6c 20 53 48 29 0a 0a  |rams (Ctrl SH)..|
00002010  53 75 62 67 72 61 6d 73  20 61 72 65 20 6c 69 6b  |Subgrams are lik|
00002020  65 20 61 6e 61 67 72 61  6d 73 20 77 69 74 68 6f  |e anagrams witho|
00002030  75 74 20 74 68 65 20 72  65 73 74 72 69 63 74 69  |ut the restricti|
00002040  6f 6e 20 74 68 61 74 20  61 6c 6c 20 6c 65 74 74  |on that all lett|
00002050  65 72 73 20 6f 66 20 0a  74 68 65 20 6f 72 69 67  |ers of .the orig|
00002060  69 6e 61 6c 20 77 6f 72  64 20 6d 75 73 74 20 62  |inal word must b|
00002070  65 20 75 73 65 64 2e 20  20 65 67 20 61 2c 20 6d  |e used.  eg a, m|
00002080  65 2c 20 6d 61 64 2c 20  64 61 6d 65 20 61 6e 64  |e, mad, dame and|
00002090  20 61 72 6d 65 64 20 61  72 65 20 61 6c 6c 20 0a  | armed are all .|
000020a0  73 75 62 67 72 61 6d 73  20 6f 66 20 44 72 65 61  |subgrams of Drea|
000020b0  6d 2e 20 20 54 68 69 73  20 66 65 61 74 75 72 65  |m.  This feature|
000020c0  20 77 69 6c 6c 20 68 65  6c 70 20 79 6f 75 20 74  | will help you t|
000020d0  6f 20 69 6d 70 72 65 73  73 20 79 6f 75 72 20 66  |o impress your f|
000020e0  72 69 65 6e 64 73 20 0a  77 69 74 68 20 79 6f 75  |riends .with you|
000020f0  72 20 6d 61 73 73 69 76  65 20 76 6f 63 61 62 75  |r massive vocabu|
00002100  6c 61 72 79 20 61 6e 64  20 77 69 6e 20 6e 65 77  |lary and win new|
00002110  73 70 61 70 65 72 20 63  6f 6d 70 65 74 69 74 69  |spaper competiti|
00002120  6f 6e 73 2e 0a 0a 25 48  32 25 43 61 72 72 69 61  |ons...%H2%Carria|
00002130  67 65 20 72 65 74 75 72  6e 20 61 6e 64 20 6c 69  |ge return and li|
00002140  6e 65 66 65 65 64 0a 0a  54 68 65 20 70 6f 73 69  |nefeed..The posi|
00002150  74 69 6f 6e 20 77 69 74  68 20 41 72 63 68 69 6d  |tion with Archim|
00002160  65 64 65 73 20 73 6f 66  74 77 61 72 65 20 61 6e  |edes software an|
00002170  64 20 63 61 72 72 69 61  67 65 20 72 65 74 75 72  |d carriage retur|
00002180  6e 73 20 28 43 52 29 20  61 6e 64 20 0a 6c 69 6e  |ns (CR) and .lin|
00002190  65 66 65 65 64 73 20 28  4c 46 29 20 73 65 65 6d  |efeeds (LF) seem|
000021a0  73 20 74 6f 20 62 65 20  61 20 6c 69 74 74 6c 65  |s to be a little|
000021b0  20 63 6f 6e 66 75 73 65  64 2e 20 20 53 6f 6d 65  | confused.  Some|
000021c0  20 65 64 69 74 6f 72 73  20 75 73 65 20 43 52 20  | editors use CR |
000021d0  61 73 20 0a 74 68 65 69  72 20 6c 69 6e 65 20 73  |as .their line s|
000021e0  65 70 61 72 61 74 6f 72  20 28 64 65 72 69 76 69  |eparator (derivi|
000021f0  6e 67 20 66 72 6f 6d 20  42 42 43 20 64 61 79 73  |ng from BBC days|
00002200  29 2c 20 73 6f 6d 65 20  65 64 69 74 6f 72 73 20  |), some editors |
00002210  75 73 65 20 4c 46 20 0a  28 64 65 72 69 76 69 6e  |use LF .(derivin|
00002220  67 20 66 72 6f 6d 20 55  4e 49 58 29 2c 20 73 6f  |g from UNIX), so|
00002230  6d 65 20 65 64 69 74 6f  72 73 20 75 73 65 20 43  |me editors use C|
00002240  52 2c 4c 46 20 28 64 65  72 69 76 69 6e 67 20 66  |R,LF (deriving f|
00002250  72 6f 6d 20 43 50 2f 4d  20 61 6e 64 20 0a 4d 53  |rom CP/M and .MS|
00002260  2d 44 4f 53 29 2e 20 20  49 74 20 77 6f 75 6c 64  |-DOS).  It would|
00002270  20 62 65 20 68 65 6c 70  66 75 6c 20 69 66 20 61  | be helpful if a|
00002280  6c 6c 20 65 64 69 74 6f  72 73 20 63 6f 75 6c 64  |ll editors could|
00002290  20 61 75 74 6f 6d 61 74  69 63 61 6c 6c 79 20 6c  | automatically l|
000022a0  6f 61 64 20 0a 66 69 6c  65 73 20 6f 66 20 61 6e  |oad .files of an|
000022b0  79 20 74 79 70 65 20 28  6c 69 6b 65 20 50 69 70  |y type (like Pip|
000022c0  65 44 72 65 61 6d 20 63  61 6e 29 20 62 75 74 2c  |eDream can) but,|
000022d0  20 73 61 64 6c 79 2c 20  74 68 69 73 20 69 73 20  | sadly, this is |
000022e0  6e 6f 74 20 74 68 65 20  0a 63 61 73 65 2e 20 20  |not the .case.  |
000022f0  53 6f 20 50 69 70 65 44  72 65 61 6d 20 33 20 68  |So PipeDream 3 h|
00002300  61 73 20 61 6e 20 6f 70  74 69 6f 6e 20 69 6e 20  |as an option in |
00002310  74 68 65 20 53 61 76 65  20 64 69 61 6c 6f 67 75  |the Save dialogu|
00002320  65 20 62 6f 78 20 77 68  69 63 68 20 0a 65 6e 61  |e box which .ena|
00002330  62 6c 65 73 20 74 6f 20  73 70 65 63 69 66 79 20  |bles to specify |
00002340  77 68 61 74 20 6c 69 6e  65 20 73 65 70 61 72 61  |what line separa|
00002350  74 6f 72 20 74 6f 20 73  61 76 65 20 74 68 65 20  |tor to save the |
00002360  66 69 6c 65 20 77 69 74  68 2e 20 20 54 68 65 20  |file with.  The |
00002370  0a 6f 70 74 69 6f 6e 73  20 61 72 65 20 43 52 2c  |.options are CR,|
00002380  20 4c 46 2c 20 43 52 2b  4c 46 2c 20 4c 46 2b 43  | LF, CR+LF, LF+C|
00002390  52 2e 0a 0a 25 48 32 25  4e 65 67 61 74 69 76 65  |R...%H2%Negative|
000023a0  20 6e 75 6d 62 65 72 73  0a 0a 4e 65 67 61 74 69  | numbers..Negati|
000023b0  76 65 20 6e 75 6d 62 65  72 73 20 69 6e 20 65 78  |ve numbers in ex|
000023c0  70 72 65 73 73 69 6f 6e  20 73 6c 6f 74 73 20 63  |pression slots c|
000023d0  61 6e 20 62 65 20 64 69  73 70 6c 61 79 65 64 20  |an be displayed |
000023e0  6f 6e 20 74 68 65 20 73  63 72 65 65 6e 20 69 6e  |on the screen in|
000023f0  20 0a 61 20 64 69 66 66  65 72 65 6e 74 20 63 6f  | .a different co|
00002400  6c 6f 75 72 20 74 6f 20  74 68 65 20 72 65 73 74  |lour to the rest|
00002410  20 6f 66 20 74 68 65 20  74 65 78 74 2e 20 20 54  | of the text.  T|
00002420  68 69 73 20 63 61 6e 20  62 65 20 76 65 72 79 20  |his can be very |
00002430  73 74 72 69 6b 69 6e 67  20 0a 77 68 65 6e 20 74  |striking .when t|
00002440  68 65 20 63 6f 6c 6f 75  72 20 63 68 6f 73 65 6e  |he colour chosen|
00002450  20 69 73 20 72 65 64 2e  0a 0a 25 48 32 25 43 65  | is red...%H2%Ce|
00002460  6e 74 72 65 20 77 69 6e  64 6f 77 0a 0a 54 68 69  |ntre window..Thi|
00002470  73 20 6e 65 77 20 63 6f  6d 6d 61 6e 64 20 69 73  |s new command is|
00002480  20 70 72 6f 76 69 64 65  64 20 74 6f 20 70 6f 73  | provided to pos|
00002490  69 74 69 6f 6e 20 74 68  65 20 6c 69 6e 65 20 63  |ition the line c|
000024a0  6f 6e 74 61 69 6e 69 6e  67 20 74 68 65 20 63 61  |ontaining the ca|
000024b0  72 65 74 20 0a 69 6e 20  74 68 65 20 6d 69 64 64  |ret .in the midd|
000024c0  6c 65 20 6f 66 20 74 68  65 20 77 69 6e 64 6f 77  |le of the window|
000024d0  2e 0a 0a 25 48 32 25 46  69 78 65 64 20 72 6f 77  |...%H2%Fixed row|
000024e0  73 20 61 6e 64 20 63 6f  6c 75 6d 6e 73 0a 0a 54  |s and columns..T|
000024f0  68 65 20 73 74 61 74 75  73 20 6f 66 20 66 69 78  |he status of fix|
00002500  65 64 20 72 6f 77 73 20  61 6e 64 20 63 6f 6c 75  |ed rows and colu|
00002510  6d 6e 73 20 69 73 20 6e  6f 77 20 73 61 76 65 64  |mns is now saved|
00002520  20 77 69 74 68 20 74 68  65 20 66 69 6c 65 2e 0a  | with the file..|
00002530  0a 25 48 32 25 53 6f 72  74 69 6e 67 0a 0a 53 6f  |.%H2%Sorting..So|
00002540  72 74 69 6e 67 20 69 6e  20 50 69 70 65 44 72 65  |rting in PipeDre|
00002550  61 6d 20 33 20 69 73 20  73 65 76 65 72 61 6c 20  |am 3 is several |
00002560  74 69 6d 65 73 20 66 61  73 74 65 72 20 74 68 61  |times faster tha|
00002570  6e 20 76 65 72 73 69 6f  6e 20 32 20 28 74 68 65  |n version 2 (the|
00002580  20 0a 65 78 61 63 74 20  66 61 63 74 6f 72 20 64  | .exact factor d|
00002590  65 70 65 6e 64 69 6e 67  20 6f 6e 20 74 68 65 20  |epending on the |
000025a0  64 61 74 61 20 66 69 6c  65 29 2e 20 20 50 69 70  |data file).  Pip|
000025b0  65 44 72 65 61 6d 20 33  20 63 61 6e 20 6e 6f 77  |eDream 3 can now|
000025c0  20 73 6f 72 74 20 0a 6d  75 6c 74 69 2d 72 6f 77  | sort .multi-row|
000025d0  20 72 65 63 6f 72 64 73  2e 20 52 6f 77 73 20 74  | records. Rows t|
000025e0  68 61 74 20 61 72 65 20  62 6c 61 6e 6b 20 69 6e  |hat are blank in|
000025f0  20 74 68 65 20 66 69 72  73 74 20 6b 65 79 20 66  | the first key f|
00002600  69 65 6c 64 20 61 72 65  20 62 6f 75 6e 64 20 0a  |ield are bound .|
00002610  74 6f 20 74 68 65 20 66  69 72 73 74 20 72 6f 77  |to the first row|
00002620  20 61 62 6f 76 65 20 74  68 61 74 20 69 73 20 6e  | above that is n|
00002630  6f 74 20 62 6c 61 6e 6b  20 69 6e 20 74 68 65 20  |ot blank in the |
00002640  66 69 72 73 74 20 6b 65  79 20 66 69 65 6c 64 2e  |first key field.|
00002650  20 20 54 68 69 73 20 0a  65 6e 61 62 6c 65 73 20  |  This .enables |
00002660  72 65 63 6f 72 64 73 20  63 6f 6e 74 61 69 6e 69  |records containi|
00002670  6e 67 20 70 61 72 61 67  72 61 70 68 73 20 6f 66  |ng paragraphs of|
00002680  20 74 65 78 74 2c 20 66  6f 72 20 65 78 61 6d 70  | text, for examp|
00002690  6c 65 2c 20 74 6f 20 62  65 20 0a 73 6f 72 74 65  |le, to be .sorte|
000026a0  64 2e 0a 0a 25 48 32 25  44 61 74 65 20 66 6f 72  |d...%H2%Date for|
000026b0  6d 61 74 0a 0a 41 20 74  65 78 74 75 61 6c 20 64  |mat..A textual d|
000026c0  61 74 65 20 66 6f 72 6d  61 74 20 68 61 73 20 62  |ate format has b|
000026d0  65 65 6e 20 70 72 6f 76  69 64 65 64 20 69 6e 20  |een provided in |
000026e0  61 64 64 69 74 69 6f 6e  20 74 6f 20 64 69 73 70  |addition to disp|
000026f0  6c 61 79 69 6e 67 20 64  61 74 65 73 20 0a 69 6e  |laying dates .in|
00002700  20 45 6e 67 6c 69 73 68  20 6f 72 20 41 6d 65 72  | English or Amer|
00002710  69 63 61 6e 20 66 6f 72  6d 61 74 73 2e 0a 0a 25  |ican formats...%|
00002720  48 32 25 46 69 6c 65 20  66 6f 72 6d 61 74 73 0a  |H2%File formats.|
00002730  0a 50 69 70 65 44 72 65  61 6d 20 63 61 6e 20 6e  |.PipeDream can n|
00002740  6f 77 20 6c 6f 61 64 20  61 6e 64 20 73 61 76 65  |ow load and save|
00002750  20 56 49 45 57 20 66 69  6c 65 73 2c 20 63 61 6e  | VIEW files, can|
00002760  20 6c 6f 61 64 20 56 69  65 77 53 68 65 65 74 20  | load ViewSheet |
00002770  66 69 6c 65 73 20 0a 61  6e 64 20 63 61 6e 20 73  |files .and can s|
00002780  61 76 65 20 41 63 6f 72  6e 20 44 54 50 20 66 69  |ave Acorn DTP fi|
00002790  6c 65 73 2e 0a 0a 25 48  32 25 54 68 6f 75 73 61  |les...%H2%Thousa|
000027a0  6e 64 73 0a 0a 50 69 70  65 44 72 65 61 6d 20 33  |nds..PipeDream 3|
000027b0  20 63 61 6e 20 64 69 73  70 6c 61 79 20 6c 61 72  | can display lar|
000027c0  67 65 20 6e 75 6d 62 65  72 73 20 69 6e 20 61 20  |ge numbers in a |
000027d0  76 61 72 69 65 74 79 20  6f 66 20 77 61 79 73 2e  |variety of ways.|
000027e0  20 20 53 65 76 65 72 61  6c 20 0a 73 65 70 61 72  |  Several .separ|
000027f0  61 74 6f 72 73 20 63 61  6e 20 62 65 20 75 73 65  |ators can be use|
00002800  64 20 74 6f 20 73 65 70  61 72 61 74 65 20 74 68  |d to separate th|
00002810  6f 75 73 61 6e 64 73 20  61 6e 64 20 6d 69 6c 6c  |ousands and mill|
00002820  69 6f 6e 73 2e 20 20 46  6f 72 20 65 78 61 6d 70  |ions.  For examp|
00002830  6c 65 0a 0a 20 20 31 32  33 34 35 36 37 2e 38 39  |le..  1234567.89|
00002840  0a 31 20 32 33 34 20 35  36 37 2e 37 38 0a 31 2c  |.1 234 567.78.1,|
00002850  32 33 34 2c 35 36 37 2e  38 39 0a 31 2e 32 33 34  |234,567.89.1.234|
00002860  2e 35 36 37 2c 38 39 0a  0a 25 48 32 25 44 61 74  |.567,89..%H2%Dat|
00002870  61 62 61 73 65 20 66 75  6e 63 74 69 6f 6e 73 0a  |abase functions.|
00002880  0a 54 68 65 20 73 79 6e  74 61 78 20 6f 66 20 64  |.The syntax of d|
00002890  61 74 61 62 61 73 65 20  66 75 6e 63 74 69 6f 6e  |atabase function|
000028a0  73 20 68 61 73 20 62 65  65 6e 20 69 6d 70 72 6f  |s has been impro|
000028b0  76 65 64 2e 20 20 49 6e  20 50 69 70 65 44 72 65  |ved.  In PipeDre|
000028c0  61 6d 20 32 20 74 68 65  20 0a 24 20 6f 70 65 72  |am 2 the .$ oper|
000028d0  61 74 6f 72 20 77 61 73  20 75 73 65 64 20 74 6f  |ator was used to|
000028e0  20 64 65 74 65 72 6d 69  6e 65 20 62 6f 74 68 20  | determine both |
000028f0  77 68 65 74 68 65 72 20  74 68 65 20 73 6c 6f 74  |whether the slot|
00002900  20 72 65 66 65 72 65 6e  63 65 20 73 68 6f 75 6c  | reference shoul|
00002910  64 20 0a 62 65 20 75 70  64 61 74 65 64 20 64 75  |d .be updated du|
00002920  72 69 6e 67 20 72 65 70  6c 69 63 61 74 69 6f 6e  |ring replication|
00002930  20 61 6e 64 20 61 6c 73  6f 20 77 68 65 74 68 65  | and also whethe|
00002940  72 20 74 68 65 20 73 6c  6f 74 20 72 65 66 65 72  |r the slot refer|
00002950  65 6e 63 65 20 0a 73 68  6f 75 6c 64 20 62 65 20  |ence .should be |
00002960  75 70 64 61 74 65 64 20  64 75 72 69 6e 67 20 72  |updated during r|
00002970  65 63 61 6c 63 75 6c 61  74 69 6f 6e 2e 20 20 49  |ecalculation.  I|
00002980  6e 20 50 69 70 65 44 72  65 61 6d 20 33 20 65 61  |n PipeDream 3 ea|
00002990  63 68 20 6f 64 20 74 68  65 73 65 20 0a 68 61 73  |ch od these .has|
000029a0  20 69 74 73 20 6f 77 6e  20 6f 70 65 72 61 74 6f  | its own operato|
000029b0  72 2e 20 20 24 20 69 73  20 73 74 69 6c 6c 20 75  |r.  $ is still u|
000029c0  73 65 64 20 74 6f 20 64  65 74 65 72 6d 69 6e 65  |sed to determine|
000029d0  20 77 68 65 74 68 65 72  20 74 68 65 20 73 6c 6f  | whether the slo|
000029e0  74 20 0a 72 65 66 65 72  65 6e 63 65 20 73 68 6f  |t .reference sho|
000029f0  75 6c 64 20 62 65 20 75  70 64 61 74 65 64 20 64  |uld be updated d|
00002a00  75 72 69 6e 67 20 72 65  70 6c 69 63 61 74 69 6f  |uring replicatio|
00002a10  6e 2e 20 20 23 20 69 73  20 75 73 65 64 20 74 6f  |n.  # is used to|
00002a20  20 64 65 74 65 72 6d 69  6e 65 20 0a 77 68 65 74  | determine .whet|
00002a30  68 65 72 20 74 68 65 20  73 6c 6f 74 20 72 65 66  |her the slot ref|
00002a40  65 72 65 6e 63 65 20 73  68 6f 75 6c 64 20 62 65  |erence should be|
00002a50  20 75 70 64 61 74 65 64  20 64 75 72 69 6e 67 20  | updated during |
00002a60  72 65 63 61 6c 63 75 6c  61 74 69 6f 6e 2e 0a 0a  |recalculation...|
00002a70  54 68 69 73 20 63 68 61  6e 67 65 20 6d 65 61 6e  |This change mean|
00002a80  73 20 74 68 61 74 20 64  61 74 61 62 61 73 65 20  |s that database |
00002a90  66 75 6e 63 74 69 6f 6e  73 20 77 72 69 74 74 65  |functions writte|
00002aa0  6e 20 69 6e 20 66 69 6c  65 73 20 66 6f 72 20 0a  |n in files for .|
00002ab0  50 69 70 65 44 72 65 61  6d 20 32 20 6d 61 79 20  |PipeDream 2 may |
00002ac0  70 72 6f 64 75 63 65 20  64 69 66 66 65 72 65 6e  |produce differen|
00002ad0  74 20 72 65 73 75 6c 74  73 20 69 6e 20 50 69 70  |t results in Pip|
00002ae0  65 44 72 65 61 6d 20 33  20 61 6e 64 20 64 61 74  |eDream 3 and dat|
00002af0  61 62 61 73 65 20 0a 66  75 6e 63 74 69 6f 6e 73  |abase .functions|
00002b00  20 77 72 69 74 74 65 6e  20 69 6e 20 66 69 6c 65  | written in file|
00002b10  73 20 66 6f 72 20 50 69  70 65 64 72 65 61 6d 20  |s for Pipedream |
00002b20  33 20 6d 61 79 20 6e 6f  74 20 62 65 20 61 63 63  |3 may not be acc|
00002b30  65 70 74 65 64 20 69 6e  20 0a 50 69 70 65 64 72  |epted in .Pipedr|
00002b40  65 61 6d 20 32 2e 20 20  57 68 65 6e 20 63 6f 6e  |eam 2.  When con|
00002b50  76 65 72 74 69 6e 67 20  66 69 6c 65 73 20 66 72  |verting files fr|
00002b60  6f 6d 20 50 69 70 65 44  72 65 61 6d 20 32 20 74  |om PipeDream 2 t|
00002b70  6f 20 50 69 70 65 64 72  65 61 6d 20 33 20 69 74  |o Pipedream 3 it|
00002b80  20 0a 69 73 20 75 73 75  61 6c 6c 79 20 6e 65 63  | .is usually nec|
00002b90  65 73 73 61 72 79 20 74  6f 20 65 69 74 68 65 72  |essary to either|
00002ba0  20 72 65 70 6c 61 63 65  20 24 20 73 69 67 6e 73  | replace $ signs|
00002bb0  20 69 6e 20 74 68 65 20  63 6f 6e 64 69 74 69 6f  | in the conditio|
00002bc0  6e 20 73 74 72 69 6e 67  20 0a 77 69 74 68 20 61  |n string .with a|
00002bd0  20 23 20 6f 72 20 61 64  64 20 61 20 23 20 61 6e  | # or add a # an|
00002be0  64 20 72 65 74 61 69 6e  20 74 68 65 20 24 2e 0a  |d retain the $..|
00002bf0  0a 25 48 32 25 53 70 72  65 61 64 73 68 65 65 74  |.%H2%Spreadsheet|
00002c00  20 66 75 6e 63 74 69 6f  6e 73 0a 0a 54 68 65 20  | functions..The |
00002c10  66 6f 6c 6c 6f 77 69 6e  67 20 6e 65 77 20 73 70  |following new sp|
00002c20  72 65 61 64 73 68 65 65  74 20 66 75 6e 63 74 69  |readsheet functi|
00002c30  6f 6e 73 20 68 61 76 65  20 62 65 65 6e 20 70 72  |ons have been pr|
00002c40  6f 76 69 64 65 64 3a 0a  0a 41 54 4e 32 28 78 2c  |ovided:..ATN2(x,|
00002c50  79 29 0a 4d 4f 4e 54 48  44 41 59 53 28 64 61 74  |y).MONTHDAYS(dat|
00002c60  65 29 0a 0a 52 41 4e 44  28 6e 29 0a 52 4f 55 4e  |e)..RAND(n).ROUN|
00002c70  44 28 6e 2c 70 29 0a 52  4f 57 28 29 2c 43 4f 4c  |D(n,p).ROW(),COL|
00002c80  28 29 0a 0a 44 43 4f 55  4e 54 41 28 72 61 6e 67  |()..DCOUNTA(rang|
00002c90  65 2c 63 6f 6e 64 69 74  69 6f 6e 29 0a 0a 25 48  |e,condition)..%H|
00002ca0  32 25 50 72 69 6e 74 69  6e 67 0a 0a 41 73 20 77  |2%Printing..As w|
00002cb0  65 6c 6c 20 61 73 20 68  61 76 69 6e 67 20 69 74  |ell as having it|
00002cc0  73 20 6f 77 6e 20 70 72  69 6e 74 65 72 20 64 72  |s own printer dr|
00002cd0  69 76 65 72 20 73 79 73  74 65 6d 2c 20 50 69 70  |iver system, Pip|
00002ce0  65 44 72 65 61 6d 20 33  20 63 61 6e 20 61 6c 73  |eDream 3 can als|
00002cf0  6f 20 0a 70 72 69 6e 74  20 75 73 69 6e 67 20 74  |o .print using t|
00002d00  68 65 20 52 49 53 43 20  4f 53 20 70 72 69 6e 74  |he RISC OS print|
00002d10  65 72 20 64 72 69 76 65  72 73 20 73 75 70 70 6c  |er drivers suppl|
00002d20  69 65 64 20 62 79 20 41  63 6f 72 6e 2e 20 20 57  |ied by Acorn.  W|
00002d30  68 69 63 68 20 0a 6d 65  74 68 6f 64 20 79 6f 75  |hich .method you|
00002d40  20 75 73 65 20 69 73 20  75 70 20 74 6f 20 79 6f  | use is up to yo|
00002d50  75 2e 20 20 54 68 65 20  50 69 70 65 44 72 65 61  |u.  The PipeDrea|
00002d60  6d 20 64 72 69 76 65 72  73 20 77 69 6c 6c 20 75  |m drivers will u|
00002d70  73 75 61 6c 6c 79 20 62  65 20 0a 6d 75 63 68 20  |sually be .much |
00002d80  66 61 73 74 65 72 20 74  68 61 6e 20 74 68 65 20  |faster than the |
00002d90  52 49 53 43 20 4f 53 20  64 72 69 76 65 72 73 20  |RISC OS drivers |
00002da0  62 65 63 61 75 73 65 20  74 68 65 79 20 6a 75 73  |because they jus|
00002db0  74 20 73 65 6e 64 69 6e  67 20 6f 75 74 20 0a 6c  |t sending out .l|
00002dc0  69 6e 65 73 20 6f 66 20  63 68 61 72 61 63 74 65  |ines of characte|
00002dd0  72 73 2c 20 77 68 65 72  65 61 73 20 74 68 65 20  |rs, whereas the |
00002de0  52 49 53 43 20 4f 53 20  64 72 69 76 65 72 73 20  |RISC OS drivers |
00002df0  62 75 69 6c 64 20 75 70  20 70 61 67 65 73 20 6f  |build up pages o|
00002e00  66 20 0a 62 69 74 2d 6d  61 70 70 65 64 20 67 72  |f .bit-mapped gr|
00002e10  61 70 68 69 63 73 2e 20  20 4f 6e 6c 79 20 74 68  |aphics.  Only th|
00002e20  65 20 52 49 53 43 20 4f  53 20 64 72 69 76 65 72  |e RISC OS driver|
00002e30  73 20 63 61 6e 20 70 72  69 6e 74 20 70 69 63 74  |s can print pict|
00002e40  75 72 65 73 20 61 6e 64  20 0a 66 6f 6e 74 73 2e  |ures and .fonts.|
00002e50  0a 0a 45 78 74 72 61 20  6f 70 74 69 6f 6e 73 20  |..Extra options |
00002e60  68 61 76 65 20 62 65 65  6e 20 61 64 64 65 64 20  |have been added |
00002e70  74 6f 20 74 68 65 20 50  72 69 6e 74 20 64 69 61  |to the Print dia|
00002e80  6c 6f 67 75 65 20 62 6f  78 20 74 6f 20 70 72 69  |logue box to pri|
00002e90  6e 74 20 0a 6d 75 6c 74  69 70 6c 65 20 63 6f 70  |nt .multiple cop|
00002ea0  69 65 73 20 61 6e 64 20  74 77 6f 2d 73 69 64 65  |ies and two-side|
00002eb0  64 20 70 72 69 6e 74 69  6e 67 2e 20 20 54 77 6f  |d printing.  Two|
00002ec0  2d 73 69 64 65 64 20 70  72 69 6e 74 69 6e 67 20  |-sided printing |
00002ed0  69 73 20 0a 72 65 76 65  72 73 69 6e 67 20 74 68  |is .reversing th|
00002ee0  65 20 6f 72 64 65 72 20  6f 66 20 70 61 72 61 6d  |e order of param|
00002ef0  65 74 65 72 73 20 69 6e  20 68 65 61 64 65 72 73  |eters in headers|
00002f00  20 61 6e 64 20 66 6f 6f  74 65 72 73 20 6f 6e 20  | and footers on |
00002f10  65 76 65 6e 20 0a 6e 75  6d 62 65 72 65 64 20 28  |even .numbered (|
00002f20  6c 65 66 74 2d 68 61 6e  64 29 20 70 61 67 65 73  |left-hand) pages|
00002f30  20 61 6e 64 20 70 72 69  6e 74 69 6e 67 20 65 78  | and printing ex|
00002f40  74 72 61 20 63 68 61 72  61 63 74 65 72 73 20 69  |tra characters i|
00002f50  6e 20 74 68 65 20 6c 65  66 74 20 0a 6d 61 72 67  |n the left .marg|
00002f60  69 6e 20 6f 66 20 6f 64  64 20 6e 75 6d 62 65 72  |in of odd number|
00002f70  65 64 20 28 72 69 67 68  74 2d 68 61 6e 64 29 20  |ed (right-hand) |
00002f80  70 61 67 65 73 2e 20 20  4e 6f 74 65 20 74 68 61  |pages.  Note tha|
00002f90  74 20 69 74 20 69 73 20  6e 6f 74 20 74 68 65 20  |t it is not the |
00002fa0  66 61 72 20 0a 6d 6f 72  65 20 75 73 65 66 75 6c  |far .more useful|
00002fb0  20 61 62 69 6c 69 74 79  20 74 6f 20 70 72 69 6e  | ability to prin|
00002fc0  74 20 6f 6e 20 62 6f 74  68 20 73 69 64 65 73 20  |t on both sides |
00002fd0  6f 66 20 74 68 65 20 70  61 70 65 72 20 77 69 74  |of the paper wit|
00002fe0  68 6f 75 74 20 79 6f 75  72 20 0a 74 75 72 6e 69  |hout your .turni|
00002ff0  6e 67 20 69 74 20 6f 76  65 72 2e 20 20 28 54 68  |ng it over.  (Th|
00003000  61 74 27 73 20 61 20 68  61 72 64 77 61 72 65 20  |at's a hardware |
00003010  70 72 6f 62 6c 65 6d 2e  29 0a 0a 25 48 32 25 45  |problem.)..%H2%E|
00003020  78 74 65 72 6e 61 6c 20  72 65 66 65 72 65 6e 63  |xternal referenc|
00003030  65 73 0a 0a 57 69 74 68  20 6d 6f 72 65 20 74 68  |es..With more th|
00003040  61 6e 20 6f 6e 65 20 66  69 6c 65 20 6c 6f 61 64  |an one file load|
00003050  65 64 20 69 74 20 69 73  20 70 6f 73 73 69 62 6c  |ed it is possibl|
00003060  65 20 74 6f 20 61 63 63  65 73 73 20 73 6c 6f 74  |e to access slot|
00003070  73 20 69 6e 20 66 69 6c  65 73 20 0a 69 6e 20 6f  |s in files .in o|
00003080  74 68 65 72 20 77 69 6e  64 6f 77 73 2c 20 61 6e  |ther windows, an|
00003090  64 20 73 6f 20 79 6f 75  20 63 61 6e 20 6c 69 6e  |d so you can lin|
000030a0  6b 20 73 65 76 65 72 61  6c 20 73 70 72 65 61 64  |k several spread|
000030b0  73 68 65 65 74 73 20 74  6f 67 65 74 68 65 72 20  |sheets together |
000030c0  74 6f 20 0a 67 65 6e 65  72 61 74 65 20 67 72 61  |to .generate gra|
000030d0  6e 64 20 74 6f 74 61 6c  73 20 6f 72 20 63 72 65  |nd totals or cre|
000030e0  61 74 65 20 33 2d 64 69  6d 65 6e 73 69 6f 6e 61  |ate 3-dimensiona|
000030f0  6c 20 6d 6f 64 65 6c 73  2e 0a 0a 25 48 32 25 53  |l models...%H2%S|
00003100  61 76 65 0a 0a 41 66 74  65 72 20 73 61 76 69 6e  |ave..After savin|
00003110  67 20 61 20 66 69 6c 65  20 77 69 74 68 20 61 20  |g a file with a |
00003120  6e 65 77 20 6e 61 6d 65  20 74 68 65 20 66 69 6c  |new name the fil|
00003130  65 20 69 6e 20 6d 65 6d  6f 72 79 20 69 73 20 72  |e in memory is r|
00003140  65 6e 61 6d 65 64 20 61  6c 73 6f 2e 0a 0a 25 48  |enamed also...%H|
00003150  32 25 53 61 76 65 2f 52  65 73 74 6f 72 65 2f 53  |2%Save/Restore/S|
00003160  77 61 70 20 70 6f 73 69  74 69 6f 6e 0a 0a 53 61  |wap position..Sa|
00003170  76 65 20 50 6f 73 69 74  69 6f 6e 20 68 61 73 20  |ve Position has |
00003180  62 65 65 6e 20 61 73 73  69 67 6e 65 64 20 74 6f  |been assigned to|
00003190  20 66 75 6e 63 74 69 6f  6e 20 6b 65 79 20 53 68  | function key Sh|
000031a0  69 66 74 20 46 31 31 2e  20 20 52 65 73 74 6f 72  |ift F11.  Restor|
000031b0  65 20 0a 70 6f 73 69 74  69 6f 6e 20 68 61 73 20  |e .position has |
000031c0  62 65 65 6e 20 61 73 73  69 67 6e 65 64 20 74 6f  |been assigned to|
000031d0  20 66 75 6e 63 74 69 6f  6e 20 6b 65 79 20 43 74  | function key Ct|
000031e0  72 6c 20 46 31 31 2e 20  20 53 77 61 70 20 70 6f  |rl F11.  Swap po|
000031f0  73 69 74 69 6f 6e 20 61  6e 64 20 0a 63 61 72 65  |sition and .care|
00003200  74 20 68 61 73 20 62 65  65 6e 20 61 73 73 69 67  |t has been assig|
00003210  6e 65 64 20 74 6f 20 66  75 6e 63 74 69 6f 6e 20  |ned to function |
00003220  6b 65 79 20 46 31 31 2e  20 20 54 68 69 73 20 65  |key F11.  This e|
00003230  6e 61 62 6c 65 73 20 79  6f 75 20 74 6f 20 73 65  |nables you to se|
00003240  74 20 61 20 0a 70 6f 73  69 74 69 6f 6e 20 77 69  |t a .position wi|
00003250  74 68 20 53 68 69 66 74  20 46 31 31 2c 20 6d 6f  |th Shift F11, mo|
00003260  76 65 20 73 6f 6d 65 77  68 65 72 65 20 65 6c 73  |ve somewhere els|
00003270  65 20 61 6e 64 20 74 6f  67 67 6c 65 20 62 65 74  |e and toggle bet|
00003280  77 65 65 6e 20 74 68 65  20 0a 70 6f 73 69 74 69  |ween the .positi|
00003290  6f 6e 73 20 62 65 20 70  72 65 73 73 69 6e 67 20  |ons be pressing |
000032a0  46 31 31 2e 0a 0a 25 48  32 25 4d 61 63 72 6f 20  |F11...%H2%Macro |
000032b0  72 65 63 6f 72 64 65 72  0a 0a 50 69 70 65 44 72  |recorder..PipeDr|
000032c0  65 61 6d 20 33 20 68 61  73 20 61 20 6d 61 63 72  |eam 3 has a macr|
000032d0  6f 20 72 65 63 6f 72 64  65 72 20 77 68 69 63 68  |o recorder which|
000032e0  20 65 6e 61 62 6c 65 73  20 79 6f 75 20 74 6f 20  | enables you to |
000032f0  62 75 69 6c 64 20 6d 61  63 72 6f 20 66 69 6c 65  |build macro file|
00003300  73 20 0a 76 65 72 79 20  65 61 73 69 6c 79 2e 20  |s .very easily. |
00003310  20 54 68 65 20 70 72 6f  63 65 64 75 72 65 20 69  | The procedure i|
00003320  73 20 76 65 72 79 20 73  69 6d 69 6c 61 72 20 74  |s very similar t|
00003330  6f 20 75 73 69 6e 67 20  74 68 65 20 2a 53 70 6f  |o using the *Spo|
00003340  6f 6c 20 0a 63 6f 6d 6d  61 6e 64 2e 20 20 47 69  |ol .command.  Gi|
00003350  76 69 6e 67 20 74 68 65  20 52 65 63 6f 72 64 20  |ving the Record |
00003360  4d 61 63 72 6f 20 46 69  6c 65 20 70 72 6f 6d 70  |Macro File promp|
00003370  74 73 20 79 6f 75 20 66  6f 72 20 74 68 65 20 6e  |ts you for the n|
00003380  61 6d 65 20 6f 66 20 74  68 65 20 0a 66 69 6c 65  |ame of the .file|
00003390  20 66 6f 72 20 74 68 65  20 6d 61 63 72 6f 73 20  | for the macros |
000033a0  74 6f 20 62 65 20 69 6e  73 65 72 74 65 64 20 69  |to be inserted i|
000033b0  6e 74 6f 2e 20 20 54 68  65 6e 20 61 6c 6c 20 74  |nto.  Then all t|
000033c0  65 78 74 20 74 68 61 74  20 0a 79 6f 75 20 74 79  |ext that .you ty|
000033d0  70 65 20 61 6e 64 20 63  6f 6d 6d 61 6e 64 73 20  |pe and commands |
000033e0  74 68 61 74 20 79 6f 75  20 67 69 76 65 2c 20 62  |that you give, b|
000033f0  75 74 20 6e 6f 74 20 6d  6f 75 73 65 20 6d 6f 76  |ut not mouse mov|
00003400  65 6d 65 6e 74 73 2c 20  61 72 65 20 0a 73 74 6f  |ements, are .sto|
00003410  72 65 64 20 69 6e 20 74  68 65 20 66 69 6c 65 20  |red in the file |
00003420  72 65 61 64 79 20 66 6f  72 20 79 6f 75 20 74 6f  |ready for you to|
00003430  20 75 73 65 20 77 69 74  68 20 74 68 65 20 44 6f  | use with the Do|
00003440  20 4d 61 63 72 6f 20 46  69 6c 65 20 63 6f 6d 6d  | Macro File comm|
00003450  61 6e 64 2e 0a 0a 43 72  65 61 74 69 6e 67 20 6d  |and...Creating m|
00003460  61 63 72 6f 20 66 69 6c  65 73 20 69 6e 20 74 68  |acro files in th|
00003470  69 73 20 77 61 79 20 69  73 20 6d 75 63 68 20 65  |is way is much e|
00003480  61 73 69 65 72 20 74 68  61 6e 20 74 79 70 69 6e  |asier than typin|
00003490  67 20 74 68 65 20 0a 63  6f 6d 6d 61 6e 64 73 20  |g the .commands |
000034a0  69 6e 20 79 6f 75 72 73  65 6c 66 2e 20 20 41 6e  |in yourself.  An|
000034b0  20 61 64 64 69 74 69 6f  6e 61 6c 20 62 65 6e 65  | additional bene|
000034c0  66 69 74 20 69 73 20 74  68 61 74 20 69 74 20 67  |fit is that it g|
000034d0  65 6e 65 72 61 74 65 73  20 66 69 6c 65 73 20 0a  |enerates files .|
000034e0  77 68 69 63 68 20 79 6f  75 20 63 61 6e 20 6c 6f  |which you can lo|
000034f0  61 64 20 69 6e 74 6f 20  50 69 70 65 44 72 65 61  |ad into PipeDrea|
00003500  6d 20 77 69 6e 64 6f 77  73 20 74 6f 20 65 78 61  |m windows to exa|
00003510  6d 69 6e 65 2c 20 61 6e  64 20 65 64 69 74 20 69  |mine, and edit i|
00003520  66 20 79 6f 75 20 0a 77  69 73 68 2e 0a 0a 4f 6e  |f you .wish...On|
00003530  65 20 70 6f 69 6e 74 20  74 6f 20 62 65 61 72 20  |e point to bear |
00003540  69 6e 20 6d 69 6e 64 20  69 66 20 79 6f 75 20 68  |in mind if you h|
00003550  61 76 65 20 6d 61 63 72  6f 20 66 69 6c 65 73 20  |ave macro files |
00003560  74 68 61 74 20 79 6f 75  20 68 61 76 65 20 62 75  |that you have bu|
00003570  69 6c 74 20 0a 66 6f 72  20 75 73 65 20 77 69 74  |ilt .for use wit|
00003580  68 20 50 69 70 65 44 72  65 61 6d 20 32 20 69 73  |h PipeDream 2 is|
00003590  20 74 68 61 74 20 74 68  65 20 66 6f 72 6d 61 74  | that the format|
000035a0  20 68 61 73 20 62 65 65  6e 20 73 69 6d 70 6c 69  | has been simpli|
000035b0  66 69 65 64 20 61 20 0a  6c 69 74 74 6c 65 2e 20  |fied a .little. |
000035c0  20 4e 6f 77 20 6f 6e 6c  79 20 6f 6e 65 20 63 6f  | Now only one co|
000035d0  6d 6d 61 6e 64 20 69 73  20 61 6c 6c 6f 77 65 64  |mmand is allowed|
000035e0  20 6f 6e 20 61 20 6c 69  6e 65 20 69 6e 20 74 68  | on a line in th|
000035f0  65 20 6d 61 63 72 6f 20  66 69 6c 65 20 2d 20 0a  |e macro file - .|
00003600  61 6e 79 20 74 65 78 74  20 61 66 74 65 72 20 74  |any text after t|
00003610  68 65 20 7c 6d 20 69 73  20 74 72 65 61 74 65 64  |he |m is treated|
00003620  20 61 73 20 63 6f 6d 6d  65 6e 74 20 61 6e 64 20  | as comment and |
00003630  69 67 6e 6f 72 65 64 2e  20 20 54 68 69 73 20 65  |ignored.  This e|
00003640  6e 61 62 6c 65 73 20 0a  6d 61 63 72 6f 20 66 69  |nables .macro fi|
00003650  6c 65 73 20 74 6f 20 62  65 20 61 20 6c 6f 74 20  |les to be a lot |
00003660  6d 6f 72 65 20 75 6e 64  65 72 73 74 61 6e 64 61  |more understanda|
00003670  62 6c 65 20 62 75 74 20  69 74 20 6d 65 61 6e 73  |ble but it means|
00003680  20 74 68 61 74 20 61 6e  79 20 0a 65 78 69 73 74  | that any .exist|
00003690  69 6e 67 20 66 69 6c 65  73 20 74 68 61 74 20 79  |ing files that y|
000036a0  6f 75 20 68 61 76 65 20  77 69 6c 6c 20 64 6f 20  |ou have will do |
000036b0  64 69 66 66 65 72 65 6e  74 20 74 68 69 6e 67 73  |different things|
000036c0  20 77 69 74 68 20 50 69  70 65 44 72 65 61 6d 20  | with PipeDream |
000036d0  33 20 0a 61 6e 64 20 50  69 70 65 44 72 65 61 6d  |3 .and PipeDream|
000036e0  20 33 20 66 69 6c 65 73  20 74 68 61 74 20 79 6f  | 3 files that yo|
000036f0  75 20 63 72 65 61 74 65  20 77 69 6c 6c 20 6e 6f  |u create will no|
00003700  74 20 67 65 6e 65 72 61  6c 6c 79 20 77 6f 72 6b  |t generally work|
00003710  20 77 69 74 68 20 0a 50  69 70 65 44 72 65 61 6d  | with .PipeDream|
00003720  20 32 2e 0a 0a 25 48 32  25 53 6c 6f 74 20 50 72  | 2...%H2%Slot Pr|
00003730  6f 74 65 63 74 69 6f 6e  0a 0a 41 72 62 69 74 72  |otection..Arbitr|
00003740  61 72 79 20 62 6c 6f 63  6b 73 20 6f 66 20 73 6c  |ary blocks of sl|
00003750  6f 74 73 20 63 61 6e 20  62 65 20 70 72 6f 74 65  |ots can be prote|
00003760  63 74 65 64 20 69 6e 20  50 69 70 65 44 72 65 61  |cted in PipeDrea|
00003770  6d 20 33 2e 20 20 54 68  65 20 0a 70 72 6f 74 65  |m 3.  The .prote|
00003780  63 74 69 6f 6e 20 70 72  65 76 65 6e 74 73 20 79  |ction prevents y|
00003790  6f 75 20 66 72 6f 6d 20  61 63 63 69 64 65 6e 74  |ou from accident|
000037a0  61 6c 6c 79 20 6f 76 65  72 77 72 69 74 69 6e 67  |ally overwriting|
000037b0  20 6f 72 20 64 65 6c 65  74 69 6e 67 20 74 68 65  | or deleting the|
000037c0  20 0a 73 6c 6f 74 20 63  6f 6e 74 65 6e 74 73 2e  | .slot contents.|
000037d0  20 50 72 6f 74 65 63 74  65 64 20 73 6c 6f 74 73  | Protected slots|
000037e0  20 61 72 65 20 64 69 73  70 6c 61 79 65 64 20 75  | are displayed u|
000037f0  73 69 6e 67 20 61 20 64  69 66 66 65 72 65 6e 74  |sing a different|
00003800  20 0a 62 61 63 6b 67 72  6f 75 6e 64 20 63 6f 6c  | .background col|
00003810  6f 75 72 20 74 68 61 6e  20 6e 6f 72 6d 61 6c 20  |our than normal |
00003820  74 6f 20 6d 61 6b 65 20  74 68 65 6d 20 73 74 61  |to make them sta|
00003830  6e 64 20 6f 75 74 3b 20  74 68 69 73 20 63 6f 6c  |nd out; this col|
00003840  6f 75 72 20 6d 61 79 20  0a 62 65 20 63 68 61 6e  |our may .be chan|
00003850  67 65 64 20 75 73 69 6e  67 20 74 68 65 20 43 6f  |ged using the Co|
00003860  6c 6f 75 72 73 20 64 69  61 6c 6f 67 75 65 20 62  |lours dialogue b|
00003870  6f 78 2e 0a 0a 25 48 32  25 49 74 65 72 61 74 69  |ox...%H2%Iterati|
00003880  6f 6e 0a 0a 52 65 63 61  6c 63 75 6c 61 74 69 6f  |on..Recalculatio|
00003890  6e 20 63 61 6e 20 62 65  20 6d 61 64 65 20 74 6f  |n can be made to|
000038a0  20 69 74 65 72 61 74 65  20 77 68 69 63 68 20 67  | iterate which g|
000038b0  69 76 65 73 20 74 68 65  20 61 62 69 6c 69 74 79  |ives the ability|
000038c0  20 74 6f 20 0a 72 65 63  61 6c 63 75 6c 61 74 65  | to .recalculate|
000038d0  20 61 20 73 65 74 20 6f  66 20 66 6f 72 6d 75 6c  | a set of formul|
000038e0  61 65 20 75 6e 74 69 6c  20 61 20 73 70 65 63 69  |ae until a speci|
000038f0  66 69 65 64 20 72 65 73  75 6c 74 20 68 61 73 20  |fied result has |
00003900  62 65 65 6e 20 0a 61 63  68 69 65 76 65 64 2e 0a  |been .achieved..|
00003910  0a 25 48 32 25 50 69 63  74 75 72 65 73 0a 0a 50  |.%H2%Pictures..P|
00003920  69 70 65 44 72 65 61 6d  20 33 20 63 61 6e 20 64  |ipeDream 3 can d|
00003930  69 73 70 6c 61 79 20 70  69 63 74 75 72 65 73 20  |isplay pictures |
00003940  74 68 61 74 20 68 61 76  65 20 62 65 65 6e 20 63  |that have been c|
00003950  72 65 61 74 65 64 20 62  79 20 44 72 61 77 2c 20  |reated by Draw, |
00003960  50 61 69 6e 74 20 0a 6f  72 20 6f 74 68 65 72 20  |Paint .or other |
00003970  64 72 61 77 69 6e 67 20  61 70 70 6c 69 63 61 74  |drawing applicat|
00003980  69 6f 6e 73 2e 20 20 54  68 65 73 65 20 61 72 65  |ions.  These are|
00003990  20 64 69 73 70 6c 61 79  65 64 20 6f 76 65 72 20  | displayed over |
000039a0  62 6c 61 6e 6b 20 73 6c  6f 74 73 20 6f 6e 20 0a  |blank slots on .|
000039b0  73 63 72 65 65 6e 20 61  6e 64 20 63 61 6e 20 62  |screen and can b|
000039c0  65 20 70 72 69 6e 74 65  64 20 76 69 61 20 74 68  |e printed via th|
000039d0  65 20 52 49 53 43 20 4f  53 20 70 72 69 6e 74 65  |e RISC OS printe|
000039e0  72 20 64 72 69 76 65 72  73 2e 0a 0a 25 48 32 25  |r drivers...%H2%|
000039f0  5a 38 38 20 66 69 6c 69  6e 67 20 73 79 73 74 65  |Z88 filing syste|
00003a00  6d 0a 0a 50 69 70 65 44  72 65 61 6d 20 32 20 68  |m..PipeDream 2 h|
00003a10  61 73 20 74 68 65 20 61  62 69 6c 69 74 79 20 74  |as the ability t|
00003a20  6f 20 6c 6f 61 64 20 61  6e 64 20 73 61 76 65 20  |o load and save |
00003a30  66 69 6c 65 73 20 64 69  72 65 63 74 6c 79 20 74  |files directly t|
00003a40  6f 20 74 68 65 20 5a 38  38 2e 20 20 0a 50 69 70  |o the Z88.  .Pip|
00003a50  65 44 72 65 61 6d 20 33  20 70 72 6f 76 69 64 65  |eDream 3 provide|
00003a60  73 20 61 20 5a 38 38 20  66 69 6c 69 6e 67 20 73  |s a Z88 filing s|
00003a70  79 73 74 65 6d 20 77 68  69 63 68 20 6d 61 6b 65  |ystem which make|
00003a80  73 20 74 68 65 20 70 72  6f 63 65 73 73 20 72 61  |s the process ra|
00003a90  74 68 65 72 20 0a 6d 6f  72 65 20 67 65 6e 65 72  |ther .more gener|
00003aa0  61 6c 20 61 6e 64 20 66  69 74 73 20 69 6e 20 62  |al and fits in b|
00003ab0  65 74 74 65 72 20 77 69  74 68 20 74 68 65 20 52  |etter with the R|
00003ac0  49 53 43 20 4f 53 20 70  68 69 6c 6f 73 6f 70 68  |ISC OS philosoph|
00003ad0  79 2e 20 20 54 68 65 20  5a 38 38 20 0a 46 69 6c  |y.  The Z88 .Fil|
00003ae0  65 72 20 69 63 6f 6e 20  73 69 74 73 20 6f 6e 20  |er icon sits on |
00003af0  74 68 65 20 69 63 6f 6e  20 62 61 72 20 77 69 74  |the icon bar wit|
00003b00  68 20 74 68 65 20 6f 74  68 65 72 20 66 69 6c 69  |h the other fili|
00003b10  6e 67 20 73 79 73 74 65  6d 20 69 63 6f 6e 73 20  |ng system icons |
00003b20  61 6e 64 20 0a 70 72 6f  76 69 64 65 73 20 61 20  |and .provides a |
00003b30  64 65 76 69 63 65 20 76  69 65 77 65 72 20 61 6e  |device viewer an|
00003b40  64 20 64 69 72 65 63 74  6f 72 79 20 76 69 65 77  |d directory view|
00003b50  65 72 73 20 69 6e 20 61  20 73 69 6d 69 6c 61 72  |ers in a similar|
00003b60  20 77 61 79 20 74 6f 20  74 68 65 20 0a 64 72 69  | way to the .dri|
00003b70  76 65 20 69 63 6f 6e 73  2e 20 20 46 69 6c 65 73  |ve icons.  Files|
00003b80  20 63 61 6e 20 62 65 20  64 72 61 67 67 65 64 20  | can be dragged |
00003b90  66 72 6f 6d 20 64 69 72  65 63 74 6f 72 69 65 73  |from directories|
00003ba0  20 69 6e 20 74 68 65 20  5a 38 38 20 73 74 72 61  | in the Z88 stra|
00003bb0  69 67 68 74 20 0a 69 6e  74 6f 20 50 69 70 65 44  |ight .into PipeD|
00003bc0  72 65 61 6d 20 61 6e 64  20 63 61 6e 20 62 65 20  |ream and can be |
00003bd0  73 61 76 65 64 20 62 61  63 6b 20 61 67 61 69 6e  |saved back again|
00003be0  20 69 6e 20 61 20 73 69  6d 69 6c 61 72 20 77 61  | in a similar wa|
00003bf0  79 2e 20 20 46 69 6c 65  73 20 63 61 6e 20 0a 61  |y.  Files can .a|
00003c00  6c 73 6f 20 62 65 20 73  61 76 65 64 20 74 6f 20  |lso be saved to |
00003c10  74 68 65 20 5a 38 38 20  62 79 20 64 72 61 67 67  |the Z88 by dragg|
00003c20  69 6e 67 20 74 68 65 6d  20 66 72 6f 6d 20 6f 74  |ing them from ot|
00003c30  68 65 72 20 61 70 70 6c  69 63 61 74 69 6f 6e 73  |her applications|
00003c40  2e 0a 0a 4e 6f 74 65 20  74 68 61 74 20 74 68 65  |...Note that the|
00003c50  20 41 33 30 30 30 20 64  6f 65 73 20 6e 6f 74 20  | A3000 does not |
00003c60  63 6f 6d 65 20 77 69 74  68 20 61 20 63 6f 6d 70  |come with a comp|
00003c70  6c 65 74 65 20 73 65 72  69 61 6c 20 70 6f 72 74  |lete serial port|
00003c80  20 61 6e 64 20 6e 65 65  64 73 20 0a 74 6f 20 68  | and needs .to h|
00003c90  61 76 65 20 61 20 73 69  6d 70 6c 65 20 75 70 67  |ave a simple upg|
00003ca0  72 61 64 65 20 62 65 66  6f 72 65 20 79 6f 75 20  |rade before you |
00003cb0  77 69 6c 6c 20 62 65 20  61 62 6c 65 20 74 6f 20  |will be able to |
00003cc0  70 6c 75 67 20 69 6e 20  74 68 65 20 5a 38 38 20  |plug in the Z88 |
00003cd0  6f 72 20 0a 61 20 73 65  72 69 61 6c 20 70 72 69  |or .a serial pri|
00003ce0  6e 74 65 72 2e 20 20 54  68 69 73 20 75 70 67 72  |nter.  This upgr|
00003cf0  61 64 65 20 73 68 6f 75  6c 64 20 62 65 20 61 76  |ade should be av|
00003d00  61 69 6c 61 62 6c 65 20  66 72 6f 6d 20 79 6f 75  |ailable from you|
00003d10  72 20 64 65 61 6c 65 72  2e 0a 0a 25 48 32 25 48  |r dealer...%H2%H|
00003d20  65 6c 70 0a 0a 50 69 70  65 44 72 65 61 6d 20 73  |elp..PipeDream s|
00003d30  75 70 70 6f 72 74 73 20  74 68 65 20 52 49 53 43  |upports the RISC|
00003d40  20 4f 53 20 68 65 6c 70  20 73 79 73 74 65 6d 20  | OS help system |
00003d50  61 6e 64 20 70 72 6f 76  69 64 65 73 20 75 73 65  |and provides use|
00003d60  66 75 6c 20 63 6f 6e 74  65 78 74 20 0a 73 65 6e  |ful context .sen|
00003d70  73 69 74 69 76 65 20 68  65 6c 70 2c 20 6d 61 69  |sitive help, mai|
00003d80  6e 6c 79 20 6f 66 20 6d  6f 75 73 65 20 6f 70 65  |nly of mouse ope|
00003d90  72 61 74 69 6f 6e 73 20  69 6e 20 64 69 66 66 65  |rations in diffe|
00003da0  72 65 6e 74 20 61 72 65  61 73 20 6f 66 20 74 68  |rent areas of th|
00003db0  65 20 0a 77 69 6e 64 6f  77 2e 20 20 41 20 75 73  |e .window.  A us|
00003dc0  65 66 75 6c 20 73 75 6d  6d 61 72 79 20 6f 66 20  |eful summary of |
00003dd0  6d 6f 75 73 65 20 6f 70  65 72 61 74 69 6f 6e 73  |mouse operations|
00003de0  20 69 73 20 67 69 76 65  6e 20 61 74 20 74 68 65  | is given at the|
00003df0  20 65 6e 64 20 6f 66 20  0a 53 65 63 74 69 6f 6e  | end of .Section|
00003e00  20 33 2c 20 43 68 61 70  74 65 72 20 31 2e 0a 0a  | 3, Chapter 1...|
00003e10  25 48 32 25 46 6f 6e 74  73 0a 0a 50 69 70 65 44  |%H2%Fonts..PipeD|
00003e20  72 65 61 6d 20 33 20 63  61 6e 20 75 73 65 20 61  |ream 3 can use a|
00003e30  6c 6c 20 6f 66 20 74 68  65 20 66 6f 6e 74 73 20  |ll of the fonts |
00003e40  70 72 6f 76 69 64 65 64  20 77 69 74 68 20 52 49  |provided with RI|
00003e50  53 43 20 4f 53 2e 20 20  4e 65 77 20 0a 66 61 63  |SC OS.  New .fac|
00003e60  69 6c 69 74 69 65 73 20  61 72 65 20 70 72 6f 76  |ilities are prov|
00003e70  69 64 65 64 20 74 6f 20  73 65 74 20 74 68 65 20  |ided to set the |
00003e80  67 6c 6f 62 61 6c 20 66  6f 6e 74 20 66 6f 72 20  |global font for |
00003e90  61 20 64 6f 63 75 6d 65  6e 74 2c 20 74 6f 20 0a  |a document, to .|
00003ea0  69 6e 73 65 72 74 20 66  6f 6e 74 20 63 68 61 6e  |insert font chan|
00003eb0  67 65 73 20 77 69 74 68  69 6e 20 64 6f 63 75 6d  |ges within docum|
00003ec0  65 6e 74 73 20 61 6e 64  20 74 6f 20 73 70 65 63  |ents and to spec|
00003ed0  69 66 79 20 66 6f 6e 74  20 73 69 7a 65 73 2e 20  |ify font sizes. |
00003ee0  20 46 6f 6e 74 73 20 0a  61 72 65 20 70 72 69 6e  | Fonts .are prin|
00003ef0  74 65 64 20 75 73 69 6e  67 20 74 68 65 20 52 49  |ted using the RI|
00003f00  53 43 20 4f 53 20 70 72  69 6e 74 65 72 20 64 72  |SC OS printer dr|
00003f10  69 76 65 72 73 20 61 6e  64 20 63 61 6e 6e 6f 74  |ivers and cannot|
00003f20  20 62 65 20 70 72 69 6e  74 65 64 20 0a 75 73 69  | be printed .usi|
00003f30  6e 67 20 74 68 65 20 50  69 70 65 44 72 65 61 6d  |ng the PipeDream|
00003f40  20 70 72 69 6e 74 65 72  20 64 72 69 76 65 72 73  | printer drivers|
00003f50  2e 0a                                             |..|
00003f52