Re: AppleWorks help?

[a2mg@aol.comNomail (A2MG)]

Here is a catalog of the AppleWorks 2.0 5.25" disk.  Ignore Catalyst Desktop.
You don't need it.  The catalog listing below is probably askew, but if you put
it into a font like Courier, it should line up somewhat.

Directory: /APPLEWORKS/               Page 1             16-Dec-02   5:10:05 PM

Filename                     Blocks Type   Modified    Created  Length Auxtype

PRODOS_______________   30  SYS  16-Jun-86  18-Apr-86   $3A00   $2000
CATALYSTDESKTOP___ __   6  TXT  28-Jun-85  25-Jun-86    $900 R=$0100
SEG.00______________         9  SYS  16-Jun-86  28-Apr-86    $FD7   $0000
SEG.XM_____________         9  SYS  16-Jun-86  28-Apr-86    $F5C   $0000
SEG.RM______________       9  SYS  16-Jun-86  10-Jun-86    $F49   $0000
SEG.EL_______________     12  BIN  16-Jun-86  18-Apr-86   $1600 A=$D000
APLWORKS.SYSTEM____   18  SYS  16-Jun-86  17-Jun-86   $2156   $0000

Blocks free................180
Blocks used................100
Blocks in directory.........93
Total blocks...............280
Number of standard files.....7
Number of subdirectories.....0

Directory: /APPLEWORKS/               Page 1             16-Dec-02   5:09:06 PM

Filename                     Blocks Type   Modified    Created  Length Auxtype

SEG.M0______________   46  NON  10-Jun-86  10-Jun-86   $5967   $0000
SEG.M1______________  219  NON  10-Jun-86  10-Jun-86  $1B275   $0000
SEG.PR_______________    9  SYS  16-Jun-86  10-Jun-86    $E56   $0000

Blocks free..................2
Blocks used................278
Blocks in directory........274
Total blocks...............280
Number of standard files.....3
Number of subdirectories.....0

There was also a special thing where AppleWorks 2.x original disks were
formatted in a speical way, allowing more useful disk space. I have an
excellent article about it here somewhere, but it will take me hours to dig it
out. If someone else can explain that unusual disk situation, it woud be good
(and interesting).

On the copying a spreadsheet formula problem:

Later versions of AppleWorks, starting with v3.0, allowed you to copy formulas
from the clipboard as either (a) Formulas and values, or (b) Values only.  So
the easy solution is to upgrade to AppleWorks 3.0. I can do this for you if you
can show me an original disk of AppleWorks, any version.

There may be some clever workarounds, which I will leave to others to figure
out. 

There was a program called CelLink, now freeware (part of TimeOut PowerPack),
which would import cells from other spreadsheets without going by way of the
clipboard.  Likewise, another program called Block Copy, from TimeOut
SpreadTools, allowed copying values only. Not sure if this is freeware. It's by
Alan Bird.

On the Pesky Y2K question: Y2K solutions for AppleWorks (all versions) have
been around since 1998; I know, because I wrote most of the fixes myself.  To
fix the known problems in any version, I need to ask you:

- Do you know how to patch a file using AppleSoft BASIC?
- Do you know how to patch a file using ProSel's Block Warden (ZAP)?

If the answer of both of those is no, then you'll have to mail me a disk
(backup copy, no originals), and I will fix it for you.

If you plan on doing bookkeeping, I would upgrade to a later version.
AppleWorks 5.1 is the latest and last version, but you need extra memory and a
hard drive or 2 3.5" disks. I used to do all my TEXAS II orders on AppleWorks
5.1 data bases (not spreadsheets), automatically spitting out data to mailing
lists, address labels, and all sorts of other cool stuff. It was very
sophistacated and I wouldn't attempt to duplicate it for someone else.

Beverly Cadieux 
TEXAS II an international newsletter for users of AppleWorks(R) 5.1