6189 Views 7 Replies Latest reply: Apr 9, 2009 2:34 AM by KOENIG Yvan
This thread has a couple of suggestions as to where to buy it:
However: I agree with you that AppleWorks is one of the most remarkable computer programs ever written: easy to use, surprisingly powerful, small footprint, inexpensive. I've been using it for 16 years and have a big investment in databases and WP documents etc.
But: I would hesitate to recommend anyone to start using it now. It is no longer supported by Apple: and though in fact it works very well on Leopard, no-one knows how long it will survive system updates. It's a PPC program, and so depends on Rosetta: this may or may not be included with future versions of OSX. You might be OK in two years time and find in five years time that a new computer won't run it. Or it might - no-one knows. But to start committing yourself to it now may be short-sighted.
The problem is finding a replacement. Pages isn't bad, though it won't do everything the WP module of AW will. It can open AW WP documents, and even some draw documents (with a little fiddling about): Numbers will open AW spreadsheets but a few Functions aren't included. It's not possible to embed a spreadsheet in a Pages document as you can in an AW WP document.
The real problem is the database. Bento is a very simple database for inexperienced users and can't remotely approach the power of the AW DB module. FileMaker Pro can't actually import AW databases, though you can import the data (losing layouts and functions in the process): I don't know whether you can achieve everything that AW can, though very possibly you can - however the program is a professional product and is very expensive. The database in Open Office is a nightmare. There are a few others about, but I'll bet you can't come anywhere near the power of the AW database.
But to re-itereate: Appleworks works fine now. In a very few years time it may or may not, and you should think hard before investing effort in it.
Roger Wilmut1 wrote:
It's not possible to embed a spreadsheet in a Pages document as you can in an AW WP document.
We may perfectly embed a spreadsheet in Pages: it's named "table" but it has the same structure than Numbers tables.
The drawback are that we can't use checkboxes, popups, sliders and steppers
and that in Pages a table is restricted to 65 columns.
Yvan KOENIG (from FRANCE lundi 6 avril 2009 22:06:15)
"Does it indeed act like a spreadsheet (as do spreadsheet frames in AppleWorks)? - so that you can, for example sum a column? - if so it's more useful than I thought."
This is from Chapter 9 of the Pages '09 Users Guide:
Use formulas and functions in table cells. For more information about this topic,
choose Help > “iWork Formulas and Functions Help” or Help > “iWork Formulas and
Functions User Guide.”
Some functions, I think, were available in Pages '08; more are available in '09.
Chapter 10 of the Guide tells how to make charts using numeric data in Tables in Pages.
I'm so busy with the import script than I missed your question.
Tables in Pages are true spreadsheets.
Alas there are seriously restrained.
- no more than 65 columns
- no external references between tables
- no checkbox, popup, stepper and slider
Yvan KOENIG (from FRANCE mercredi 8 avril 2009 19:08:33)