This discussion is locked
-
All replies
-
Helpful answers
Previous
Page
2
-
Sep 3, 2009 8:47 AM in response to John Cowanby Peggy,I think as systems are updated we are going to see more & more problems like these with AppleWorks. That your AppleWorks files can be opened is good & it's time to look into other options for more "modern" software. Take a look at Roger Wilmut's web pages for a lot of very useful information on moving on from AppleWorks.
From a post by dwb:The easy part is getting the data from an AW database into Numbers. In AW, switch to List View, select all, and then copy. Open an AW spreadsheet, place your cursor in cell A2 and paste. Your data is now in a spreadsheet and you can use row 1 to enter your field names. I saved this file as a Mac Excel file and it opened in Numbers just fine - I'm guessing saving as an AW6 spreadsheet would also work.
Now that the data is in Numbers comes the hard part. The data is there and you can use Find to find a specific person or thing but you don't have the nice looking reports that AW's database gave you. Also, if you had been performing calculations, these are gone and will have to be re-established. The calculation part is pretty simple usually, after all, Numbers is a spreadsheet. The reports are a bit more challenging. Look at the VLookup and HLookup formulas - they should be helpful. Look through the Numbers templates for ideas too.
I have found that copying & pasting from list view in an AppleWorks database to a Numbers table will retain any formatting that you might lose by saving first as an AppleWorks spreadsheet.
Message was edited by: Peggy -
Sep 8, 2009 12:45 PM in response to John Cowanby Dave Robertson2,I'm finding AW works fine under SL except when merging databases to documents, I find that sometimes crashes AW. But the problem is somewhat murky at the moment because I was experimenting with 64-bit bootup prior to using mailmerge and I'm unsure whether I'm back in 32-bit! I'm trying to deal with that in another thread.
Can anyone confirm whether multiple page merges from custom databases are working properly using the default SL startup? I use the save in a new document option.
Thanks,
Dave -
Sep 14, 2009 4:36 PM in response to a brodyby travelguy,I just installed the Appleworks updater, 6.2.9 in a new macbook pro. I also installed Rosetta.
I still can't get any Appleworks document to open. Can you help me? -
Sep 14, 2009 5:54 PM in response to travelguyby Peggy,From my earlier post in this thread:Whenever you do an update, it's a good idea to do two maintenance tasks, one for the system (Repair Permissions) and one for AppleWorks (delete preferences). (Thanks to Barry for this way to format this very common answer.)
To Repair permissions, launch Disk Utility, found in the Utilities folder in your Applications folder, click on First Aid, then on Repair Permissions.
To delete AppleWorks’ preference files, go to HD > Users > (your account) > Library > Preferences. Find and delete the file com.apple.appleworks.plist. Find and open the folder AppleWorks in this Preferences folder, then delete all of the enclosed files (with the exception of the Button Bar Preferences if you have customized the Button Bars). AppleWorks will recreate the preference files as it needs them.
-
Sep 14, 2009 6:45 PM in response to Dave Robertson2by Dave Robertson2,Just a follow up, once I identified and removed a problematic font my AW issues resolved. -
Sep 15, 2009 5:53 AM in response to Dave Robertson2by KOENIG Yvan,May you tell us which was the font.
I wish to open a thread listing the offending ones.
Yvan KOENIG (VALLAURIS, France) mardi 15 septembre 2009 14:53:52 -
Sep 15, 2009 8:55 AM in response to KOENIG Yvanby Dave Robertson2,Postscript Type 1 v of Conran Script. There's a thread discussing lack of SL support for PS1 fonts generally although I don't know how to link to it. I have some that seem to be fine though and in this case replacing it with a TrueType version fixed the problem.
Dave -
Sep 17, 2009 10:21 AM in response to Dave Robertson2by KOENIG Yvan,Oops, I missed your responce.
Thanks for the feedback.
Yvan KOENIG (VALLAURIS, France) jeudi 17 septembre 2009 19:21:07 -
Oct 20, 2009 5:53 AM in response to KOENIG Yvanby macmerrilee,I was also worried about running Appleworks as I have used it for the 15 years I have been computing and at 80 I don't want to have to buy iWorks and learn how to use it. Most interesting discussion. Thanks everyone.