Home » Archimedes archive » Apps » PipeDream 4 (1991) (Colton Software) (Examples Disc).adf » PD3_users/PD3_4

PD3_users/PD3_4

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 4 (1991) (Colton Software) (Examples Disc).adf
Filename: PD3_users/PD3_4
Read OK:
File size: 13D8 bytes
Load address: FFFDDE43
Exec address: 6DF906A6
Duplicates

There is 1 duplicate copy of this file in the archive:

File contents
%OP%PL0
%OP%BM0
%OP%LM5
%OP%FX
%OP%FY
%OP%FS
%OP%WC2,1238,162,980,0,0,0,0
%OP%VS3.40R (11-Oct-90), Mrjc, R9200 7500 3900 8299 
%CO:A,18,73%
%C%Major enhancements in PipeDream 4

PipeDream 4 is a fundamental revision of PipeDream 3 with changes in 
almost all areas.   Whilst the most striking areas of improvement are 
its stunning charts, the new spreadsheet power and the upgraded user 
interface, there are many detailed enhancements which are too numerous 
to mention here.  We would like to thank all PipeDream 3 users who 
contributed their ideas in our user surveys and other correspondence.  

Some of the more important new features are:

Charts








Spreadsheet



















Format block


Repeat command


Templates


Headers, footers

Transpose


Print in columns


Linked columns


@@N@@, @@L@@



%H2%User interface

Graphic borders


Auto-width



Line height


New mouse






Menus




Function keys






%H2%Other

Copy/move/delete









Paste


Window position




User Guide
%CO:B,12,54%











Seeing is believing!  PipeDream 4 introduces Penguin 
Graphics to the Archimedes in addition to the more 
usual Pie, Bar, Line and scatter charts.  All charts 
are completely dynamic and very fast.  You can 
include overlays with multiple scales.  Highly 
flexible chart editing for fine tuning, including 
adding and deleting data from chart.  One reaction 
was: "PipeDream 4's graphs blow your socks off."

PipeDream 4 is, by a wide margin, the finest 
spreadsheet package on the Archimedes.  In addition 
to 162 built-in functions (including full string, 
date, matrix and complex number functions), PipeDream 
4 provides custom functions for you to program your 
own function libraries, and arrays.  Arrays are 
groups of data within a slot enabling you to perform 
powerful operations very easily. (These are not to be 
confused with Schema's "arrays" which are merely 
ranges.)  PipeDream 4 continues the PipeDream 
tradition by being the fastest ever RISC OS 
spreadsheet whilst providing an even higher level of 
background recalculation.

Other new goodies are names to help define quantities 
like VAT, an optional formula window (which pops up 
only when you ask for it), and function and name 
pasting from the function menu, to reduce the need to 
look in the reference book.

Reformat a marked block.  Useful when changing fonts 
or margin settings.

Repeats the last command.  Gives quick keyboard 
operation for any command.

You can specify template files to help the creation 
of new documents. 

Headers and footers can be up to three lines long.

Swaps the rows and columns of a marked block across 
the leading diagonal.

Prints wide spreadsheets and databases one page width 
at a time.

Link the margins of several columns to give greater 
control when word processing.

@@N@@ gives the current time in 24 hour clock format, 
@@L@@ gives the leafname of the current document, for 
easy reference.



Column borders and margins can be dragged using the 
mouse for quick refitting of columns.

Tell PipeDream to Auto width for even quicker 
refitting of columns.  You'll wonder how you ever got 
by without this one.

The document now appears in the window in the line 
height to be used when printing.  Very nice.

Mouse operations have been simplified and brought 
closer to other RISC OS applications.  Always use the 
left button to click in slots and mark blocks.  
Always use the right button to adjust marked blocks.  
New Mark Block Box for instantaneous setting and 
clearing of blocks. 

Short menus are now configurable so you specify only 
those and all those commands you want.  Or you can 
set PipeDream up for someone else to use. 
Particularly useful in  a learning environment.

The function key layout is much simpler than before 
and F3 and F4 are now set to Save and Search.  For 
those whose fingers can't be retrained, a command 
file is provided to configure PipeDream 4 to the 
PipeDream 3 layout.  But learn the new one; it's much 
better.  Really!



These block operations have been reworked and are 
both more powerful and safe.  No more column sliding 
and you can safely move blocks left and right.  Copy 
and move overwrite the target area if it is blank.  
If not, they insert blank slots over the %H2%whole%H2% row 
and then overwrite.  Move and delete clear the block 
and only delete the slots if all slots to the left 
and right are blank, in which case it deletes the 
whole row.  Try it; you'll like it.

This isn't new but it's amazing how many people don't 
know about it.

The position of the caret in the window and the 
position of the window on the screen are remembered 
so you restart exactly where you left off.  This 
saves a lot of time.

