Home » Archimedes archive » Acorn User » AU 1994-Xmas.adf » Programs » HomeWorks/ReleasNt1
HomeWorks/ReleasNt1
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 » Acorn User » AU 1994-Xmas.adf » Programs |
| Filename: | HomeWorks/ReleasNt1 |
| Read OK: | ✔ |
| File size: | 183A bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
HomeWorks Sheet v1.00 - release notes
-------------------------------------
1) This is a complete list of keys that can be used in the main window. There
are also numerous FN/Ctrl-X and letter key presses available in dialogue
boxes.
Esc : Abandon formula / close dbox
Return : Confirm formula / dbox default action
Ctrl+'A' : Select all
Ctrl+'Z' : Clear selection
Ctrl+'X' : Cut
Ctrl+'C' : Copy
Ctrl+'K' : Clear
Ctrl+'V' : Paste
Ctrl+'B' : Cell border dialogue
Ctrl+'F' : Function Browser
Ctrl+'G' : Grid on/off
Ctrl+'L' : Labels on/off
Ctrl+'S' : Keyboard select mode on/off
Ctrl+'P' : Protrction on/off
Ctrl+'I' : Input block on/off
Ctrl+'E' : Find next error
Print : Print dbox
Fn1 : Edit cell
Fn3 : Save file
Fn5 : Go to cell
Fn6 : Recalculate
Fn7 : Add columns
Fn8 : Add rows
Fn9 : Show formulae
S+Fn3 : Save as CSV
S+Fn7 : Delete columns
S+Fn8 : Delete rows
S+Fn9 : Scale view
C+Fn2 : Close window
C+Fn3 : Save as TSV
C+Fn6 : Edit cell styles
C+Fn7 : Alter column height
C+Fn8 : Alter row height
C+Fn9 : New view
S+C+Fn3 : Save as Draw
Fn10 : Lock cells
Fn11 : Hide cells
S+Fn10 : Unlock cells
S+Fn11 : Unhide cells
S+C+Fn11 : Revert to saved
Left : Move cursor left
Right : Move cursor right
Down : Move cursor down
Up : Move cursor up
C+Left : Move cursor to leftmost column
C+Right : Move cursor to rightmost column
C+Down : Move cursor bottom row
C+Up : Move cursor top row
Ctrl+'U' : Edit cell from empty
Backspace: Edit cell, deleting last char
Delete : Edit cell, deleting last char
2) The following special code sequences can be used in numeric format strings
in the numeric fomat section of the cell style editor.
## = '#'
#nn : Best representation with n=1-9 where scientific form used when exp>n
#fn : Fixed point with n=0-9 digits after point
#sn : Scientific with n=0-9 digits after point
#H0 : Hours in time
#H1 : as H0 but in 24 hour clock with leading 0
#P : am/pm
#m0 : Minutes with leading 0
#m1 : Minutes without leading 0
#S0 : Seconds with leading 0
#S1 : Seconds without leading 0
#D0 : Day with leading 0
#D1 : Day without leading 0
#O : ordinal (th/nd/st of date)
#M0 : Month as number
#M1 : Month as name
#M2 : Month as three character name
#Y0 : Year, 4 digits
#Y1 : Year, 2 digits
3) The header and footer fields of the print dialogue box can contain these
special fields:
#f : File leafname : Accounts1
#F : File full pathname : ADFS::HardDisc4.$.Office.Accounts1
#P : Page number : 4
#p : As #P : 4
#T : 24 hour time : 15:11:22
#t : 12 hour time : 3:11pm
#D : Date in short form : 26th Feb 1994
#d : Date in long form : Sat, 26th February 1994
4) Calculations on cell ranges cannot be performed in this version of HomeWorks SpreadSheet. This can be achieved by listing individual cells in formulae
eg.
=STDEVP(A1:B3)
becomes
=STDEVP(A1,A2,A3,B1,B2,B3)
5) Only about 1/3 of the planned functions is implemented. In the function
browser, these are listed in grey. Functions in black are available
though. Help on functions can be found by toggling the function browser
to full size. Basic operators +, /, *, and - are available directly. +
and - are available in both monadic and dyadic forms. Brackets are
available to override precedence which is the standard form of functions
then multiplication operators then addition operators then logic operators.
The logical operators =, <, >, >=, <= and <> (not equal to) are also
available. Formulae beginning with a digit +, or -, are evaluated. A
leading = will force a formula to be evaluated in case it starts with
some other character. Any other formula is treated as text.
6) Cell references are of the standard <column-name><row-number> format
an '@' character can be used to override the adjustment of references
that occurs during fill and paste operations, (though it will not be
regarded in colmn or row insertion operations).
In the following examples imagine that the contents of cell C3 have
been used in a fill operation and the result in D4 is shown:
C3 D4
=H8 =I9
=@H8 =@H9
=H@8 =I@8
=@H@8 =@H@8
7) Empty cells are always interpreted as zero values in this version of
HomeWorks Spreadsheet.
8) The style in which the headers and footers of a document are printed can
be set explicitly. Normally, the first style found is used, but if styles
named 'Header' or 'Footer' are found, these will be used instead. Note
that only text font size and style are recognised. Kerning, underlining,
colours and justification may be recognised in future versions.
9) Printing at certain scales less than 100% can cause the edge of right
justified text to be lost slightly. This is not a major problem and
can usually be remedied by printing at a slightly smaller or larger
scale.
NOTE: HomeWorks will not run correctly on a write protected disc.
Known problems:
---------------
Very long numbers can cause crashes when entered in to the sheet, so avoid
entering numbers with very many digits.
Printing by dragging from the save box does not work. Print a spreadsheet
document by using the print dialogue box, or dragging it from a filer
window directly to a printer instead.
If a spreadsheet is displayed which has many cells which have text overflowing,
much of it won't appear. Use a smaller font or widen the cells to enable it
to be displayed.
The paste icon in the button bar is not ungreyed in windows which are open
when the first Cut or Copy operation is performed in another window. They
are not ungreyed when memory restrictions cause the clipboard to be cleared.
Use the menu or key ^V if the icon is wrongly greyed out.
00000000 48 6f 6d 65 57 6f 72 6b 73 20 53 68 65 65 74 20 |HomeWorks Sheet | 00000010 76 31 2e 30 30 20 2d 20 72 65 6c 65 61 73 65 20 |v1.00 - release | 00000020 6e 6f 74 65 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |notes.----------| 00000030 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00000040 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 0a 31 29 |-----------...1)| 00000050 20 54 68 69 73 20 69 73 20 61 20 63 6f 6d 70 6c | This is a compl| 00000060 65 74 65 20 6c 69 73 74 20 6f 66 20 6b 65 79 73 |ete list of keys| 00000070 20 74 68 61 74 20 63 61 6e 20 62 65 20 75 73 65 | that can be use| 00000080 64 20 69 6e 20 74 68 65 20 6d 61 69 6e 20 77 69 |d in the main wi| 00000090 6e 64 6f 77 2e 20 54 68 65 72 65 0a 20 20 20 61 |ndow. There. a| 000000a0 72 65 20 61 6c 73 6f 20 6e 75 6d 65 72 6f 75 73 |re also numerous| 000000b0 20 46 4e 2f 43 74 72 6c 2d 58 20 61 6e 64 20 6c | FN/Ctrl-X and l| 000000c0 65 74 74 65 72 20 6b 65 79 20 70 72 65 73 73 65 |etter key presse| 000000d0 73 20 61 76 61 69 6c 61 62 6c 65 20 69 6e 20 64 |s available in d| 000000e0 69 61 6c 6f 67 75 65 0a 20 20 20 62 6f 78 65 73 |ialogue. boxes| 000000f0 2e 0a 0a 20 20 20 45 73 63 20 20 20 20 20 20 3a |... Esc :| 00000100 20 41 62 61 6e 64 6f 6e 20 66 6f 72 6d 75 6c 61 | Abandon formula| 00000110 20 2f 20 63 6c 6f 73 65 20 64 62 6f 78 0a 20 20 | / close dbox. | 00000120 20 52 65 74 75 72 6e 20 20 20 3a 20 43 6f 6e 66 | Return : Conf| 00000130 69 72 6d 20 66 6f 72 6d 75 6c 61 20 2f 20 64 62 |irm formula / db| 00000140 6f 78 20 64 65 66 61 75 6c 74 20 61 63 74 69 6f |ox default actio| 00000150 6e 0a 20 20 20 43 74 72 6c 2b 27 41 27 20 3a 20 |n. Ctrl+'A' : | 00000160 53 65 6c 65 63 74 20 61 6c 6c 0a 20 20 20 43 74 |Select all. Ct| 00000170 72 6c 2b 27 5a 27 20 3a 20 43 6c 65 61 72 20 73 |rl+'Z' : Clear s| 00000180 65 6c 65 63 74 69 6f 6e 0a 20 20 20 43 74 72 6c |election. Ctrl| 00000190 2b 27 58 27 20 3a 20 43 75 74 0a 20 20 20 43 74 |+'X' : Cut. Ct| 000001a0 72 6c 2b 27 43 27 20 3a 20 43 6f 70 79 0a 20 20 |rl+'C' : Copy. | 000001b0 20 43 74 72 6c 2b 27 4b 27 20 3a 20 43 6c 65 61 | Ctrl+'K' : Clea| 000001c0 72 0a 20 20 20 43 74 72 6c 2b 27 56 27 20 3a 20 |r. Ctrl+'V' : | 000001d0 50 61 73 74 65 0a 20 20 20 43 74 72 6c 2b 27 42 |Paste. Ctrl+'B| 000001e0 27 20 3a 20 43 65 6c 6c 20 62 6f 72 64 65 72 20 |' : Cell border | 000001f0 64 69 61 6c 6f 67 75 65 0a 20 20 20 43 74 72 6c |dialogue. Ctrl| 00000200 2b 27 46 27 20 3a 20 46 75 6e 63 74 69 6f 6e 20 |+'F' : Function | 00000210 42 72 6f 77 73 65 72 0a 20 20 20 43 74 72 6c 2b |Browser. Ctrl+| 00000220 27 47 27 20 3a 20 47 72 69 64 20 6f 6e 2f 6f 66 |'G' : Grid on/of| 00000230 66 0a 20 20 20 43 74 72 6c 2b 27 4c 27 20 3a 20 |f. Ctrl+'L' : | 00000240 4c 61 62 65 6c 73 20 6f 6e 2f 6f 66 66 0a 20 20 |Labels on/off. | 00000250 20 43 74 72 6c 2b 27 53 27 20 3a 20 4b 65 79 62 | Ctrl+'S' : Keyb| 00000260 6f 61 72 64 20 73 65 6c 65 63 74 20 6d 6f 64 65 |oard select mode| 00000270 20 6f 6e 2f 6f 66 66 0a 20 20 20 43 74 72 6c 2b | on/off. Ctrl+| 00000280 27 50 27 20 3a 20 50 72 6f 74 72 63 74 69 6f 6e |'P' : Protrction| 00000290 20 6f 6e 2f 6f 66 66 0a 20 20 20 43 74 72 6c 2b | on/off. Ctrl+| 000002a0 27 49 27 20 3a 20 49 6e 70 75 74 20 62 6c 6f 63 |'I' : Input bloc| 000002b0 6b 20 6f 6e 2f 6f 66 66 0a 20 20 20 43 74 72 6c |k on/off. Ctrl| 000002c0 2b 27 45 27 20 3a 20 46 69 6e 64 20 6e 65 78 74 |+'E' : Find next| 000002d0 20 65 72 72 6f 72 0a 20 20 20 50 72 69 6e 74 20 | error. Print | 000002e0 20 20 20 3a 20 50 72 69 6e 74 20 64 62 6f 78 0a | : Print dbox.| 000002f0 20 20 20 46 6e 31 20 20 20 20 20 20 3a 20 45 64 | Fn1 : Ed| 00000300 69 74 20 63 65 6c 6c 0a 20 20 20 46 6e 33 20 20 |it cell. Fn3 | 00000310 20 20 20 20 3a 20 53 61 76 65 20 66 69 6c 65 0a | : Save file.| 00000320 20 20 20 46 6e 35 20 20 20 20 20 20 3a 20 47 6f | Fn5 : Go| 00000330 20 74 6f 20 63 65 6c 6c 0a 20 20 20 46 6e 36 20 | to cell. Fn6 | 00000340 20 20 20 20 20 3a 20 52 65 63 61 6c 63 75 6c 61 | : Recalcula| 00000350 74 65 0a 20 20 20 46 6e 37 20 20 20 20 20 20 3a |te. Fn7 :| 00000360 20 41 64 64 20 63 6f 6c 75 6d 6e 73 0a 20 20 20 | Add columns. | 00000370 46 6e 38 20 20 20 20 20 20 3a 20 41 64 64 20 72 |Fn8 : Add r| 00000380 6f 77 73 0a 20 20 20 46 6e 39 20 20 20 20 20 20 |ows. Fn9 | 00000390 3a 20 53 68 6f 77 20 66 6f 72 6d 75 6c 61 65 0a |: Show formulae.| 000003a0 20 20 20 53 2b 46 6e 33 20 20 20 20 3a 20 53 61 | S+Fn3 : Sa| 000003b0 76 65 20 61 73 20 43 53 56 0a 20 20 20 53 2b 46 |ve as CSV. S+F| 000003c0 6e 37 20 20 20 20 3a 20 44 65 6c 65 74 65 20 63 |n7 : Delete c| 000003d0 6f 6c 75 6d 6e 73 0a 20 20 20 53 2b 46 6e 38 20 |olumns. S+Fn8 | 000003e0 20 20 20 3a 20 44 65 6c 65 74 65 20 72 6f 77 73 | : Delete rows| 000003f0 0a 20 20 20 53 2b 46 6e 39 20 20 20 20 3a 20 53 |. S+Fn9 : S| 00000400 63 61 6c 65 20 76 69 65 77 0a 20 20 20 43 2b 46 |cale view. C+F| 00000410 6e 32 20 20 20 20 3a 20 43 6c 6f 73 65 20 77 69 |n2 : Close wi| 00000420 6e 64 6f 77 0a 20 20 20 43 2b 46 6e 33 20 20 20 |ndow. C+Fn3 | 00000430 20 3a 20 53 61 76 65 20 61 73 20 54 53 56 0a 20 | : Save as TSV. | 00000440 20 20 43 2b 46 6e 36 20 20 20 20 3a 20 45 64 69 | C+Fn6 : Edi| 00000450 74 20 63 65 6c 6c 20 73 74 79 6c 65 73 0a 20 20 |t cell styles. | 00000460 20 43 2b 46 6e 37 20 20 20 20 3a 20 41 6c 74 65 | C+Fn7 : Alte| 00000470 72 20 63 6f 6c 75 6d 6e 20 68 65 69 67 68 74 0a |r column height.| 00000480 20 20 20 43 2b 46 6e 38 20 20 20 20 3a 20 41 6c | C+Fn8 : Al| 00000490 74 65 72 20 72 6f 77 20 68 65 69 67 68 74 0a 20 |ter row height. | 000004a0 20 20 43 2b 46 6e 39 20 20 20 20 3a 20 4e 65 77 | C+Fn9 : New| 000004b0 20 76 69 65 77 0a 20 20 20 53 2b 43 2b 46 6e 33 | view. S+C+Fn3| 000004c0 20 20 3a 20 53 61 76 65 20 61 73 20 44 72 61 77 | : Save as Draw| 000004d0 0a 20 20 20 46 6e 31 30 20 20 20 20 20 3a 20 4c |. Fn10 : L| 000004e0 6f 63 6b 20 63 65 6c 6c 73 0a 20 20 20 46 6e 31 |ock cells. Fn1| 000004f0 31 20 20 20 20 20 3a 20 48 69 64 65 20 63 65 6c |1 : Hide cel| 00000500 6c 73 0a 20 20 20 53 2b 46 6e 31 30 20 20 20 3a |ls. S+Fn10 :| 00000510 20 55 6e 6c 6f 63 6b 20 63 65 6c 6c 73 0a 20 20 | Unlock cells. | 00000520 20 53 2b 46 6e 31 31 20 20 20 3a 20 55 6e 68 69 | S+Fn11 : Unhi| 00000530 64 65 20 63 65 6c 6c 73 0a 20 20 20 53 2b 43 2b |de cells. S+C+| 00000540 46 6e 31 31 20 3a 20 52 65 76 65 72 74 20 74 6f |Fn11 : Revert to| 00000550 20 73 61 76 65 64 0a 20 20 20 4c 65 66 74 20 20 | saved. Left | 00000560 20 20 20 3a 20 4d 6f 76 65 20 63 75 72 73 6f 72 | : Move cursor| 00000570 20 6c 65 66 74 0a 20 20 20 52 69 67 68 74 20 20 | left. Right | 00000580 20 20 3a 20 4d 6f 76 65 20 63 75 72 73 6f 72 20 | : Move cursor | 00000590 72 69 67 68 74 0a 20 20 20 44 6f 77 6e 20 20 20 |right. Down | 000005a0 20 20 3a 20 4d 6f 76 65 20 63 75 72 73 6f 72 20 | : Move cursor | 000005b0 64 6f 77 6e 0a 20 20 20 55 70 20 20 20 20 20 20 |down. Up | 000005c0 20 3a 20 4d 6f 76 65 20 63 75 72 73 6f 72 20 75 | : Move cursor u| 000005d0 70 0a 20 20 20 43 2b 4c 65 66 74 20 20 20 3a 20 |p. C+Left : | 000005e0 4d 6f 76 65 20 63 75 72 73 6f 72 20 74 6f 20 6c |Move cursor to l| 000005f0 65 66 74 6d 6f 73 74 20 63 6f 6c 75 6d 6e 0a 20 |eftmost column. | 00000600 20 20 43 2b 52 69 67 68 74 20 20 3a 20 4d 6f 76 | C+Right : Mov| 00000610 65 20 63 75 72 73 6f 72 20 74 6f 20 72 69 67 68 |e cursor to righ| 00000620 74 6d 6f 73 74 20 63 6f 6c 75 6d 6e 0a 20 20 20 |tmost column. | 00000630 43 2b 44 6f 77 6e 20 20 20 3a 20 4d 6f 76 65 20 |C+Down : Move | 00000640 63 75 72 73 6f 72 20 62 6f 74 74 6f 6d 20 72 6f |cursor bottom ro| 00000650 77 0a 20 20 20 43 2b 55 70 20 20 20 20 20 3a 20 |w. C+Up : | 00000660 4d 6f 76 65 20 63 75 72 73 6f 72 20 74 6f 70 20 |Move cursor top | 00000670 72 6f 77 0a 20 20 20 43 74 72 6c 2b 27 55 27 20 |row. Ctrl+'U' | 00000680 3a 20 45 64 69 74 20 63 65 6c 6c 20 66 72 6f 6d |: Edit cell from| 00000690 20 65 6d 70 74 79 0a 20 20 20 42 61 63 6b 73 70 | empty. Backsp| 000006a0 61 63 65 3a 20 45 64 69 74 20 63 65 6c 6c 2c 20 |ace: Edit cell, | 000006b0 64 65 6c 65 74 69 6e 67 20 6c 61 73 74 20 63 68 |deleting last ch| 000006c0 61 72 0a 20 20 20 44 65 6c 65 74 65 20 20 20 3a |ar. Delete :| 000006d0 20 45 64 69 74 20 63 65 6c 6c 2c 20 64 65 6c 65 | Edit cell, dele| 000006e0 74 69 6e 67 20 6c 61 73 74 20 63 68 61 72 0a 0a |ting last char..| 000006f0 32 29 20 54 68 65 20 66 6f 6c 6c 6f 77 69 6e 67 |2) The following| 00000700 20 73 70 65 63 69 61 6c 20 63 6f 64 65 20 73 65 | special code se| 00000710 71 75 65 6e 63 65 73 20 63 61 6e 20 62 65 20 75 |quences can be u| 00000720 73 65 64 20 69 6e 20 6e 75 6d 65 72 69 63 20 66 |sed in numeric f| 00000730 6f 72 6d 61 74 20 73 74 72 69 6e 67 73 0a 20 20 |ormat strings. | 00000740 20 69 6e 20 74 68 65 20 6e 75 6d 65 72 69 63 20 | in the numeric | 00000750 66 6f 6d 61 74 20 73 65 63 74 69 6f 6e 20 6f 66 |fomat section of| 00000760 20 74 68 65 20 63 65 6c 6c 20 73 74 79 6c 65 20 | the cell style | 00000770 65 64 69 74 6f 72 2e 0a 20 20 20 0a 20 20 20 23 |editor.. . #| 00000780 23 20 20 3d 20 27 23 27 0a 20 20 20 23 6e 6e 20 |# = '#'. #nn | 00000790 3a 20 42 65 73 74 20 72 65 70 72 65 73 65 6e 74 |: Best represent| 000007a0 61 74 69 6f 6e 20 77 69 74 68 20 6e 3d 31 2d 39 |ation with n=1-9| 000007b0 20 77 68 65 72 65 20 73 63 69 65 6e 74 69 66 69 | where scientifi| 000007c0 63 20 66 6f 72 6d 20 75 73 65 64 20 77 68 65 6e |c form used when| 000007d0 20 65 78 70 3e 6e 0a 20 20 20 23 66 6e 20 3a 20 | exp>n. #fn : | 000007e0 46 69 78 65 64 20 70 6f 69 6e 74 20 77 69 74 68 |Fixed point with| 000007f0 20 6e 3d 30 2d 39 20 64 69 67 69 74 73 20 61 66 | n=0-9 digits af| 00000800 74 65 72 20 70 6f 69 6e 74 0a 20 20 20 23 73 6e |ter point. #sn| 00000810 20 3a 20 53 63 69 65 6e 74 69 66 69 63 20 77 69 | : Scientific wi| 00000820 74 68 20 6e 3d 30 2d 39 20 64 69 67 69 74 73 20 |th n=0-9 digits | 00000830 61 66 74 65 72 20 70 6f 69 6e 74 0a 20 20 20 23 |after point. #| 00000840 48 30 20 3a 20 48 6f 75 72 73 20 69 6e 20 74 69 |H0 : Hours in ti| 00000850 6d 65 0a 20 20 20 23 48 31 20 3a 20 61 73 20 48 |me. #H1 : as H| 00000860 30 20 62 75 74 20 69 6e 20 32 34 20 68 6f 75 72 |0 but in 24 hour| 00000870 20 63 6c 6f 63 6b 20 77 69 74 68 20 6c 65 61 64 | clock with lead| 00000880 69 6e 67 20 30 0a 20 20 20 23 50 20 20 3a 20 61 |ing 0. #P : a| 00000890 6d 2f 70 6d 0a 20 20 20 23 6d 30 20 3a 20 4d 69 |m/pm. #m0 : Mi| 000008a0 6e 75 74 65 73 20 77 69 74 68 20 6c 65 61 64 69 |nutes with leadi| 000008b0 6e 67 20 30 0a 20 20 20 23 6d 31 20 3a 20 4d 69 |ng 0. #m1 : Mi| 000008c0 6e 75 74 65 73 20 77 69 74 68 6f 75 74 20 6c 65 |nutes without le| 000008d0 61 64 69 6e 67 20 30 0a 20 20 20 23 53 30 20 3a |ading 0. #S0 :| 000008e0 20 53 65 63 6f 6e 64 73 20 77 69 74 68 20 6c 65 | Seconds with le| 000008f0 61 64 69 6e 67 20 30 0a 20 20 20 23 53 31 20 3a |ading 0. #S1 :| 00000900 20 53 65 63 6f 6e 64 73 20 77 69 74 68 6f 75 74 | Seconds without| 00000910 20 6c 65 61 64 69 6e 67 20 30 0a 20 20 20 23 44 | leading 0. #D| 00000920 30 20 3a 20 44 61 79 20 77 69 74 68 20 6c 65 61 |0 : Day with lea| 00000930 64 69 6e 67 20 30 0a 20 20 20 23 44 31 20 3a 20 |ding 0. #D1 : | 00000940 44 61 79 20 77 69 74 68 6f 75 74 20 6c 65 61 64 |Day without lead| 00000950 69 6e 67 20 30 0a 20 20 20 23 4f 20 20 3a 20 6f |ing 0. #O : o| 00000960 72 64 69 6e 61 6c 20 28 74 68 2f 6e 64 2f 73 74 |rdinal (th/nd/st| 00000970 20 6f 66 20 64 61 74 65 29 0a 20 20 20 23 4d 30 | of date). #M0| 00000980 20 3a 20 4d 6f 6e 74 68 20 61 73 20 6e 75 6d 62 | : Month as numb| 00000990 65 72 0a 20 20 20 23 4d 31 20 3a 20 4d 6f 6e 74 |er. #M1 : Mont| 000009a0 68 20 61 73 20 6e 61 6d 65 0a 20 20 20 23 4d 32 |h as name. #M2| 000009b0 20 3a 20 4d 6f 6e 74 68 20 61 73 20 74 68 72 65 | : Month as thre| 000009c0 65 20 63 68 61 72 61 63 74 65 72 20 6e 61 6d 65 |e character name| 000009d0 0a 20 20 20 23 59 30 20 3a 20 59 65 61 72 2c 20 |. #Y0 : Year, | 000009e0 34 20 64 69 67 69 74 73 0a 20 20 20 23 59 31 20 |4 digits. #Y1 | 000009f0 3a 20 59 65 61 72 2c 20 32 20 64 69 67 69 74 73 |: Year, 2 digits| 00000a00 0a 0a 33 29 20 54 68 65 20 68 65 61 64 65 72 20 |..3) The header | 00000a10 61 6e 64 20 66 6f 6f 74 65 72 20 66 69 65 6c 64 |and footer field| 00000a20 73 20 6f 66 20 74 68 65 20 70 72 69 6e 74 20 64 |s of the print d| 00000a30 69 61 6c 6f 67 75 65 20 62 6f 78 20 63 61 6e 20 |ialogue box can | 00000a40 63 6f 6e 74 61 69 6e 20 74 68 65 73 65 0a 20 20 |contain these. | 00000a50 20 73 70 65 63 69 61 6c 20 66 69 65 6c 64 73 3a | special fields:| 00000a60 0a 20 20 20 0a 20 20 20 23 66 20 3a 20 46 69 6c |. . #f : Fil| 00000a70 65 20 6c 65 61 66 6e 61 6d 65 20 20 20 20 20 20 |e leafname | 00000a80 20 20 20 20 3a 20 41 63 63 6f 75 6e 74 73 31 0a | : Accounts1.| 00000a90 20 20 20 23 46 20 3a 20 46 69 6c 65 20 66 75 6c | #F : File ful| 00000aa0 6c 20 70 61 74 68 6e 61 6d 65 20 20 20 20 20 3a |l pathname :| 00000ab0 20 41 44 46 53 3a 3a 48 61 72 64 44 69 73 63 34 | ADFS::HardDisc4| 00000ac0 2e 24 2e 4f 66 66 69 63 65 2e 41 63 63 6f 75 6e |.$.Office.Accoun| 00000ad0 74 73 31 0a 20 20 20 23 50 20 3a 20 50 61 67 65 |ts1. #P : Page| 00000ae0 20 6e 75 6d 62 65 72 20 20 20 20 20 20 20 20 20 | number | 00000af0 20 20 20 3a 20 34 0a 20 20 20 23 70 20 3a 20 41 | : 4. #p : A| 00000b00 73 20 23 50 20 20 20 20 20 20 20 20 20 20 20 20 |s #P | 00000b10 20 20 20 20 20 20 3a 20 34 0a 20 20 20 23 54 20 | : 4. #T | 00000b20 3a 20 32 34 20 68 6f 75 72 20 74 69 6d 65 20 20 |: 24 hour time | 00000b30 20 20 20 20 20 20 20 20 20 3a 20 31 35 3a 31 31 | : 15:11| 00000b40 3a 32 32 0a 20 20 20 23 74 20 3a 20 31 32 20 68 |:22. #t : 12 h| 00000b50 6f 75 72 20 74 69 6d 65 20 20 20 20 20 20 20 20 |our time | 00000b60 20 20 20 3a 20 33 3a 31 31 70 6d 0a 20 20 20 23 | : 3:11pm. #| 00000b70 44 20 3a 20 44 61 74 65 20 69 6e 20 73 68 6f 72 |D : Date in shor| 00000b80 74 20 66 6f 72 6d 20 20 20 20 20 3a 20 32 36 74 |t form : 26t| 00000b90 68 20 46 65 62 20 31 39 39 34 0a 20 20 20 23 64 |h Feb 1994. #d| 00000ba0 20 3a 20 44 61 74 65 20 69 6e 20 6c 6f 6e 67 20 | : Date in long | 00000bb0 66 6f 72 6d 20 20 20 20 20 20 3a 20 53 61 74 2c |form : Sat,| 00000bc0 20 32 36 74 68 20 46 65 62 72 75 61 72 79 20 31 | 26th February 1| 00000bd0 39 39 34 0a 20 20 20 0a 34 29 20 43 61 6c 63 75 |994. .4) Calcu| 00000be0 6c 61 74 69 6f 6e 73 20 6f 6e 20 63 65 6c 6c 20 |lations on cell | 00000bf0 72 61 6e 67 65 73 20 63 61 6e 6e 6f 74 20 62 65 |ranges cannot be| 00000c00 20 70 65 72 66 6f 72 6d 65 64 20 69 6e 20 74 68 | performed in th| 00000c10 69 73 20 76 65 72 73 69 6f 6e 20 6f 66 20 48 6f |is version of Ho| 00000c20 6d 65 57 6f 72 6b 73 20 20 20 20 53 70 72 65 61 |meWorks Sprea| 00000c30 64 53 68 65 65 74 2e 20 54 68 69 73 20 63 61 6e |dSheet. This can| 00000c40 20 62 65 20 61 63 68 69 65 76 65 64 20 62 79 20 | be achieved by | 00000c50 6c 69 73 74 69 6e 67 20 69 6e 64 69 76 69 64 75 |listing individu| 00000c60 61 6c 20 63 65 6c 6c 73 20 69 6e 20 66 6f 72 6d |al cells in form| 00000c70 75 6c 61 65 0a 20 20 20 65 67 2e 0a 20 20 20 0a |ulae. eg.. .| 00000c80 20 20 20 20 20 3d 53 54 44 45 56 50 28 41 31 3a | =STDEVP(A1:| 00000c90 42 33 29 0a 20 20 20 20 20 0a 20 20 20 62 65 63 |B3). . bec| 00000ca0 6f 6d 65 73 0a 20 20 20 0a 20 20 20 20 20 3d 53 |omes. . =S| 00000cb0 54 44 45 56 50 28 41 31 2c 41 32 2c 41 33 2c 42 |TDEVP(A1,A2,A3,B| 00000cc0 31 2c 42 32 2c 42 33 29 0a 20 20 20 20 20 0a 35 |1,B2,B3). .5| 00000cd0 29 20 4f 6e 6c 79 20 61 62 6f 75 74 20 31 2f 33 |) Only about 1/3| 00000ce0 20 6f 66 20 74 68 65 20 70 6c 61 6e 6e 65 64 20 | of the planned | 00000cf0 66 75 6e 63 74 69 6f 6e 73 20 69 73 20 69 6d 70 |functions is imp| 00000d00 6c 65 6d 65 6e 74 65 64 2e 20 49 6e 20 74 68 65 |lemented. In the| 00000d10 20 66 75 6e 63 74 69 6f 6e 0a 20 20 20 62 72 6f | function. bro| 00000d20 77 73 65 72 2c 20 74 68 65 73 65 20 61 72 65 20 |wser, these are | 00000d30 6c 69 73 74 65 64 20 69 6e 20 67 72 65 79 2e 20 |listed in grey. | 00000d40 46 75 6e 63 74 69 6f 6e 73 20 69 6e 20 62 6c 61 |Functions in bla| 00000d50 63 6b 20 61 72 65 20 61 76 61 69 6c 61 62 6c 65 |ck are available| 00000d60 0a 20 20 20 74 68 6f 75 67 68 2e 20 48 65 6c 70 |. though. Help| 00000d70 20 6f 6e 20 66 75 6e 63 74 69 6f 6e 73 20 63 61 | on functions ca| 00000d80 6e 20 62 65 20 66 6f 75 6e 64 20 62 79 20 74 6f |n be found by to| 00000d90 67 67 6c 69 6e 67 20 74 68 65 20 66 75 6e 63 74 |ggling the funct| 00000da0 69 6f 6e 20 62 72 6f 77 73 65 72 0a 20 20 20 74 |ion browser. t| 00000db0 6f 20 66 75 6c 6c 20 73 69 7a 65 2e 20 42 61 73 |o full size. Bas| 00000dc0 69 63 20 6f 70 65 72 61 74 6f 72 73 20 2b 2c 20 |ic operators +, | 00000dd0 2f 2c 20 2a 2c 20 61 6e 64 20 2d 20 61 72 65 20 |/, *, and - are | 00000de0 61 76 61 69 6c 61 62 6c 65 20 64 69 72 65 63 74 |available direct| 00000df0 6c 79 2e 20 2b 0a 20 20 20 61 6e 64 20 2d 20 61 |ly. +. and - a| 00000e00 72 65 20 61 76 61 69 6c 61 62 6c 65 20 69 6e 20 |re available in | 00000e10 62 6f 74 68 20 6d 6f 6e 61 64 69 63 20 61 6e 64 |both monadic and| 00000e20 20 64 79 61 64 69 63 20 66 6f 72 6d 73 2e 20 42 | dyadic forms. B| 00000e30 72 61 63 6b 65 74 73 20 61 72 65 0a 20 20 20 61 |rackets are. a| 00000e40 76 61 69 6c 61 62 6c 65 20 74 6f 20 6f 76 65 72 |vailable to over| 00000e50 72 69 64 65 20 70 72 65 63 65 64 65 6e 63 65 20 |ride precedence | 00000e60 77 68 69 63 68 20 69 73 20 74 68 65 20 73 74 61 |which is the sta| 00000e70 6e 64 61 72 64 20 66 6f 72 6d 20 6f 66 20 66 75 |ndard form of fu| 00000e80 6e 63 74 69 6f 6e 73 0a 20 20 20 74 68 65 6e 20 |nctions. then | 00000e90 6d 75 6c 74 69 70 6c 69 63 61 74 69 6f 6e 20 6f |multiplication o| 00000ea0 70 65 72 61 74 6f 72 73 20 74 68 65 6e 20 61 64 |perators then ad| 00000eb0 64 69 74 69 6f 6e 20 6f 70 65 72 61 74 6f 72 73 |dition operators| 00000ec0 20 74 68 65 6e 20 6c 6f 67 69 63 20 6f 70 65 72 | then logic oper| 00000ed0 61 74 6f 72 73 2e 0a 20 20 20 54 68 65 20 6c 6f |ators.. The lo| 00000ee0 67 69 63 61 6c 20 6f 70 65 72 61 74 6f 72 73 20 |gical operators | 00000ef0 3d 2c 20 3c 2c 20 3e 2c 20 3e 3d 2c 20 3c 3d 20 |=, <, >, >=, <= | 00000f00 61 6e 64 20 3c 3e 20 28 6e 6f 74 20 65 71 75 61 |and <> (not equa| 00000f10 6c 20 74 6f 29 20 61 72 65 20 61 6c 73 6f 0a 20 |l to) are also. | 00000f20 20 20 61 76 61 69 6c 61 62 6c 65 2e 20 46 6f 72 | available. For| 00000f30 6d 75 6c 61 65 20 62 65 67 69 6e 6e 69 6e 67 20 |mulae beginning | 00000f40 77 69 74 68 20 61 20 64 69 67 69 74 20 2b 2c 20 |with a digit +, | 00000f50 6f 72 20 2d 2c 20 61 72 65 20 65 76 61 6c 75 61 |or -, are evalua| 00000f60 74 65 64 2e 20 41 0a 20 20 20 6c 65 61 64 69 6e |ted. A. leadin| 00000f70 67 20 3d 20 77 69 6c 6c 20 66 6f 72 63 65 20 61 |g = will force a| 00000f80 20 66 6f 72 6d 75 6c 61 20 74 6f 20 62 65 20 65 | formula to be e| 00000f90 76 61 6c 75 61 74 65 64 20 69 6e 20 63 61 73 65 |valuated in case| 00000fa0 20 69 74 20 73 74 61 72 74 73 20 77 69 74 68 0a | it starts with.| 00000fb0 20 20 20 73 6f 6d 65 20 6f 74 68 65 72 20 63 68 | some other ch| 00000fc0 61 72 61 63 74 65 72 2e 20 41 6e 79 20 6f 74 68 |aracter. Any oth| 00000fd0 65 72 20 66 6f 72 6d 75 6c 61 20 69 73 20 74 72 |er formula is tr| 00000fe0 65 61 74 65 64 20 61 73 20 74 65 78 74 2e 0a 20 |eated as text.. | 00000ff0 20 20 0a 36 29 20 43 65 6c 6c 20 72 65 66 65 72 | .6) Cell refer| 00001000 65 6e 63 65 73 20 61 72 65 20 6f 66 20 74 68 65 |ences are of the| 00001010 20 73 74 61 6e 64 61 72 64 20 3c 63 6f 6c 75 6d | standard <colum| 00001020 6e 2d 6e 61 6d 65 3e 3c 72 6f 77 2d 6e 75 6d 62 |n-name><row-numb| 00001030 65 72 3e 20 66 6f 72 6d 61 74 0a 20 20 20 61 6e |er> format. an| 00001040 20 27 40 27 20 63 68 61 72 61 63 74 65 72 20 63 | '@' character c| 00001050 61 6e 20 62 65 20 75 73 65 64 20 74 6f 20 6f 76 |an be used to ov| 00001060 65 72 72 69 64 65 20 74 68 65 20 61 64 6a 75 73 |erride the adjus| 00001070 74 6d 65 6e 74 20 6f 66 20 72 65 66 65 72 65 6e |tment of referen| 00001080 63 65 73 0a 20 20 20 74 68 61 74 20 6f 63 63 75 |ces. that occu| 00001090 72 73 20 64 75 72 69 6e 67 20 66 69 6c 6c 20 61 |rs during fill a| 000010a0 6e 64 20 70 61 73 74 65 20 6f 70 65 72 61 74 69 |nd paste operati| 000010b0 6f 6e 73 2c 20 28 74 68 6f 75 67 68 20 69 74 20 |ons, (though it | 000010c0 77 69 6c 6c 20 6e 6f 74 20 62 65 0a 20 20 20 72 |will not be. r| 000010d0 65 67 61 72 64 65 64 20 69 6e 20 63 6f 6c 6d 6e |egarded in colmn| 000010e0 20 6f 72 20 72 6f 77 20 69 6e 73 65 72 74 69 6f | or row insertio| 000010f0 6e 20 6f 70 65 72 61 74 69 6f 6e 73 29 2e 0a 20 |n operations).. | 00001100 20 20 0a 20 20 20 49 6e 20 74 68 65 20 66 6f 6c | . In the fol| 00001110 6c 6f 77 69 6e 67 20 65 78 61 6d 70 6c 65 73 20 |lowing examples | 00001120 69 6d 61 67 69 6e 65 20 74 68 61 74 20 74 68 65 |imagine that the| 00001130 20 63 6f 6e 74 65 6e 74 73 20 6f 66 20 63 65 6c | contents of cel| 00001140 6c 20 43 33 20 68 61 76 65 0a 20 20 20 62 65 65 |l C3 have. bee| 00001150 6e 20 75 73 65 64 20 69 6e 20 61 20 66 69 6c 6c |n used in a fill| 00001160 20 6f 70 65 72 61 74 69 6f 6e 20 61 6e 64 20 74 | operation and t| 00001170 68 65 20 72 65 73 75 6c 74 20 69 6e 20 44 34 20 |he result in D4 | 00001180 69 73 20 73 68 6f 77 6e 3a 0a 20 20 20 0a 20 20 |is shown:. . | 00001190 20 43 33 20 20 20 20 20 20 20 20 20 20 20 20 20 | C3 | 000011a0 20 20 20 20 20 44 34 0a 20 20 20 0a 20 20 20 3d | D4. . =| 000011b0 48 38 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |H8 | 000011c0 20 20 20 3d 49 39 0a 20 20 20 3d 40 48 38 20 20 | =I9. =@H8 | 000011d0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 3d 40 | =@| 000011e0 48 39 0a 20 20 20 3d 48 40 38 20 20 20 20 20 20 |H9. =H@8 | 000011f0 20 20 20 20 20 20 20 20 20 20 3d 49 40 38 0a 20 | =I@8. | 00001200 20 20 3d 40 48 40 38 20 20 20 20 20 20 20 20 20 | =@H@8 | 00001210 20 20 20 20 20 20 3d 40 48 40 38 0a 0a 37 29 20 | =@H@8..7) | 00001220 45 6d 70 74 79 20 63 65 6c 6c 73 20 61 72 65 20 |Empty cells are | 00001230 61 6c 77 61 79 73 20 69 6e 74 65 72 70 72 65 74 |always interpret| 00001240 65 64 20 61 73 20 7a 65 72 6f 20 76 61 6c 75 65 |ed as zero value| 00001250 73 20 69 6e 20 74 68 69 73 20 76 65 72 73 69 6f |s in this versio| 00001260 6e 20 6f 66 0a 20 20 20 48 6f 6d 65 57 6f 72 6b |n of. HomeWork| 00001270 73 20 53 70 72 65 61 64 73 68 65 65 74 2e 0a 20 |s Spreadsheet.. | 00001280 20 20 0a 38 29 20 54 68 65 20 73 74 79 6c 65 20 | .8) The style | 00001290 69 6e 20 77 68 69 63 68 20 74 68 65 20 68 65 61 |in which the hea| 000012a0 64 65 72 73 20 61 6e 64 20 66 6f 6f 74 65 72 73 |ders and footers| 000012b0 20 6f 66 20 61 20 64 6f 63 75 6d 65 6e 74 20 61 | of a document a| 000012c0 72 65 20 70 72 69 6e 74 65 64 20 63 61 6e 0a 20 |re printed can. | 000012d0 20 20 62 65 20 73 65 74 20 65 78 70 6c 69 63 69 | be set explici| 000012e0 74 6c 79 2e 20 4e 6f 72 6d 61 6c 6c 79 2c 20 74 |tly. Normally, t| 000012f0 68 65 20 66 69 72 73 74 20 73 74 79 6c 65 20 66 |he first style f| 00001300 6f 75 6e 64 20 69 73 20 75 73 65 64 2c 20 62 75 |ound is used, bu| 00001310 74 20 69 66 20 73 74 79 6c 65 73 0a 20 20 20 6e |t if styles. n| 00001320 61 6d 65 64 20 27 48 65 61 64 65 72 27 20 6f 72 |amed 'Header' or| 00001330 20 27 46 6f 6f 74 65 72 27 20 61 72 65 20 66 6f | 'Footer' are fo| 00001340 75 6e 64 2c 20 74 68 65 73 65 20 77 69 6c 6c 20 |und, these will | 00001350 62 65 20 75 73 65 64 20 69 6e 73 74 65 61 64 2e |be used instead.| 00001360 20 4e 6f 74 65 0a 20 20 20 74 68 61 74 20 6f 6e | Note. that on| 00001370 6c 79 20 74 65 78 74 20 66 6f 6e 74 20 73 69 7a |ly text font siz| 00001380 65 20 61 6e 64 20 73 74 79 6c 65 20 61 72 65 20 |e and style are | 00001390 72 65 63 6f 67 6e 69 73 65 64 2e 20 4b 65 72 6e |recognised. Kern| 000013a0 69 6e 67 2c 20 75 6e 64 65 72 6c 69 6e 69 6e 67 |ing, underlining| 000013b0 2c 0a 20 20 20 63 6f 6c 6f 75 72 73 20 61 6e 64 |,. colours and| 000013c0 20 6a 75 73 74 69 66 69 63 61 74 69 6f 6e 20 6d | justification m| 000013d0 61 79 20 62 65 20 72 65 63 6f 67 6e 69 73 65 64 |ay be recognised| 000013e0 20 69 6e 20 66 75 74 75 72 65 20 76 65 72 73 69 | in future versi| 000013f0 6f 6e 73 2e 0a 20 20 20 0a 39 29 20 50 72 69 6e |ons.. .9) Prin| 00001400 74 69 6e 67 20 61 74 20 63 65 72 74 61 69 6e 20 |ting at certain | 00001410 73 63 61 6c 65 73 20 6c 65 73 73 20 74 68 61 6e |scales less than| 00001420 20 31 30 30 25 20 63 61 6e 20 63 61 75 73 65 20 | 100% can cause | 00001430 74 68 65 20 65 64 67 65 20 6f 66 20 72 69 67 68 |the edge of righ| 00001440 74 0a 20 20 20 6a 75 73 74 69 66 69 65 64 20 74 |t. justified t| 00001450 65 78 74 20 74 6f 20 62 65 20 6c 6f 73 74 20 73 |ext to be lost s| 00001460 6c 69 67 68 74 6c 79 2e 20 54 68 69 73 20 69 73 |lightly. This is| 00001470 20 6e 6f 74 20 61 20 6d 61 6a 6f 72 20 70 72 6f | not a major pro| 00001480 62 6c 65 6d 20 61 6e 64 0a 20 20 20 63 61 6e 20 |blem and. can | 00001490 75 73 75 61 6c 6c 79 20 62 65 20 72 65 6d 65 64 |usually be remed| 000014a0 69 65 64 20 62 79 20 70 72 69 6e 74 69 6e 67 20 |ied by printing | 000014b0 61 74 20 61 20 73 6c 69 67 68 74 6c 79 20 73 6d |at a slightly sm| 000014c0 61 6c 6c 65 72 20 6f 72 20 6c 61 72 67 65 72 0a |aller or larger.| 000014d0 20 20 20 73 63 61 6c 65 2e 0a 20 20 20 0a 4e 4f | scale.. .NO| 000014e0 54 45 3a 20 48 6f 6d 65 57 6f 72 6b 73 20 77 69 |TE: HomeWorks wi| 000014f0 6c 6c 20 6e 6f 74 20 72 75 6e 20 63 6f 72 72 65 |ll not run corre| 00001500 63 74 6c 79 20 6f 6e 20 61 20 77 72 69 74 65 20 |ctly on a write | 00001510 70 72 6f 74 65 63 74 65 64 20 64 69 73 63 2e 20 |protected disc. | 00001520 20 20 0a 0a 4b 6e 6f 77 6e 20 70 72 6f 62 6c 65 | ..Known proble| 00001530 6d 73 3a 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |ms:.------------| 00001540 2d 2d 2d 0a 0a 56 65 72 79 20 6c 6f 6e 67 20 6e |---..Very long n| 00001550 75 6d 62 65 72 73 20 63 61 6e 20 63 61 75 73 65 |umbers can cause| 00001560 20 63 72 61 73 68 65 73 20 77 68 65 6e 20 65 6e | crashes when en| 00001570 74 65 72 65 64 20 69 6e 20 74 6f 20 74 68 65 20 |tered in to the | 00001580 73 68 65 65 74 2c 20 73 6f 20 61 76 6f 69 64 0a |sheet, so avoid.| 00001590 65 6e 74 65 72 69 6e 67 20 6e 75 6d 62 65 72 73 |entering numbers| 000015a0 20 77 69 74 68 20 76 65 72 79 20 6d 61 6e 79 20 | with very many | 000015b0 64 69 67 69 74 73 2e 0a 0a 50 72 69 6e 74 69 6e |digits...Printin| 000015c0 67 20 62 79 20 64 72 61 67 67 69 6e 67 20 66 72 |g by dragging fr| 000015d0 6f 6d 20 74 68 65 20 73 61 76 65 20 62 6f 78 20 |om the save box | 000015e0 64 6f 65 73 20 6e 6f 74 20 77 6f 72 6b 2e 20 50 |does not work. P| 000015f0 72 69 6e 74 20 61 20 73 70 72 65 61 64 73 68 65 |rint a spreadshe| 00001600 65 74 0a 64 6f 63 75 6d 65 6e 74 20 62 79 20 75 |et.document by u| 00001610 73 69 6e 67 20 74 68 65 20 70 72 69 6e 74 20 64 |sing the print d| 00001620 69 61 6c 6f 67 75 65 20 62 6f 78 2c 20 6f 72 20 |ialogue box, or | 00001630 64 72 61 67 67 69 6e 67 20 69 74 20 66 72 6f 6d |dragging it from| 00001640 20 61 20 66 69 6c 65 72 0a 77 69 6e 64 6f 77 20 | a filer.window | 00001650 64 69 72 65 63 74 6c 79 20 74 6f 20 61 20 70 72 |directly to a pr| 00001660 69 6e 74 65 72 20 69 6e 73 74 65 61 64 2e 0a 0a |inter instead...| 00001670 49 66 20 61 20 73 70 72 65 61 64 73 68 65 65 74 |If a spreadsheet| 00001680 20 69 73 20 64 69 73 70 6c 61 79 65 64 20 77 68 | is displayed wh| 00001690 69 63 68 20 68 61 73 20 6d 61 6e 79 20 63 65 6c |ich has many cel| 000016a0 6c 73 20 77 68 69 63 68 20 68 61 76 65 20 74 65 |ls which have te| 000016b0 78 74 20 6f 76 65 72 66 6c 6f 77 69 6e 67 2c 0a |xt overflowing,.| 000016c0 6d 75 63 68 20 6f 66 20 69 74 20 77 6f 6e 27 74 |much of it won't| 000016d0 20 61 70 70 65 61 72 2e 20 55 73 65 20 61 20 73 | appear. Use a s| 000016e0 6d 61 6c 6c 65 72 20 66 6f 6e 74 20 6f 72 20 77 |maller font or w| 000016f0 69 64 65 6e 20 74 68 65 20 63 65 6c 6c 73 20 74 |iden the cells t| 00001700 6f 20 65 6e 61 62 6c 65 20 69 74 0a 74 6f 20 62 |o enable it.to b| 00001710 65 20 64 69 73 70 6c 61 79 65 64 2e 0a 0a 54 68 |e displayed...Th| 00001720 65 20 70 61 73 74 65 20 69 63 6f 6e 20 69 6e 20 |e paste icon in | 00001730 74 68 65 20 62 75 74 74 6f 6e 20 62 61 72 20 69 |the button bar i| 00001740 73 20 6e 6f 74 20 75 6e 67 72 65 79 65 64 20 69 |s not ungreyed i| 00001750 6e 20 77 69 6e 64 6f 77 73 20 77 68 69 63 68 20 |n windows which | 00001760 61 72 65 20 6f 70 65 6e 0a 77 68 65 6e 20 74 68 |are open.when th| 00001770 65 20 66 69 72 73 74 20 43 75 74 20 6f 72 20 43 |e first Cut or C| 00001780 6f 70 79 20 6f 70 65 72 61 74 69 6f 6e 20 69 73 |opy operation is| 00001790 20 70 65 72 66 6f 72 6d 65 64 20 69 6e 20 61 6e | performed in an| 000017a0 6f 74 68 65 72 20 77 69 6e 64 6f 77 2e 20 54 68 |other window. Th| 000017b0 65 79 0a 61 72 65 20 6e 6f 74 20 75 6e 67 72 65 |ey.are not ungre| 000017c0 79 65 64 20 77 68 65 6e 20 6d 65 6d 6f 72 79 20 |yed when memory | 000017d0 72 65 73 74 72 69 63 74 69 6f 6e 73 20 63 61 75 |restrictions cau| 000017e0 73 65 20 74 68 65 20 63 6c 69 70 62 6f 61 72 64 |se the clipboard| 000017f0 20 74 6f 20 62 65 20 63 6c 65 61 72 65 64 2e 0a | to be cleared..| 00001800 55 73 65 20 74 68 65 20 6d 65 6e 75 20 6f 72 20 |Use the menu or | 00001810 6b 65 79 20 5e 56 20 69 66 20 74 68 65 20 69 63 |key ^V if the ic| 00001820 6f 6e 20 69 73 20 77 72 6f 6e 67 6c 79 20 67 72 |on is wrongly gr| 00001830 65 79 65 64 20 6f 75 74 2e 0a |eyed out..| 0000183a
.