@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Printed page
@ character 149
inserting Charts 41
in Custom Functions 55
in Label Printing 130
in Mailshots 145
@-fields 149
Abbreviations 235
ABS 149
ACOSEC 264
ACOSECH 264
ACOSH 264
ACOT 265
ACOTH 265
Acronyms 235
ACS 264
ADD 180
Adding
a blank row at end of document 77
a column 78
a line 75
data to a chart 31
words to a dictionary 244
AGE 71
ALERT 160
Aliases see Names
Alignment 11
altering 11
centre 11
default 11
free 11
LCR 11
left 11
of columns 185
Alternate font see Highlights and Fonts 112, 118
American style dates see also Options 71; 186
Anagrams 241
AND 180
Arithmetic operators
see also Formulae 174; 180
Arrays see also Formulae elements 13; 177
and custom functions 14
and ranges 15
in lists 15
passing to functions 13
Arrow keys 26
Ascending sort see also Sorting 67; 233
ASCII format see also File Operations 16; 104
loading in 17
saving in 16
ASEC 265
ASECH 265
ASINH 265
ASN 265
ATAN_2 265
ATANH 265
ATN 265
Auto Recalc 219
Auto Width see also Number Formats 173; 278
Automatic check status (spelling) 235
Automatic start-up options: see Choices and Template files
AVG 249
Axes 40
controlling 40
of rotation 34
Axis 40
Background recalculation 219
Bar charts 33
Bar Gallery dialogue box 33
Bars
depth of 34
overlap between 34
width of 34
BASE -
BIN -
BJ10 203
Block operations 18
Blocks 22
spell checking 238
copying 18
deleting
see also Paste 20; 192
deleting in formula window 176
extending marking of 23
formatting 221
highlighting 119
insertion rules 20
marking 22 - 24
marking in formula window 176
moving 18
saving 103
searching 232
transposing 21
Blocks menu 156
Bold
see also Printer Driver Editing 118 - 119; 202 - 206
Borders 185
displaying 185
hiding 185
of columns 24
of rows 24
Brackets for negative numbers 171
BREAK 59
Browsing dictionary 236
advanced 237
Calling a custom function 54
Caret
movements 26
positioning of
see also Mouse Techniques 26; 164
saving position of 28
Caret menu
Case in searching 231
CEILING -
Cell references
see also Arrays and Formulae 174; 177; 182
fixed 182
putting into the formula line 165
sorting 233
Centre Align 11
Centre Window 27
Change Menus 159
CHAR 254
Characters
deleting 80
inserting 80
!Chars application 80
Chart Editing Menu 33
Chart Editing Window 32
Charts 29
adding data to 31
autoscaling 40
bar 34
changing the style of 36
colour of text in 40
controlling the axes of 40
deleting 32
line 35
pie 34
point 35
preferred type 33
saving 41
scatter 35
selecting 30
Charts menu 153
Choices 122
saving 229
Choices file see also Saving Choices
and Spell-checking
and User Dictionary 184; 229; 242; 249
settings saved in 229
Choices menu 156
CHOOSE 137
Choosing commands 165
Circular references 219
Clearing
markers 25
name definitions 129
protection 218
CODE 254
COL 160
Colour Selection dialogue box 37
Colours 43
of hint in charts 40
of lines in charts 38
of text in charts 40
Colours constructs 200
COLS 161
Column widths
adjusting to new cell formats 173
Columns
adding 78
alignment of 185
borders 24
deleting 78
fixing 111
independent
see also Insert on Wrap 185; 258
inserting 77
linked 277
setting width of
see also Width of Text 258; 277
Comma separated values see also File Operations 52; 104
Command error messages 83
Command files 43
and startup 46
recording 43
Command recorder 43
Command sequence defining 126
Commands 128
alphabetical list of 3
choosing 165
Complex number functions see also Functions 48; 115
Conditional page breaks 188
Conditions 174
Constructs
colours 200
options 198
printer driver 200
CONTINUE 59
Control codes 202
Control statements 56
Converting
a formula to a value 172
text cells into number cells 173
Copying
blocks 18
differences between replication and copying 226
formulae 222
number cells 222
COS 266
COSEC 266
COSECH 266
COSH 266
COT 266
COTH 266
COUNT 249
COUNTA -
Counting words 278
CSV format 52
CTERM 106
Ctrl-key sequences
redefining 127
Custom function sheet 53
formulae on 56
Custom functions 53
calling 54
control statements in 56
defining 53
execution of 56
library loading of 54
names of 54
passing arrays to 13
special functions used in 61
C_ACOS 48
C_ACOSEC 48
C_ACOSECH 48
C_ACOSH 49
C_ACOT 49
C_ACOTH 49
C_ADD 49
C_ASEC 49
C_ASECH 49
C_ASIN 49
C_ASINH 49
C_ATAN 49
C_ATANH 50
C_COS 50
C_COSEC 50
C_COSECH 50
C_COSH 50
C_COT 50
C_COTH 50
C_DIV 50
C_EXP 50
C_LN 51
C_MUL 51
C_POWER 51
C_RADIUS 51
C_SEC 51
C_SECH 51
C_SIN 51
C_SINH 51
C_SUB 51
C_TAN 52
C_TANH 52
C_THETA 52
Daisywheel printers
see also Printing 205; 216
Database
functions
see also Functions 62; 115
saving selected records from 69
usage 65
DATE see also Text @ Fields 72; 262
Date format 186
Date functions 116
Dates see also Formulae in Number Cells
and Dates in Number Cells 71; 174; 177 - 178
DATEVALUE 72
DAVG 63
DAY 72
DAYNAME 72
DCOUNT 63
DCOUNTA 63
DDB 106
Decimal places see also Options 170; 185
DECIMAL -
Default alignment 11
Default format 170
Define Function Key 127
Define Key 125
Defining
a command sequence 126
a custom function 53
a function key 44
a name 168
a text sequence 125
your keyboard 125
DEG 266
Deleting
a block see also Paste 20; 192
a character 80
a chart 32
a column 78
a line 75
a row 77
a row in column 77
a word see also Paste 80; 191
a word from a user dictionary 244
blocks in the formula window 176
recovering deletions (see Paste)
text 81
to the end of a cell 80
Dependent documents 97
Depth of bars in their cells 34
Depth of lines in their cells 35
DEREF 161
Descending sort see also Database Use 67; 233
Desktop Publishing programs
transfer PipeDream files to 104
Dictionaries
displaying 244
locking
see also Other Operations 240; 246
Differences
between copy and replicate 226
between printer drivers 213
Displaying borders 185
Divide 180
DMAX 63
DMIN 64
Do command file 44
Documents 122
inserting 164
loading 104
saving part of 102
$ character 225
Dot matrix see also Printing 203; 216
Double spacing 206
Double strike 205
Dragging
the right margin marker 276
to mark a block 22
Draw 196
DSTD 64
DSTDP 64
DSUM 64
DTP programs
transferring PipeDream files to 104
Dumping a user dictionary 247
DVAR 64
DVARP 65
Dynamic chart updating see also Hotlinks 30; 120
Edit Formula 175
Editing 75
a chart 42
a number cell 174
PipeDream printer drivers 202
text in your chart 39
ELSEIF 57
End of a paragraph 220
ENDIF 57
ENDWHILE 58
Error messages 83
in commands 83
in number cells 92
Even right-hand margins 221
EXACT 255
EXP 149
Exponential format 179
Extended character 206
Extended sequence 118
Extending a marked block 23
External references 97
and directories 100
File operations 102
Files
inserting into other files 105
loading 104
saving 102
Files menu 152
Fill colour 37
Fill from database option 147
Fill pattern 38
using your own picture
see also Charts - Fill Style 33; 38
Fill style 38
Financial functions see also Functions 106; 116
FIND 255
First column 27
First Word Plus format See also File Operations 104; 109
Fixed cell references 182
Fixing rows and columns 111
FLIP -
Floating format see also Decimal places 170; 185
Floating point inaccuracy. see ROUND
FLOOR -
Floppy disc dictionary locking 240
Flush Dictionaries 24
Fonts 112
changing globally 113
changing locally 114
saving information on
see also Template files 229; 259
Footers 189
justified too far to the right 268
FOR 59
Forced page breaks 188
Foreign characters
see also Printer Driver Editing 128; 205
Foreign dictionaries 243
Format
date 186
default 170
exponential 179
First Word Plus
see also File operations
104; 109
floating
and see Options 170; 185
number 169
paragraph 104
PipeDream 197
Formatting
blocks 221
paragraphs 220
Formfeed 207
Formula line
keys used on 175
pasting functions into 176
putting cell references into
transfer to formula window 177
Formula window 176
deleting blocks in 176
keys used on 175
marking blocks in 176
pasting functions into 176
Formulae 174
converting to values 172
copying 222
on custom function sheets 56
FORMULA_TEXT -
Forward references 219
Free Align 11
Full Screen 46
FUNCTION see also Number Cells 53; 54; 176
Function keys
PipeDream 3 settings 46
redefining 126
Function menu 158
Functions see also Number Cells 115; 174; 177; 178
complex number 48
database 62
date 71
financial 106
lookup 137
mathematical 149
matrix 150
miscellaneous 160
passing arrays to 13
paste to formula line / window 176
statistical 249
string 254
trigonometrical 264
used in custom functions 61
Future value 107
FV 107
Gallery sub-menu 31
Go to cell 27
GRAND 249
Grid 186
GROWTH 250
Hard page breaks 187
removing 188
Headers 189
justified too far to the right 268
Height
of lines 114
Help 5
Hiding borders 185
Highlight codes 206
Highlighting
a block 119
a small section of text 118
Highlights
see also Printer Driver Editing 118; 204
HLOOKUP 137
HMI 209
Home key 26
Horizontal motion increment 209
HotLinks 120
HOUR 73
HPJet see also Printing 203; 216
Icon menu see also Menus 122; 154
IF see also Miscellaneous Functions 57; 161
Indenting paragraphs 122
just the first line 123
the whole paragraph 123
Independent columns see also Tables 185; 258
INDEX see also Arrays 13; 138
Info see also Icon Menu 5; 122
Initialisation
See Choices, Template Files
INPUT 161
Insert on Return 186
Insert on wrap see also Tables 185; 258
Inserting 80
a character 80
a column 77
a page 188
a row 75
a row in column 76
a space 80
a word into a user dictionary 244
documents 164
one file into another 105
INT 150
Internal rate of return 107
modified 107
Invalid words 235
IRR 107
Italic
see also Printer Driver Editing 118; 206
JOIN 255
Joining lines 78
Justification
see also Reformatting Text 185; 221
in mailshots 149
Keyboard 26
definition of 125
Keys
redefining to do commands 128
used on formula line/ window 175
Label printing 130
Landscape 215
Language definition files 243
Last column 27
Layout menu 154
LCR Align 11
Leading characterssee also Options 171; 186
LEFT 255
Left Align 11
Legend 39
LENGTH 255
Library 101
loading files from 101
loading custom functions from 54
Line
charts 35
colour 38
depth of 35
height 114
style 39
Line Gallery dialogue box 35
Line separator
Linefeeds in printer drivers 206
Lines
adding 75
deleting 75
joining 78
splitting 78
LINEST 250
organising data for input to 251
Linked columns 277
LISTCOUNT -
Lists
see also Editing Number Cells 177; 179
LN 150
Loading
a file on start-up 104
a First Word Plus file 110
a PipeDream document 104
files 104
files from a library 101
in ASCII format 17
in different formats 105
in paragraph format 17
part of a document 105
Local Font 114
Locking dictionaries 240
LOG 150
Log scaling 40
Logarithm 150
LOGEST 251
Logical operators 180
LOOKUP 138
Lookup functions see also Functions 116; 137
Lotus conversion 46
LOWER 255
M_DETERM 151
M_INVERSE 151
M_MULT 151
M_TRANSPOSE 151
Macros
see Command files and Custom functions
Mailshots 145
Manual recalculation 219
Marking
a block 22
a single cell 25
blocks in the formula window 176
the whole document 25
using borders 24
MATCH 138
Mathematical functions see also Functions 116; 149
MAX 252
MEDIAN -
Memory 151
Menus 152
bringing up 165
changing 159
Merging file into user dictionary 248
Microspacing 208
MID 256
MIN 252
Minus sign for negative numbers 171
MINUTE 73
MIRR 107
Miscellaneous functionssee also Functions 116; 160
MOD 150
Modified internal rate of return 107
MONTH 73
MONTHDAYS 73
MONTHNAME 73
Mouse techniques 164
Moving
a block 18
a block of text to the right 18
a command to a short menu 159
one character to the right 26
text 191
the caret 26
the right margin left 275
the right margin right 275
to a particular cell 27
to the bottom of the column 26
to the end of the cell 26
to the next column 26
to the next word 26
to the previous column 26
to the previous word 26
to the start of the cell 26
to the top of the column 26
Multi-column layout 258
Multi-row records 68
sorting 68
Multiply 180
Names see also Number Cells 167; 179
changing the definition of 169
clearing the definition of 129
defining 168
of custom functions 54
using 168
Naming files 102
Natural logarithm 150
Natural recalculation 219
Negative numbers see also Options 171; 185
Net present value 108
Networks 195
New Chart 30
New Document 122
New cell format 184
New Text in chart 39
New Window 6
Next match 231
Next Window 6
NOT 180
NOW 73
NPV 108
Number <> Text 173
Number formats 169
Number cells see also Options 173 - 174; 184
converting into text cells 173
copying 222
Numbers 174; 177; 179
negative
see also Options 171; 185
Offset (HMIO) 209
Operators see also Editing 177; 180
logical 180
order of precedence of 181
relational 180
Options 184
Options constructs 198
OR 180
Order of precedence of operators 181
Overlap between adjacent bar cells 34
Overlays 36
Overtyping 80
switching to inserting 79
Pack User Dictionary 247
Page breaks 187
conditional 188
forced 188
hard 187
removing 188
Page layout 189 - 190
saving information 259
Page length 268
Page width 191
Page numbering see also Text @ Fields 189; 190; 262
in VIEW transfer 273
Pages 207
inserting 188
Paint 196
Paragraph end 220
Paragraph file format see also File Operations 16; 104
loading in 17
saving a file in 16
Paragraphs
formatting 220
Parameters in custom functions 55
Paste see also Editing 81; 191 - 192
commands recovered with 192
depth
see also Saving Choices 192; 229
Pasting to formula line/ window 176
Paths 193
Pause 45
PD 123 error messages 91
Penguin Graphics 38
PERMUT 252
% sign 278
PI 266
Pictures 196
Pie charts 32
Pie Gallery dialogue box 32
!PipeDream.CmdFiles.PD3keys 46
!PipeDream.Dictdefn 243
!PipeDream.key 46
PipeDream 3 function key settings 46
PipeDream file format 197
PipeDream Network Installation 195
PipeDream printer driver editing 202
PipeDream printer drivers 213
Plain text 104
PMT 108
Point charts 35,36
Point size 113
Population standard deviation 64
Portrait 215
Positioning the caret
see also Caret Movements 26; 164
£ sign 268
Preferred chart type 29
Present value 108
Preventing lines from wrapping 221
Previous match 231
Print menu 155
Printer Config 215 - 216
Printer Driver constructs 200
Printer drivers 211
codes in 203
creating 202
editing 202
PipeDream 213
RISC OS 213
saving 211
Printing
a marked block 217
labels 130
part of a document 217
problems with 267
to a file 217
to the screen 217
with PipeDream printer driver 216
with RISC OS printer driver 215
Programming: see Custom functions and Command files
PROPER 256
Proper nouns in dictionaries 235
Proportional spacing 208
Protection 218
clearing 218
PV 108
Quit 122
RAD 266
Raise to the power 180
RAND 252
Ranges see also Arrays 177; 181
and arrays 15
RANK -
RATE 108
Recalculation 219
automatic 219
background 219
manual 219
natural 219
Record command file 43
Records
multi-row 68
single row 66
Reformatting
a block of text 221
a paragraph 220
Relational operators 180
Removing
a command from a short menu 159
a hard page break 188
highlights 119
chart overlays 37
Rename File 102
REPEAT 58
Repeating a command see also Paste 81; 191
REPLACE 256
Replace string sequences 232
Replacing
cell contents 46
text 231
Replicating 226
a range into a table 228
a range of cells 227
a single cell 227
differences between copy and replicate 226
down 222
right 222
REPT 256
Restore position 28
RESULT 53; 56
REVERSE 256
RIGHT 256
Right Align 11
Right margin marker 275
Right margins see also
Tables and Editing 78; 258; 276
changing for group of columns 275
changing for one column 276
finding 275
ragged 185
RISC OS printer drivers 213
ROUND see also Number Formats 150: 170
ROW 162
Row borders 24
ROWS 163
Rows
adding to end of document 77
deleting 78
fixing 111
inserting 75
saving a selection of
see also File Operations 69; 103
Rubout 80
Save choices see also Icon Menu 122; 229
Save Position 28
Save Template File 260
Saving
document in different formats 104
a First Word Plus file 110
a marked block 103
a selection of rows
see alo Database use 69; 103
a template file 260
choices 229
files 102
in ASCII format 16
in paragraph format 16
in VIEW format 271
part of a document 102
selected records from database 69
the caret position 28
your chart 41
your printer driver 211
your spell checking set-up 242
your user dictionary set-up 249
Scatter charts 35
Scatter Gallery dialogue box 35
Scroll bars 165
Search and replace 230
case in 231
number cells 232
only marked block 232
sequences which can be used in 232
SEC 267
SECH 267
SECOND 73
Selecting a chart 30
Selection sub-menu 36
Selections. See Blocks and Marking
SERIESSUM -
SET_NAME 163
SET_VALUE 163
Setting column widths see also Width of Text 258; 277
SGN 150
Sign brackets 171
Sign minus 171
SIN 267
Single row records 66
SINH 267
Site licence 195
SLN 109
Snapshot 172
SORT 233
Sorting 233
in descending order
see also Database Use 67; 233
multi-row records 68
on several columns
see also Sorting 67; 234
single-row records 67
cell references 233
statsfns.html#SPEARMAN -
Spell checking 234
saving set-up 242
Spell menu 157
Splitting lines 78
SQR 150
Standard deviation 252
Statistical functions see also Functions 117; 249
STD 252
STDP 252
Straight line depreciation 109
STRING 256
String functions see also Functions 117; 254
Strings see also Arrays 177; 183
Style of lines in charts 39
Subgrams 241
Subscript see also Printer Driver Editing
and Highlight 118; 202; 206
Subtract 180
SUM 150
Superscriptsee also Printer Driver Editing
and Highlight 118; 202; 206
Supporting documents 97
Swapping case 79
Swapping position and caret 28
Switching on Auto check 235
SYD 109
Tables 258
TAN 267
TANH 267
Template files see also Options 184; 259
creating 260
opening a new document with 164
provided on PipeDream disc 259
saving 260
suggested settings 261
using 260
TERM 109
Text @-fields 262
Text colour in charts 40
Text cells 184
converting into number cells 173
Text strings 174
Text Window 39
Thousands separator
see also Options 171; 185
TIME 73
Times see also Number Cells 71; 178
TIMEVALUE 73
Title 264
Title pages 190
TODAY 74
Toolbar New
Top-bit set character 80
Trailing characters see also Options 171 - 172; 186
TRANSPOSE (function) 151
Transposing blocks 21
TREND 252
Trigonometrical functions
see also Functions 117; 264
TRIM 257
Trouble-shooting 267
Two sided 215
TYPE 163
Typefaces see Fonts
Underline see also Highlights
and Printer Driver Editing 118; 202; 206
Undo see Paste
Unlock Dictionary 240
UNTIL 58
UPPER 257
User dictionaries 242
adding words to 244
creating 243
dealing with large ones 247
deleting words from 244
displaying 244
dumping 247
flushing 246
inserting words into 244
merging a file into 248
opening 243
packing 247
saving set-up of 249
VALUE 257
VAR 253
Variance 252; 253
VARP 253
VERSION 163
VIEW format see also File Operations 104; 271
saving a file in 271
VIEW transfer
dates in 273
headers and footers in 273
highlights in 274
line spacing in 272
rulers in 273
ViewSheet transfer 274
VLOOKUP 139
Wait between pages and the next section 216; 217
WEEKDAY 74
WEEKNUMBER -
WHILE 58
Width
of bars in their cells 34
of columns
and see Tables 258; 277
of text 275
Wildcards in Databases see also Saving Files
and Number Cell Operators 70; 103; 180
in Browse Dictionary 237
Word count 278
Words
deleting
see also Paste 80; 191
deleting from user dictionaries 244
inserting into user dictionaries 244
invalid 235
Wrapping 185
preventing lines from 221
turning off 221
YEAR 74
Z88 transfer 279
Zero width of a column 277