Home » Archimedes archive » Archimedes World » AW-1995-04-Disc1.adf » Disk1Apr95 » !AWApr95/Goodies/SpreadSht/Coversion
!AWApr95/Goodies/SpreadSht/Coversion
This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.
Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.
| Tape/disk: | Home » Archimedes archive » Archimedes World » AW-1995-04-Disc1.adf » Disk1Apr95 |
| Filename: | !AWApr95/Goodies/SpreadSht/Coversion |
| Read OK: | ✔ |
| File size: | 08A2 bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
{
define style "Normal";
font Trinity.Medium;
fontsize 12pt;
linespacep 120%;
spaceabove 0pt;
spacebelow 0pt;
leftmargin 1.8pt;
rightmargin 0pt;
returnmargin 1.8pt;
condframethrow 0pt;
fontaspect 100%;
fontcolour rgb=(0,0,0);
linecolour rgb=(0,0,0);
rulecolour rgb=(0,0,0);
justify left;
underline 0;
strikeout off;
scriptsize 0%;
scriptoffset 0% 0%;
script off;
hyphenate off;
leader "";
locktolinespace off;
italic off;
bold off;
ruleaboveoffset 0pt;
rulecontrol 0;
vertrulewidth 1pt;
ruleleftmargin 0pt;
rulerightmargin 0pt;
rulewidth 0pt;
ruleoffset 0pt;
tracking 0;
overprintb off;
dectabchar ".";
keepparagraph off;
keepnext off;
keepregion off;
autoindent off;
linesize 0%;
lineoffset 0%;
tabs 72pt,144pt,216pt,288pt,360pt,432pt,504pt,576pt,648pt;
menuitem off}{
define style "Main Heading";
font Homerton.Bold;
fontsize 20pt;
linespacep 120%;
contents 1;
autoparagraph;
shortcut 385;
menuitem on}{
define style "Sub-Heading";
font Homerton.Medium;
fontsize 16pt;
linespacep 120%;
contents 2;
autoparagraph;
shortcut 386;
menuitem on}{
define style "1in indent";
leftmargin 72pt;
rightmargin 0pt;
returnmargin 72pt;
autoparagraph;
shortcut 393;
tabs 144pt,216pt,288pt,360pt,432pt,504pt,576pt;
menuitem on}{
define style "Hanging indent";
leftmargin 72pt;
rightmargin 0pt;
returnmargin 48pt;
autoparagraph;
shortcut 458;
tabs 72pt,144pt,216pt,288pt,360pt,432pt,504pt,576pt;
menuitem on}{
define style "Table";
leftmargin 70.9pt;
rightmargin 0pt;
returnmargin 70.9pt;
rulecolour rgb=(0,0,0);
ruleaboveoffset 1pt;
rulecontrol 6;
vertrulewidth 1pt;
ruleleftmargin 57.5pt;
rulerightmargin 467.7pt;
rulewidth 1pt;
ruleoffset -1pt;
autoparagraph;
shortcut 459;
tabs vertrule 56.7pt,vertrule 155.9pt,170.1pt,vertrule 255.1pt,269.3pt,vertrule 354.3pt,368.5pt,vertrule 467.7pt;
menuitem on}When loading a Lotus 1-2-3 compatible file into your spreadsheet the number and formulas are saved but not te cell format. In Cash and Month all the non-text cells are defined as two decimal place currency and in Ageallow the first two cells following the Born Before caption are dates containing 6 Apr 1929 and 6 Apr 1919 respectively.
00000000 7b 0a 64 65 66 69 6e 65 20 73 74 79 6c 65 20 22 |{.define style "|
00000010 4e 6f 72 6d 61 6c 22 3b 0a 20 66 6f 6e 74 20 54 |Normal";. font T|
00000020 72 69 6e 69 74 79 2e 4d 65 64 69 75 6d 3b 0a 20 |rinity.Medium;. |
00000030 66 6f 6e 74 73 69 7a 65 20 31 32 70 74 3b 0a 20 |fontsize 12pt;. |
00000040 6c 69 6e 65 73 70 61 63 65 70 20 31 32 30 25 3b |linespacep 120%;|
00000050 0a 20 73 70 61 63 65 61 62 6f 76 65 20 30 70 74 |. spaceabove 0pt|
00000060 3b 0a 20 73 70 61 63 65 62 65 6c 6f 77 20 30 70 |;. spacebelow 0p|
00000070 74 3b 0a 20 6c 65 66 74 6d 61 72 67 69 6e 20 31 |t;. leftmargin 1|
00000080 2e 38 70 74 3b 0a 20 72 69 67 68 74 6d 61 72 67 |.8pt;. rightmarg|
00000090 69 6e 20 30 70 74 3b 0a 20 72 65 74 75 72 6e 6d |in 0pt;. returnm|
000000a0 61 72 67 69 6e 20 31 2e 38 70 74 3b 0a 20 63 6f |argin 1.8pt;. co|
000000b0 6e 64 66 72 61 6d 65 74 68 72 6f 77 20 30 70 74 |ndframethrow 0pt|
000000c0 3b 0a 20 66 6f 6e 74 61 73 70 65 63 74 20 31 30 |;. fontaspect 10|
000000d0 30 25 3b 0a 20 66 6f 6e 74 63 6f 6c 6f 75 72 20 |0%;. fontcolour |
000000e0 72 67 62 3d 28 30 2c 30 2c 30 29 3b 0a 20 6c 69 |rgb=(0,0,0);. li|
000000f0 6e 65 63 6f 6c 6f 75 72 20 72 67 62 3d 28 30 2c |necolour rgb=(0,|
00000100 30 2c 30 29 3b 0a 20 72 75 6c 65 63 6f 6c 6f 75 |0,0);. rulecolou|
00000110 72 20 72 67 62 3d 28 30 2c 30 2c 30 29 3b 0a 20 |r rgb=(0,0,0);. |
00000120 6a 75 73 74 69 66 79 20 6c 65 66 74 3b 0a 20 75 |justify left;. u|
00000130 6e 64 65 72 6c 69 6e 65 20 30 3b 0a 20 73 74 72 |nderline 0;. str|
00000140 69 6b 65 6f 75 74 20 6f 66 66 3b 0a 20 73 63 72 |ikeout off;. scr|
00000150 69 70 74 73 69 7a 65 20 30 25 3b 0a 20 73 63 72 |iptsize 0%;. scr|
00000160 69 70 74 6f 66 66 73 65 74 20 30 25 20 30 25 3b |iptoffset 0% 0%;|
00000170 0a 20 73 63 72 69 70 74 20 6f 66 66 3b 0a 20 68 |. script off;. h|
00000180 79 70 68 65 6e 61 74 65 20 6f 66 66 3b 0a 20 6c |yphenate off;. l|
00000190 65 61 64 65 72 20 22 22 3b 0a 20 6c 6f 63 6b 74 |eader "";. lockt|
000001a0 6f 6c 69 6e 65 73 70 61 63 65 20 6f 66 66 3b 0a |olinespace off;.|
000001b0 20 69 74 61 6c 69 63 20 6f 66 66 3b 0a 20 62 6f | italic off;. bo|
000001c0 6c 64 20 6f 66 66 3b 0a 20 72 75 6c 65 61 62 6f |ld off;. ruleabo|
000001d0 76 65 6f 66 66 73 65 74 20 30 70 74 3b 0a 20 72 |veoffset 0pt;. r|
000001e0 75 6c 65 63 6f 6e 74 72 6f 6c 20 30 3b 0a 20 76 |ulecontrol 0;. v|
000001f0 65 72 74 72 75 6c 65 77 69 64 74 68 20 31 70 74 |ertrulewidth 1pt|
00000200 3b 0a 20 72 75 6c 65 6c 65 66 74 6d 61 72 67 69 |;. ruleleftmargi|
00000210 6e 20 30 70 74 3b 0a 20 72 75 6c 65 72 69 67 68 |n 0pt;. rulerigh|
00000220 74 6d 61 72 67 69 6e 20 30 70 74 3b 0a 20 72 75 |tmargin 0pt;. ru|
00000230 6c 65 77 69 64 74 68 20 30 70 74 3b 0a 20 72 75 |lewidth 0pt;. ru|
00000240 6c 65 6f 66 66 73 65 74 20 30 70 74 3b 0a 20 74 |leoffset 0pt;. t|
00000250 72 61 63 6b 69 6e 67 20 30 3b 0a 20 6f 76 65 72 |racking 0;. over|
00000260 70 72 69 6e 74 62 20 6f 66 66 3b 0a 20 64 65 63 |printb off;. dec|
00000270 74 61 62 63 68 61 72 20 22 2e 22 3b 0a 20 6b 65 |tabchar ".";. ke|
00000280 65 70 70 61 72 61 67 72 61 70 68 20 6f 66 66 3b |epparagraph off;|
00000290 0a 20 6b 65 65 70 6e 65 78 74 20 6f 66 66 3b 0a |. keepnext off;.|
000002a0 20 6b 65 65 70 72 65 67 69 6f 6e 20 6f 66 66 3b | keepregion off;|
000002b0 0a 20 61 75 74 6f 69 6e 64 65 6e 74 20 6f 66 66 |. autoindent off|
000002c0 3b 0a 20 6c 69 6e 65 73 69 7a 65 20 30 25 3b 0a |;. linesize 0%;.|
000002d0 20 6c 69 6e 65 6f 66 66 73 65 74 20 30 25 3b 0a | lineoffset 0%;.|
000002e0 20 74 61 62 73 20 37 32 70 74 2c 31 34 34 70 74 | tabs 72pt,144pt|
000002f0 2c 32 31 36 70 74 2c 32 38 38 70 74 2c 33 36 30 |,216pt,288pt,360|
00000300 70 74 2c 34 33 32 70 74 2c 35 30 34 70 74 2c 35 |pt,432pt,504pt,5|
00000310 37 36 70 74 2c 36 34 38 70 74 3b 0a 20 6d 65 6e |76pt,648pt;. men|
00000320 75 69 74 65 6d 20 6f 66 66 7d 7b 0a 64 65 66 69 |uitem off}{.defi|
00000330 6e 65 20 73 74 79 6c 65 20 22 4d 61 69 6e 20 48 |ne style "Main H|
00000340 65 61 64 69 6e 67 22 3b 0a 20 66 6f 6e 74 20 48 |eading";. font H|
00000350 6f 6d 65 72 74 6f 6e 2e 42 6f 6c 64 3b 0a 20 66 |omerton.Bold;. f|
00000360 6f 6e 74 73 69 7a 65 20 32 30 70 74 3b 0a 20 6c |ontsize 20pt;. l|
00000370 69 6e 65 73 70 61 63 65 70 20 31 32 30 25 3b 0a |inespacep 120%;.|
00000380 20 63 6f 6e 74 65 6e 74 73 20 31 3b 0a 20 61 75 | contents 1;. au|
00000390 74 6f 70 61 72 61 67 72 61 70 68 3b 0a 20 73 68 |toparagraph;. sh|
000003a0 6f 72 74 63 75 74 20 33 38 35 3b 0a 20 6d 65 6e |ortcut 385;. men|
000003b0 75 69 74 65 6d 20 6f 6e 7d 7b 0a 64 65 66 69 6e |uitem on}{.defin|
000003c0 65 20 73 74 79 6c 65 20 22 53 75 62 2d 48 65 61 |e style "Sub-Hea|
000003d0 64 69 6e 67 22 3b 0a 20 66 6f 6e 74 20 48 6f 6d |ding";. font Hom|
000003e0 65 72 74 6f 6e 2e 4d 65 64 69 75 6d 3b 0a 20 66 |erton.Medium;. f|
000003f0 6f 6e 74 73 69 7a 65 20 31 36 70 74 3b 0a 20 6c |ontsize 16pt;. l|
00000400 69 6e 65 73 70 61 63 65 70 20 31 32 30 25 3b 0a |inespacep 120%;.|
00000410 20 63 6f 6e 74 65 6e 74 73 20 32 3b 0a 20 61 75 | contents 2;. au|
00000420 74 6f 70 61 72 61 67 72 61 70 68 3b 0a 20 73 68 |toparagraph;. sh|
00000430 6f 72 74 63 75 74 20 33 38 36 3b 0a 20 6d 65 6e |ortcut 386;. men|
00000440 75 69 74 65 6d 20 6f 6e 7d 7b 0a 64 65 66 69 6e |uitem on}{.defin|
00000450 65 20 73 74 79 6c 65 20 22 31 69 6e 20 69 6e 64 |e style "1in ind|
00000460 65 6e 74 22 3b 0a 20 6c 65 66 74 6d 61 72 67 69 |ent";. leftmargi|
00000470 6e 20 37 32 70 74 3b 0a 20 72 69 67 68 74 6d 61 |n 72pt;. rightma|
00000480 72 67 69 6e 20 30 70 74 3b 0a 20 72 65 74 75 72 |rgin 0pt;. retur|
00000490 6e 6d 61 72 67 69 6e 20 37 32 70 74 3b 0a 20 61 |nmargin 72pt;. a|
000004a0 75 74 6f 70 61 72 61 67 72 61 70 68 3b 0a 20 73 |utoparagraph;. s|
000004b0 68 6f 72 74 63 75 74 20 33 39 33 3b 0a 20 74 61 |hortcut 393;. ta|
000004c0 62 73 20 31 34 34 70 74 2c 32 31 36 70 74 2c 32 |bs 144pt,216pt,2|
000004d0 38 38 70 74 2c 33 36 30 70 74 2c 34 33 32 70 74 |88pt,360pt,432pt|
000004e0 2c 35 30 34 70 74 2c 35 37 36 70 74 3b 0a 20 6d |,504pt,576pt;. m|
000004f0 65 6e 75 69 74 65 6d 20 6f 6e 7d 7b 0a 64 65 66 |enuitem on}{.def|
00000500 69 6e 65 20 73 74 79 6c 65 20 22 48 61 6e 67 69 |ine style "Hangi|
00000510 6e 67 20 69 6e 64 65 6e 74 22 3b 0a 20 6c 65 66 |ng indent";. lef|
00000520 74 6d 61 72 67 69 6e 20 37 32 70 74 3b 0a 20 72 |tmargin 72pt;. r|
00000530 69 67 68 74 6d 61 72 67 69 6e 20 30 70 74 3b 0a |ightmargin 0pt;.|
00000540 20 72 65 74 75 72 6e 6d 61 72 67 69 6e 20 34 38 | returnmargin 48|
00000550 70 74 3b 0a 20 61 75 74 6f 70 61 72 61 67 72 61 |pt;. autoparagra|
00000560 70 68 3b 0a 20 73 68 6f 72 74 63 75 74 20 34 35 |ph;. shortcut 45|
00000570 38 3b 0a 20 74 61 62 73 20 37 32 70 74 2c 31 34 |8;. tabs 72pt,14|
00000580 34 70 74 2c 32 31 36 70 74 2c 32 38 38 70 74 2c |4pt,216pt,288pt,|
00000590 33 36 30 70 74 2c 34 33 32 70 74 2c 35 30 34 70 |360pt,432pt,504p|
000005a0 74 2c 35 37 36 70 74 3b 0a 20 6d 65 6e 75 69 74 |t,576pt;. menuit|
000005b0 65 6d 20 6f 6e 7d 7b 0a 64 65 66 69 6e 65 20 73 |em on}{.define s|
000005c0 74 79 6c 65 20 22 54 61 62 6c 65 22 3b 0a 20 6c |tyle "Table";. l|
000005d0 65 66 74 6d 61 72 67 69 6e 20 37 30 2e 39 70 74 |eftmargin 70.9pt|
000005e0 3b 0a 20 72 69 67 68 74 6d 61 72 67 69 6e 20 30 |;. rightmargin 0|
000005f0 70 74 3b 0a 20 72 65 74 75 72 6e 6d 61 72 67 69 |pt;. returnmargi|
00000600 6e 20 37 30 2e 39 70 74 3b 0a 20 72 75 6c 65 63 |n 70.9pt;. rulec|
00000610 6f 6c 6f 75 72 20 72 67 62 3d 28 30 2c 30 2c 30 |olour rgb=(0,0,0|
00000620 29 3b 0a 20 72 75 6c 65 61 62 6f 76 65 6f 66 66 |);. ruleaboveoff|
00000630 73 65 74 20 31 70 74 3b 0a 20 72 75 6c 65 63 6f |set 1pt;. ruleco|
00000640 6e 74 72 6f 6c 20 36 3b 0a 20 76 65 72 74 72 75 |ntrol 6;. vertru|
00000650 6c 65 77 69 64 74 68 20 31 70 74 3b 0a 20 72 75 |lewidth 1pt;. ru|
00000660 6c 65 6c 65 66 74 6d 61 72 67 69 6e 20 35 37 2e |leleftmargin 57.|
00000670 35 70 74 3b 0a 20 72 75 6c 65 72 69 67 68 74 6d |5pt;. rulerightm|
00000680 61 72 67 69 6e 20 34 36 37 2e 37 70 74 3b 0a 20 |argin 467.7pt;. |
00000690 72 75 6c 65 77 69 64 74 68 20 31 70 74 3b 0a 20 |rulewidth 1pt;. |
000006a0 72 75 6c 65 6f 66 66 73 65 74 20 2d 31 70 74 3b |ruleoffset -1pt;|
000006b0 0a 20 61 75 74 6f 70 61 72 61 67 72 61 70 68 3b |. autoparagraph;|
000006c0 0a 20 73 68 6f 72 74 63 75 74 20 34 35 39 3b 0a |. shortcut 459;.|
000006d0 20 74 61 62 73 20 76 65 72 74 72 75 6c 65 20 35 | tabs vertrule 5|
000006e0 36 2e 37 70 74 2c 76 65 72 74 72 75 6c 65 20 31 |6.7pt,vertrule 1|
000006f0 35 35 2e 39 70 74 2c 31 37 30 2e 31 70 74 2c 76 |55.9pt,170.1pt,v|
00000700 65 72 74 72 75 6c 65 20 32 35 35 2e 31 70 74 2c |ertrule 255.1pt,|
00000710 32 36 39 2e 33 70 74 2c 76 65 72 74 72 75 6c 65 |269.3pt,vertrule|
00000720 20 33 35 34 2e 33 70 74 2c 33 36 38 2e 35 70 74 | 354.3pt,368.5pt|
00000730 2c 76 65 72 74 72 75 6c 65 20 34 36 37 2e 37 70 |,vertrule 467.7p|
00000740 74 3b 0a 20 6d 65 6e 75 69 74 65 6d 20 6f 6e 7d |t;. menuitem on}|
00000750 57 68 65 6e 20 6c 6f 61 64 69 6e 67 20 61 20 4c |When loading a L|
00000760 6f 74 75 73 20 31 2d 32 2d 33 20 63 6f 6d 70 61 |otus 1-2-3 compa|
00000770 74 69 62 6c 65 20 66 69 6c 65 20 69 6e 74 6f 20 |tible file into |
00000780 79 6f 75 72 20 73 70 72 65 61 64 73 68 65 65 74 |your spreadsheet|
00000790 20 74 68 65 20 6e 75 6d 62 65 72 20 61 6e 64 20 | the number and |
000007a0 66 6f 72 6d 75 6c 61 73 20 61 72 65 20 73 61 76 |formulas are sav|
000007b0 65 64 20 62 75 74 20 6e 6f 74 20 74 65 20 63 65 |ed but not te ce|
000007c0 6c 6c 20 66 6f 72 6d 61 74 2e 20 49 6e 20 43 61 |ll format. In Ca|
000007d0 73 68 20 61 6e 64 20 4d 6f 6e 74 68 20 61 6c 6c |sh and Month all|
000007e0 20 74 68 65 20 6e 6f 6e 2d 74 65 78 74 20 63 65 | the non-text ce|
000007f0 6c 6c 73 20 61 72 65 20 64 65 66 69 6e 65 64 20 |lls are defined |
00000800 61 73 20 74 77 6f 20 64 65 63 69 6d 61 6c 20 70 |as two decimal p|
00000810 6c 61 63 65 20 63 75 72 72 65 6e 63 79 20 61 6e |lace currency an|
00000820 64 20 69 6e 20 41 67 65 61 6c 6c 6f 77 20 74 68 |d in Ageallow th|
00000830 65 20 66 69 72 73 74 20 74 77 6f 20 63 65 6c 6c |e first two cell|
00000840 73 20 66 6f 6c 6c 6f 77 69 6e 67 20 74 68 65 20 |s following the |
00000850 42 6f 72 6e 20 42 65 66 6f 72 65 20 63 61 70 74 |Born Before capt|
00000860 69 6f 6e 20 61 72 65 20 64 61 74 65 73 20 63 6f |ion are dates co|
00000870 6e 74 61 69 6e 69 6e 67 20 36 20 41 70 72 20 31 |ntaining 6 Apr 1|
00000880 39 32 39 20 61 6e 64 20 36 20 41 70 72 20 31 39 |929 and 6 Apr 19|
00000890 31 39 20 72 65 73 70 65 63 74 69 76 65 6c 79 2e |19 respectively.|
000008a0 0a 0a |..|
000008a2 
.