The User Guide is no more.  In its place are the 
PipeDream 4 tutorial for new users and the PipeDream 
4 Reference Guide with its unique cross-referencing 
structure for advanced users.  The PipeDream 3 
documentation was highly praised; we believe this 
documentation is seriously better.
%CO:C,20,48%%CO:D,12,36%%CO:E,12,24%%CO:F,12,12%
00000000  25 4f 50 25 50 4c 30 0a  25 4f 50 25 42 4d 30 0a  |%OP%PL0.%OP%BM0.|
00000010  25 4f 50 25 4c 4d 35 0a  25 4f 50 25 46 58 0a 25  |%OP%LM5.%OP%FX.%|
00000020  4f 50 25 46 59 0a 25 4f  50 25 46 53 0a 25 4f 50  |OP%FY.%OP%FS.%OP|
00000030  25 57 43 32 2c 31 32 33  38 2c 31 36 32 2c 39 38  |%WC2,1238,162,98|
00000040  30 2c 30 2c 30 2c 30 2c  30 0a 25 4f 50 25 56 53  |0,0,0,0,0.%OP%VS|
00000050  33 2e 34 30 52 20 28 31  31 2d 4f 63 74 2d 39 30  |3.40R (11-Oct-90|
00000060  29 2c 20 4d 72 6a 63 2c  20 52 39 32 30 30 20 37  |), Mrjc, R9200 7|
00000070  35 30 30 20 33 39 30 30  20 38 32 39 39 20 0a 25  |500 3900 8299 .%|
00000080  43 4f 3a 41 2c 31 38 2c  37 33 25 0a 25 43 25 4d  |CO:A,18,73%.%C%M|
00000090  61 6a 6f 72 20 65 6e 68  61 6e 63 65 6d 65 6e 74  |ajor enhancement|
000000a0  73 20 69 6e 20 50 69 70  65 44 72 65 61 6d 20 34  |s in PipeDream 4|
000000b0  0a 0a 50 69 70 65 44 72  65 61 6d 20 34 20 69 73  |..PipeDream 4 is|
000000c0  20 61 20 66 75 6e 64 61  6d 65 6e 74 61 6c 20 72  | a fundamental r|
000000d0  65 76 69 73 69 6f 6e 20  6f 66 20 50 69 70 65 44  |evision of PipeD|
000000e0  72 65 61 6d 20 33 20 77  69 74 68 20 63 68 61 6e  |ream 3 with chan|
000000f0  67 65 73 20 69 6e 20 0a  61 6c 6d 6f 73 74 20 61  |ges in .almost a|
00000100  6c 6c 20 61 72 65 61 73  2e 20 20 20 57 68 69 6c  |ll areas.   Whil|
00000110  73 74 20 74 68 65 20 6d  6f 73 74 20 73 74 72 69  |st the most stri|
00000120  6b 69 6e 67 20 61 72 65  61 73 20 6f 66 20 69 6d  |king areas of im|
00000130  70 72 6f 76 65 6d 65 6e  74 20 61 72 65 20 0a 69  |provement are .i|
00000140  74 73 20 73 74 75 6e 6e  69 6e 67 20 63 68 61 72  |ts stunning char|
00000150  74 73 2c 20 74 68 65 20  6e 65 77 20 73 70 72 65  |ts, the new spre|
00000160  61 64 73 68 65 65 74 20  70 6f 77 65 72 20 61 6e  |adsheet power an|
00000170  64 20 74 68 65 20 75 70  67 72 61 64 65 64 20 75  |d the upgraded u|
00000180  73 65 72 20 0a 69 6e 74  65 72 66 61 63 65 2c 20  |ser .interface, |
00000190  74 68 65 72 65 20 61 72  65 20 6d 61 6e 79 20 64  |there are many d|
000001a0  65 74 61 69 6c 65 64 20  65 6e 68 61 6e 63 65 6d  |etailed enhancem|
000001b0  65 6e 74 73 20 77 68 69  63 68 20 61 72 65 20 74  |ents which are t|
000001c0  6f 6f 20 6e 75 6d 65 72  6f 75 73 20 0a 74 6f 20  |oo numerous .to |
000001d0  6d 65 6e 74 69 6f 6e 20  68 65 72 65 2e 20 20 57  |mention here.  W|
000001e0  65 20 77 6f 75 6c 64 20  6c 69 6b 65 20 74 6f 20  |e would like to |
000001f0  74 68 61 6e 6b 20 61 6c  6c 20 50 69 70 65 44 72  |thank all PipeDr|
00000200  65 61 6d 20 33 20 75 73  65 72 73 20 77 68 6f 20  |eam 3 users who |
00000210  0a 63 6f 6e 74 72 69 62  75 74 65 64 20 74 68 65  |.contributed the|
00000220  69 72 20 69 64 65 61 73  20 69 6e 20 6f 75 72 20  |ir ideas in our |
00000230  75 73 65 72 20 73 75 72  76 65 79 73 20 61 6e 64  |user surveys and|
00000240  20 6f 74 68 65 72 20 63  6f 72 72 65 73 70 6f 6e  | other correspon|
00000250  64 65 6e 63 65 2e 20 20  0a 0a 53 6f 6d 65 20 6f  |dence.  ..Some o|
00000260  66 20 74 68 65 20 6d 6f  72 65 20 69 6d 70 6f 72  |f the more impor|
00000270  74 61 6e 74 20 6e 65 77  20 66 65 61 74 75 72 65  |tant new feature|
00000280  73 20 61 72 65 3a 0a 0a  43 68 61 72 74 73 0a 0a  |s are:..Charts..|
00000290  0a 0a 0a 0a 0a 0a 0a 53  70 72 65 61 64 73 68 65  |.......Spreadshe|
000002a0  65 74 0a 0a 0a 0a 0a 0a  0a 0a 0a 0a 0a 0a 0a 0a  |et..............|
000002b0  0a 0a 0a 0a 0a 0a 46 6f  72 6d 61 74 20 62 6c 6f  |......Format blo|
000002c0  63 6b 0a 0a 0a 52 65 70  65 61 74 20 63 6f 6d 6d  |ck...Repeat comm|
000002d0  61 6e 64 0a 0a 0a 54 65  6d 70 6c 61 74 65 73 0a  |and...Templates.|
000002e0  0a 0a 48 65 61 64 65 72  73 2c 20 66 6f 6f 74 65  |..Headers, foote|
000002f0  72 73 0a 0a 54 72 61 6e  73 70 6f 73 65 0a 0a 0a  |rs..Transpose...|
00000300  50 72 69 6e 74 20 69 6e  20 63 6f 6c 75 6d 6e 73  |Print in columns|
00000310  0a 0a 0a 4c 69 6e 6b 65  64 20 63 6f 6c 75 6d 6e  |...Linked column|
00000320  73 0a 0a 0a 40 40 4e 40  40 2c 20 40 40 4c 40 40  |s...@@N@@, @@L@@|
00000330  0a 0a 0a 0a 25 48 32 25  55 73 65 72 20 69 6e 74  |....%H2%User int|
00000340  65 72 66 61 63 65 0a 0a  47 72 61 70 68 69 63 20  |erface..Graphic |
00000350  62 6f 72 64 65 72 73 0a  0a 0a 41 75 74 6f 2d 77  |borders...Auto-w|
00000360  69 64 74 68 0a 0a 0a 0a  4c 69 6e 65 20 68 65 69  |idth....Line hei|
00000370  67 68 74 0a 0a 0a 4e 65  77 20 6d 6f 75 73 65 0a  |ght...New mouse.|
00000380  0a 0a 0a 0a 0a 0a 4d 65  6e 75 73 0a 0a 0a 0a 0a  |......Menus.....|
00000390  46 75 6e 63 74 69 6f 6e  20 6b 65 79 73 0a 0a 0a  |Function keys...|
000003a0  0a 0a 0a 0a 25 48 32 25  4f 74 68 65 72 0a 0a 43  |....%H2%Other..C|
000003b0  6f 70 79 2f 6d 6f 76 65  2f 64 65 6c 65 74 65 0a  |opy/move/delete.|
000003c0  0a 0a 0a 0a 0a 0a 0a 0a  0a 50 61 73 74 65 0a 0a  |.........Paste..|
000003d0  0a 57 69 6e 64 6f 77 20  70 6f 73 69 74 69 6f 6e  |.Window position|
000003e0  0a 0a 0a 0a 0a 55 73 65  72 20 47 75 69 64 65 0a  |.....User Guide.|
000003f0  25 43 4f 3a 42 2c 31 32  2c 35 34 25 0a 0a 0a 0a  |%CO:B,12,54%....|
00000400  0a 0a 0a 0a 0a 0a 0a 0a  53 65 65 69 6e 67 20 69  |........Seeing i|
00000410  73 20 62 65 6c 69 65 76  69 6e 67 21 20 20 50 69  |s believing!  Pi|
00000420  70 65 44 72 65 61 6d 20  34 20 69 6e 74 72 6f 64  |peDream 4 introd|
00000430  75 63 65 73 20 50 65 6e  67 75 69 6e 20 0a 47 72  |uces Penguin .Gr|
00000440  61 70 68 69 63 73 20 74  6f 20 74 68 65 20 41 72  |aphics to the Ar|
00000450  63 68 69 6d 65 64 65 73  20 69 6e 20 61 64 64 69  |chimedes in addi|
00000460  74 69 6f 6e 20 74 6f 20  74 68 65 20 6d 6f 72 65  |tion to the more|
00000470  20 0a 75 73 75 61 6c 20  50 69 65 2c 20 42 61 72  | .usual Pie, Bar|
00000480  2c 20 4c 69 6e 65 20 61  6e 64 20 73 63 61 74 74  |, Line and scatt|
00000490  65 72 20 63 68 61 72 74  73 2e 20 20 41 6c 6c 20  |er charts.  All |
000004a0  63 68 61 72 74 73 20 0a  61 72 65 20 63 6f 6d 70  |charts .are comp|
000004b0  6c 65 74 65 6c 79 20 64  79 6e 61 6d 69 63 20 61  |letely dynamic a|
000004c0  6e 64 20 76 65 72 79 20  66 61 73 74 2e 20 20 59  |nd very fast.  Y|
000004d0  6f 75 20 63 61 6e 20 0a  69 6e 63 6c 75 64 65 20  |ou can .include |
000004e0  6f 76 65 72 6c 61 79 73  20 77 69 74 68 20 6d 75  |overlays with mu|
000004f0  6c 74 69 70 6c 65 20 73  63 61 6c 65 73 2e 20 20  |ltiple scales.  |
00000500  48 69 67 68 6c 79 20 0a  66 6c 65 78 69 62 6c 65  |Highly .flexible|
00000510  20 63 68 61 72 74 20 65  64 69 74 69 6e 67 20 66  | chart editing f|
00000520  6f 72 20 66 69 6e 65 20  74 75 6e 69 6e 67 2c 20  |or fine tuning, |
00000530  69 6e 63 6c 75 64 69 6e  67 20 0a 61 64 64 69 6e  |including .addin|
00000540  67 20 61 6e 64 20 64 65  6c 65 74 69 6e 67 20 64  |g and deleting d|
00000550  61 74 61 20 66 72 6f 6d  20 63 68 61 72 74 2e 20  |ata from chart. |
00000560  20 4f 6e 65 20 72 65 61  63 74 69 6f 6e 20 0a 77  | One reaction .w|
00000570  61 73 3a 20 22 50 69 70  65 44 72 65 61 6d 20 34  |as: "PipeDream 4|
00000580  27 73 20 67 72 61 70 68  73 20 62 6c 6f 77 20 79  |'s graphs blow y|
00000590  6f 75 72 20 73 6f 63 6b  73 20 6f 66 66 2e 22 0a  |our socks off.".|
000005a0  0a 50 69 70 65 44 72 65  61 6d 20 34 20 69 73 2c  |.PipeDream 4 is,|
000005b0  20 62 79 20 61 20 77 69  64 65 20 6d 61 72 67 69  | by a wide margi|
000005c0  6e 2c 20 74 68 65 20 66  69 6e 65 73 74 20 0a 73  |n, the finest .s|
000005d0  70 72 65 61 64 73 68 65  65 74 20 70 61 63 6b 61  |preadsheet packa|
000005e0  67 65 20 6f 6e 20 74 68  65 20 41 72 63 68 69 6d  |ge on the Archim|
000005f0  65 64 65 73 2e 20 20 49  6e 20 61 64 64 69 74 69  |edes.  In additi|
00000600  6f 6e 20 0a 74 6f 20 31  36 32 20 62 75 69 6c 74  |on .to 162 built|
00000610  2d 69 6e 20 66 75 6e 63  74 69 6f 6e 73 20 28 69  |-in functions (i|
00000620  6e 63 6c 75 64 69 6e 67  20 66 75 6c 6c 20 73 74  |ncluding full st|
00000630  72 69 6e 67 2c 20 0a 64  61 74 65 2c 20 6d 61 74  |ring, .date, mat|
00000640  72 69 78 20 61 6e 64 20  63 6f 6d 70 6c 65 78 20  |rix and complex |
00000650  6e 75 6d 62 65 72 20 66  75 6e 63 74 69 6f 6e 73  |number functions|
00000660  29 2c 20 50 69 70 65 44  72 65 61 6d 20 0a 34 20  |), PipeDream .4 |
00000670  70 72 6f 76 69 64 65 73  20 63 75 73 74 6f 6d 20  |provides custom |
00000680  66 75 6e 63 74 69 6f 6e  73 20 66 6f 72 20 79 6f  |functions for yo|
00000690  75 20 74 6f 20 70 72 6f  67 72 61 6d 20 79 6f 75  |u to program you|
000006a0  72 20 0a 6f 77 6e 20 66  75 6e 63 74 69 6f 6e 20  |r .own function |
000006b0  6c 69 62 72 61 72 69 65  73 2c 20 61 6e 64 20 61  |libraries, and a|
000006c0  72 72 61 79 73 2e 20 20  41 72 72 61 79 73 20 61  |rrays.  Arrays a|
000006d0  72 65 20 0a 67 72 6f 75  70 73 20 6f 66 20 64 61  |re .groups of da|
000006e0  74 61 20 77 69 74 68 69  6e 20 61 20 73 6c 6f 74  |ta within a slot|
000006f0  20 65 6e 61 62 6c 69 6e  67 20 79 6f 75 20 74 6f  | enabling you to|
00000700  20 70 65 72 66 6f 72 6d  20 0a 70 6f 77 65 72 66  | perform .powerf|
00000710  75 6c 20 6f 70 65 72 61  74 69 6f 6e 73 20 76 65  |ul operations ve|
00000720  72 79 20 65 61 73 69 6c  79 2e 20 28 54 68 65 73  |ry easily. (Thes|
00000730  65 20 61 72 65 20 6e 6f  74 20 74 6f 20 62 65 20  |e are not to be |
00000740  0a 63 6f 6e 66 75 73 65  64 20 77 69 74 68 20 53  |.confused with S|
00000750  63 68 65 6d 61 27 73 20  22 61 72 72 61 79 73 22  |chema's "arrays"|
00000760  20 77 68 69 63 68 20 61  72 65 20 6d 65 72 65 6c  | which are merel|
00000770  79 20 0a 72 61 6e 67 65  73 2e 29 20 20 50 69 70  |y .ranges.)  Pip|
00000780  65 44 72 65 61 6d 20 34  20 63 6f 6e 74 69 6e 75  |eDream 4 continu|
00000790  65 73 20 74 68 65 20 50  69 70 65 44 72 65 61 6d  |es the PipeDream|
000007a0  20 0a 74 72 61 64 69 74  69 6f 6e 20 62 79 20 62  | .tradition by b|
000007b0  65 69 6e 67 20 74 68 65  20 66 61 73 74 65 73 74  |eing the fastest|
000007c0  20 65 76 65 72 20 52 49  53 43 20 4f 53 20 0a 73  | ever RISC OS .s|
000007d0  70 72 65 61 64 73 68 65  65 74 20 77 68 69 6c 73  |preadsheet whils|
000007e0  74 20 70 72 6f 76 69 64  69 6e 67 20 61 6e 20 65  |t providing an e|
000007f0  76 65 6e 20 68 69 67 68  65 72 20 6c 65 76 65 6c  |ven higher level|
00000800  20 6f 66 20 0a 62 61 63  6b 67 72 6f 75 6e 64 20  | of .background |
00000810  72 65 63 61 6c 63 75 6c  61 74 69 6f 6e 2e 0a 0a  |recalculation...|
00000820  4f 74 68 65 72 20 6e 65  77 20 67 6f 6f 64 69 65  |Other new goodie|
00000830  73 20 61 72 65 20 6e 61  6d 65 73 20 74 6f 20 68  |s are names to h|
00000840  65 6c 70 20 64 65 66 69  6e 65 20 71 75 61 6e 74  |elp define quant|
00000850  69 74 69 65 73 20 0a 6c  69 6b 65 20 56 41 54 2c  |ities .like VAT,|
00000860  20 61 6e 20 6f 70 74 69  6f 6e 61 6c 20 66 6f 72  | an optional for|
00000870  6d 75 6c 61 20 77 69 6e  64 6f 77 20 28 77 68 69  |mula window (whi|
00000880  63 68 20 70 6f 70 73 20  75 70 20 0a 6f 6e 6c 79  |ch pops up .only|
00000890  20 77 68 65 6e 20 79 6f  75 20 61 73 6b 20 66 6f  | when you ask fo|
000008a0  72 20 69 74 29 2c 20 61  6e 64 20 66 75 6e 63 74  |r it), and funct|
000008b0  69 6f 6e 20 61 6e 64 20  6e 61 6d 65 20 0a 70 61  |ion and name .pa|
000008c0  73 74 69 6e 67 20 66 72  6f 6d 20 74 68 65 20 66  |sting from the f|
000008d0  75 6e 63 74 69 6f 6e 20  6d 65 6e 75 2c 20 74 6f  |unction menu, to|
000008e0  20 72 65 64 75 63 65 20  74 68 65 20 6e 65 65 64  | reduce the need|
000008f0  20 74 6f 20 0a 6c 6f 6f  6b 20 69 6e 20 74 68 65  | to .look in the|
00000900  20 72 65 66 65 72 65 6e  63 65 20 62 6f 6f 6b 2e  | reference book.|
00000910  0a 0a 52 65 66 6f 72 6d  61 74 20 61 20 6d 61 72  |..Reformat a mar|
00000920  6b 65 64 20 62 6c 6f 63  6b 2e 20 20 55 73 65 66  |ked block.  Usef|
00000930  75 6c 20 77 68 65 6e 20  63 68 61 6e 67 69 6e 67  |ul when changing|
00000940  20 66 6f 6e 74 73 20 0a  6f 72 20 6d 61 72 67 69  | fonts .or margi|
00000950  6e 20 73 65 74 74 69 6e  67 73 2e 0a 0a 52 65 70  |n settings...Rep|
00000960  65 61 74 73 20 74 68 65  20 6c 61 73 74 20 63 6f  |eats the last co|
00000970  6d 6d 61 6e 64 2e 20 20  47 69 76 65 73 20 71 75  |mmand.  Gives qu|
00000980  69 63 6b 20 6b 65 79 62  6f 61 72 64 20 0a 6f 70  |ick keyboard .op|
00000990  65 72 61 74 69 6f 6e 20  66 6f 72 20 61 6e 79 20  |eration for any |
000009a0  63 6f 6d 6d 61 6e 64 2e  0a 0a 59 6f 75 20 63 61  |command...You ca|
000009b0  6e 20 73 70 65 63 69 66  79 20 74 65 6d 70 6c 61  |n specify templa|
000009c0  74 65 20 66 69 6c 65 73  20 74 6f 20 68 65 6c 70  |te files to help|
000009d0  20 74 68 65 20 63 72 65  61 74 69 6f 6e 20 0a 6f  | the creation .o|
000009e0  66 20 6e 65 77 20 64 6f  63 75 6d 65 6e 74 73 2e  |f new documents.|
000009f0  20 0a 0a 48 65 61 64 65  72 73 20 61 6e 64 20 66  | ..Headers and f|
00000a00  6f 6f 74 65 72 73 20 63  61 6e 20 62 65 20 75 70  |ooters can be up|
00000a10  20 74 6f 20 74 68 72 65  65 20 6c 69 6e 65 73 20  | to three lines |
00000a20  6c 6f 6e 67 2e 0a 0a 53  77 61 70 73 20 74 68 65  |long...Swaps the|
00000a30  20 72 6f 77 73 20 61 6e  64 20 63 6f 6c 75 6d 6e  | rows and column|
00000a40  73 20 6f 66 20 61 20 6d  61 72 6b 65 64 20 62 6c  |s of a marked bl|
00000a50  6f 63 6b 20 61 63 72 6f  73 73 20 0a 74 68 65 20  |ock across .the |
00000a60  6c 65 61 64 69 6e 67 20  64 69 61 67 6f 6e 61 6c  |leading diagonal|
00000a70  2e 0a 0a 50 72 69 6e 74  73 20 77 69 64 65 20 73  |...Prints wide s|
00000a80  70 72 65 61 64 73 68 65  65 74 73 20 61 6e 64 20  |preadsheets and |
00000a90  64 61 74 61 62 61 73 65  73 20 6f 6e 65 20 70 61  |databases one pa|
00000aa0  67 65 20 77 69 64 74 68  20 0a 61 74 20 61 20 74  |ge width .at a t|
00000ab0  69 6d 65 2e 0a 0a 4c 69  6e 6b 20 74 68 65 20 6d  |ime...Link the m|
00000ac0  61 72 67 69 6e 73 20 6f  66 20 73 65 76 65 72 61  |argins of severa|
00000ad0  6c 20 63 6f 6c 75 6d 6e  73 20 74 6f 20 67 69 76  |l columns to giv|
00000ae0  65 20 67 72 65 61 74 65  72 20 0a 63 6f 6e 74 72  |e greater .contr|
00000af0  6f 6c 20 77 68 65 6e 20  77 6f 72 64 20 70 72 6f  |ol when word pro|
00000b00  63 65 73 73 69 6e 67 2e  0a 0a 40 40 4e 40 40 20  |cessing...@@N@@ |
00000b10  67 69 76 65 73 20 74 68  65 20 63 75 72 72 65 6e  |gives the curren|
00000b20  74 20 74 69 6d 65 20 69  6e 20 32 34 20 68 6f 75  |t time in 24 hou|
00000b30  72 20 63 6c 6f 63 6b 20  66 6f 72 6d 61 74 2c 20  |r clock format, |
00000b40  0a 40 40 4c 40 40 20 67  69 76 65 73 20 74 68 65  |.@@L@@ gives the|
00000b50  20 6c 65 61 66 6e 61 6d  65 20 6f 66 20 74 68 65  | leafname of the|
00000b60  20 63 75 72 72 65 6e 74  20 64 6f 63 75 6d 65 6e  | current documen|
00000b70  74 2c 20 66 6f 72 20 0a  65 61 73 79 20 72 65 66  |t, for .easy ref|
00000b80  65 72 65 6e 63 65 2e 0a  0a 0a 0a 43 6f 6c 75 6d  |erence.....Colum|
00000b90  6e 20 62 6f 72 64 65 72  73 20 61 6e 64 20 6d 61  |n borders and ma|
00000ba0  72 67 69 6e 73 20 63 61  6e 20 62 65 20 64 72 61  |rgins can be dra|
00000bb0  67 67 65 64 20 75 73 69  6e 67 20 74 68 65 20 0a  |gged using the .|
00000bc0  6d 6f 75 73 65 20 66 6f  72 20 71 75 69 63 6b 20  |mouse for quick |
00000bd0  72 65 66 69 74 74 69 6e  67 20 6f 66 20 63 6f 6c  |refitting of col|
00000be0  75 6d 6e 73 2e 0a 0a 54  65 6c 6c 20 50 69 70 65  |umns...Tell Pipe|
00000bf0  44 72 65 61 6d 20 74 6f  20 41 75 74 6f 20 77 69  |Dream to Auto wi|
00000c00  64 74 68 20 66 6f 72 20  65 76 65 6e 20 71 75 69  |dth for even qui|
00000c10  63 6b 65 72 20 0a 72 65  66 69 74 74 69 6e 67 20  |cker .refitting |
00000c20  6f 66 20 63 6f 6c 75 6d  6e 73 2e 20 20 59 6f 75  |of columns.  You|
00000c30  27 6c 6c 20 77 6f 6e 64  65 72 20 68 6f 77 20 79  |'ll wonder how y|
00000c40  6f 75 20 65 76 65 72 20  67 6f 74 20 0a 62 79 20  |ou ever got .by |
00000c50  77 69 74 68 6f 75 74 20  74 68 69 73 20 6f 6e 65  |without this one|
00000c60  2e 0a 0a 54 68 65 20 64  6f 63 75 6d 65 6e 74 20  |...The document |
00000c70  6e 6f 77 20 61 70 70 65  61 72 73 20 69 6e 20 74  |now appears in t|
00000c80  68 65 20 77 69 6e 64 6f  77 20 69 6e 20 74 68 65  |he window in the|
00000c90  20 6c 69 6e 65 20 0a 68  65 69 67 68 74 20 74 6f  | line .height to|
00000ca0  20 62 65 20 75 73 65 64  20 77 68 65 6e 20 70 72  | be used when pr|
00000cb0  69 6e 74 69 6e 67 2e 20  20 56 65 72 79 20 6e 69  |inting.  Very ni|
00000cc0  63 65 2e 0a 0a 4d 6f 75  73 65 20 6f 70 65 72 61  |ce...Mouse opera|
00000cd0  74 69 6f 6e 73 20 68 61  76 65 20 62 65 65 6e 20  |tions have been |
00000ce0  73 69 6d 70 6c 69 66 69  65 64 20 61 6e 64 20 62  |simplified and b|
00000cf0  72 6f 75 67 68 74 20 0a  63 6c 6f 73 65 72 20 74  |rought .closer t|
00000d00  6f 20 6f 74 68 65 72 20  52 49 53 43 20 4f 53 20  |o other RISC OS |
00000d10  61 70 70 6c 69 63 61 74  69 6f 6e 73 2e 20 20 41  |applications.  A|
00000d20  6c 77 61 79 73 20 75 73  65 20 74 68 65 20 0a 6c  |lways use the .l|
00000d30  65 66 74 20 62 75 74 74  6f 6e 20 74 6f 20 63 6c  |eft button to cl|
00000d40  69 63 6b 20 69 6e 20 73  6c 6f 74 73 20 61 6e 64  |ick in slots and|
00000d50  20 6d 61 72 6b 20 62 6c  6f 63 6b 73 2e 20 20 0a  | mark blocks.  .|
00000d60  41 6c 77 61 79 73 20 75  73 65 20 74 68 65 20 72  |Always use the r|
00000d70  69 67 68 74 20 62 75 74  74 6f 6e 20 74 6f 20 61  |ight button to a|
00000d80  64 6a 75 73 74 20 6d 61  72 6b 65 64 20 62 6c 6f  |djust marked blo|
00000d90  63 6b 73 2e 20 20 0a 4e  65 77 20 4d 61 72 6b 20  |cks.  .New Mark |
00000da0  42 6c 6f 63 6b 20 42 6f  78 20 66 6f 72 20 69 6e  |Block Box for in|
00000db0  73 74 61 6e 74 61 6e 65  6f 75 73 20 73 65 74 74  |stantaneous sett|
00000dc0  69 6e 67 20 61 6e 64 20  0a 63 6c 65 61 72 69 6e  |ing and .clearin|
00000dd0  67 20 6f 66 20 62 6c 6f  63 6b 73 2e 20 0a 0a 53  |g of blocks. ..S|
00000de0  68 6f 72 74 20 6d 65 6e  75 73 20 61 72 65 20 6e  |hort menus are n|
00000df0  6f 77 20 63 6f 6e 66 69  67 75 72 61 62 6c 65 20  |ow configurable |
00000e00  73 6f 20 79 6f 75 20 73  70 65 63 69 66 79 20 6f  |so you specify o|
00000e10  6e 6c 79 20 0a 74 68 6f  73 65 20 61 6e 64 20 61  |nly .those and a|
00000e20  6c 6c 20 74 68 6f 73 65  20 63 6f 6d 6d 61 6e 64  |ll those command|
00000e30  73 20 79 6f 75 20 77 61  6e 74 2e 20 20 4f 72 20  |s you want.  Or |
00000e40  79 6f 75 20 63 61 6e 20  0a 73 65 74 20 50 69 70  |you can .set Pip|
00000e50  65 44 72 65 61 6d 20 75  70 20 66 6f 72 20 73 6f  |eDream up for so|
00000e60  6d 65 6f 6e 65 20 65 6c  73 65 20 74 6f 20 75 73  |meone else to us|
00000e70  65 2e 20 0a 50 61 72 74  69 63 75 6c 61 72 6c 79  |e. .Particularly|
00000e80  20 75 73 65 66 75 6c 20  69 6e 20 20 61 20 6c 65  | useful in  a le|
00000e90  61 72 6e 69 6e 67 20 65  6e 76 69 72 6f 6e 6d 65  |arning environme|
00000ea0  6e 74 2e 0a 0a 54 68 65  20 66 75 6e 63 74 69 6f  |nt...The functio|
00000eb0  6e 20 6b 65 79 20 6c 61  79 6f 75 74 20 69 73 20  |n key layout is |
00000ec0  6d 75 63 68 20 73 69 6d  70 6c 65 72 20 74 68 61  |much simpler tha|
00000ed0  6e 20 62 65 66 6f 72 65  20 0a 61 6e 64 20 46 33  |n before .and F3|
00000ee0  20 61 6e 64 20 46 34 20  61 72 65 20 6e 6f 77 20  | and F4 are now |
00000ef0  73 65 74 20 74 6f 20 53  61 76 65 20 61 6e 64 20  |set to Save and |
00000f00  53 65 61 72 63 68 2e 20  20 46 6f 72 20 0a 74 68  |Search.  For .th|
00000f10  6f 73 65 20 77 68 6f 73  65 20 66 69 6e 67 65 72  |ose whose finger|
00000f20  73 20 63 61 6e 27 74 20  62 65 20 72 65 74 72 61  |s can't be retra|
00000f30  69 6e 65 64 2c 20 61 20  63 6f 6d 6d 61 6e 64 20  |ined, a command |
00000f40  0a 66 69 6c 65 20 69 73  20 70 72 6f 76 69 64 65  |.file is provide|
00000f50  64 20 74 6f 20 63 6f 6e  66 69 67 75 72 65 20 50  |d to configure P|
00000f60  69 70 65 44 72 65 61 6d  20 34 20 74 6f 20 74 68  |ipeDream 4 to th|
00000f70  65 20 0a 50 69 70 65 44  72 65 61 6d 20 33 20 6c  |e .PipeDream 3 l|
00000f80  61 79 6f 75 74 2e 20 20  42 75 74 20 6c 65 61 72  |ayout.  But lear|
00000f90  6e 20 74 68 65 20 6e 65  77 20 6f 6e 65 3b 20 69  |n the new one; i|
00000fa0  74 27 73 20 6d 75 63 68  20 0a 62 65 74 74 65 72  |t's much .better|
00000fb0  2e 20 20 52 65 61 6c 6c  79 21 0a 0a 0a 0a 54 68  |.  Really!....Th|
00000fc0  65 73 65 20 62 6c 6f 63  6b 20 6f 70 65 72 61 74  |ese block operat|
00000fd0  69 6f 6e 73 20 68 61 76  65 20 62 65 65 6e 20 72  |ions have been r|
00000fe0  65 77 6f 72 6b 65 64 20  61 6e 64 20 61 72 65 20  |eworked and are |
00000ff0  0a 62 6f 74 68 20 6d 6f  72 65 20 70 6f 77 65 72  |.both more power|
00001000  66 75 6c 20 61 6e 64 20  73 61 66 65 2e 20 20 4e  |ful and safe.  N|
00001010  6f 20 6d 6f 72 65 20 63  6f 6c 75 6d 6e 20 73 6c  |o more column sl|
00001020  69 64 69 6e 67 20 0a 61  6e 64 20 79 6f 75 20 63  |iding .and you c|
00001030  61 6e 20 73 61 66 65 6c  79 20 6d 6f 76 65 20 62  |an safely move b|
00001040  6c 6f 63 6b 73 20 6c 65  66 74 20 61 6e 64 20 72  |locks left and r|
00001050  69 67 68 74 2e 20 20 43  6f 70 79 20 0a 61 6e 64  |ight.  Copy .and|
00001060  20 6d 6f 76 65 20 6f 76  65 72 77 72 69 74 65 20  | move overwrite |
00001070  74 68 65 20 74 61 72 67  65 74 20 61 72 65 61 20  |the target area |
00001080  69 66 20 69 74 20 69 73  20 62 6c 61 6e 6b 2e 20  |if it is blank. |
00001090  20 0a 49 66 20 6e 6f 74  2c 20 74 68 65 79 20 69  | .If not, they i|
000010a0  6e 73 65 72 74 20 62 6c  61 6e 6b 20 73 6c 6f 74  |nsert blank slot|
000010b0  73 20 6f 76 65 72 20 74  68 65 20 25 48 32 25 77  |s over the %H2%w|
000010c0  68 6f 6c 65 25 48 32 25  20 72 6f 77 20 0a 61 6e  |hole%H2% row .an|
000010d0  64 20 74 68 65 6e 20 6f  76 65 72 77 72 69 74 65  |d then overwrite|
000010e0  2e 20 20 4d 6f 76 65 20  61 6e 64 20 64 65 6c 65  |.  Move and dele|
000010f0  74 65 20 63 6c 65 61 72  20 74 68 65 20 62 6c 6f  |te clear the blo|
00001100  63 6b 20 0a 61 6e 64 20  6f 6e 6c 79 20 64 65 6c  |ck .and only del|
00001110  65 74 65 20 74 68 65 20  73 6c 6f 74 73 20 69 66  |ete the slots if|
00001120  20 61 6c 6c 20 73 6c 6f  74 73 20 74 6f 20 74 68  | all slots to th|
00001130  65 20 6c 65 66 74 20 0a  61 6e 64 20 72 69 67 68  |e left .and righ|
00001140  74 20 61 72 65 20 62 6c  61 6e 6b 2c 20 69 6e 20  |t are blank, in |
00001150  77 68 69 63 68 20 63 61  73 65 20 69 74 20 64 65  |which case it de|
00001160  6c 65 74 65 73 20 74 68  65 20 0a 77 68 6f 6c 65  |letes the .whole|
00001170  20 72 6f 77 2e 20 20 54  72 79 20 69 74 3b 20 79  | row.  Try it; y|
00001180  6f 75 27 6c 6c 20 6c 69  6b 65 20 69 74 2e 0a 0a  |ou'll like it...|
00001190  54 68 69 73 20 69 73 6e  27 74 20 6e 65 77 20 62  |This isn't new b|
000011a0  75 74 20 69 74 27 73 20  61 6d 61 7a 69 6e 67 20  |ut it's amazing |
000011b0  68 6f 77 20 6d 61 6e 79  20 70 65 6f 70 6c 65 20  |how many people |
000011c0  64 6f 6e 27 74 20 0a 6b  6e 6f 77 20 61 62 6f 75  |don't .know abou|
000011d0  74 20 69 74 2e 0a 0a 54  68 65 20 70 6f 73 69 74  |t it...The posit|
000011e0  69 6f 6e 20 6f 66 20 74  68 65 20 63 61 72 65 74  |ion of the caret|
000011f0  20 69 6e 20 74 68 65 20  77 69 6e 64 6f 77 20 61  | in the window a|
00001200  6e 64 20 74 68 65 20 0a  70 6f 73 69 74 69 6f 6e  |nd the .position|
00001210  20 6f 66 20 74 68 65 20  77 69 6e 64 6f 77 20 6f  | of the window o|
00001220  6e 20 74 68 65 20 73 63  72 65 65 6e 20 61 72 65  |n the screen are|
00001230  20 72 65 6d 65 6d 62 65  72 65 64 20 0a 73 6f 20  | remembered .so |
00001240  79 6f 75 20 72 65 73 74  61 72 74 20 65 78 61 63  |you restart exac|
00001250  74 6c 79 20 77 68 65 72  65 20 79 6f 75 20 6c 65  |tly where you le|
00001260  66 74 20 6f 66 66 2e 20  20 54 68 69 73 20 0a 73  |ft off.  This .s|
00001270  61 76 65 73 20 61 20 6c  6f 74 20 6f 66 20 74 69  |aves a lot of ti|
00001280  6d 65 2e 0a 0a 54 68 65  20 55 73 65 72 20 47 75  |me...The User Gu|
00001290  69 64 65 20 69 73 20 6e  6f 20 6d 6f 72 65 2e 20  |ide is no more. |
000012a0  20 49 6e 20 69 74 73 20  70 6c 61 63 65 20 61 72  | In its place ar|
000012b0  65 20 74 68 65 20 0a 50  69 70 65 44 72 65 61 6d  |e the .PipeDream|
000012c0  20 34 20 74 75 74 6f 72  69 61 6c 20 66 6f 72 20  | 4 tutorial for |
000012d0  6e 65 77 20 75 73 65 72  73 20 61 6e 64 20 74 68  |new users and th|
000012e0  65 20 50 69 70 65 44 72  65 61 6d 20 0a 34 20 52  |e PipeDream .4 R|
000012f0  65 66 65 72 65 6e 63 65  20 47 75 69 64 65 20 77  |eference Guide w|
00001300  69 74 68 20 69 74 73 20  75 6e 69 71 75 65 20 63  |ith its unique c|
00001310  72 6f 73 73 2d 72 65 66  65 72 65 6e 63 69 6e 67  |ross-referencing|
00001320  20 0a 73 74 72 75 63 74  75 72 65 20 66 6f 72 20  | .structure for |
00001330  61 64 76 61 6e 63 65 64  20 75 73 65 72 73 2e 20  |advanced users. |
00001340  20 54 68 65 20 50 69 70  65 44 72 65 61 6d 20 33  | The PipeDream 3|
00001350  20 0a 64 6f 63 75 6d 65  6e 74 61 74 69 6f 6e 20  | .documentation |
00001360  77 61 73 20 68 69 67 68  6c 79 20 70 72 61 69 73  |was highly prais|
00001370  65 64 3b 20 77 65 20 62  65 6c 69 65 76 65 20 74  |ed; we believe t|
00001380  68 69 73 20 0a 64 6f 63  75 6d 65 6e 74 61 74 69  |his .documentati|
00001390  6f 6e 20 69 73 20 73 65  72 69 6f 75 73 6c 79 20  |on is seriously |
000013a0  62 65 74 74 65 72 2e 0a  25 43 4f 3a 43 2c 32 30  |better..%CO:C,20|
000013b0  2c 34 38 25 25 43 4f 3a  44 2c 31 32 2c 33 36 25  |,48%%CO:D,12,36%|
000013c0  25 43 4f 3a 45 2c 31 32  2c 32 34 25 25 43 4f 3a  |%CO:E,12,24%%CO:|
000013d0  46 2c 31 32 2c 31 32 25                           |F,12,12%|
000013d8