I have a spreadsheet created in Appleworks on my old iMac and wonder if this could be transferred to my newest iMac in Numbers whilst retaining all the entries which go back around 15 years?
Can Appleworks save as Excel (.xls)? Numbers can read that and you should get most of your spreadsheet intact.
Worst case is probably CSV (.csv for comma separated variables). That should get your data over but you will lose all your formatting and, I suspect, all your formulae :-(
There may be some third-party converters otherwise.
Many thanks Tony. Saving as .xis did the trick. Opened on the newest iMac in Numbers, complete with formatting and formulae. (after emailing it across as an attachment). Allows me to input new data. Amazing, I should have done it years ago. Your reply is much appreciated, thanks again. Roy
Many of my spreadsheets were Appleworks / Clarisworks versions. They came across ok and filed as cwk files. If I wanted to open them I selected "open with numbers" and lo and behold it did . Then I saved the numbers version and kept or ditched the cwk version when happy. Formulae still ok.
I have just tried opening such an historic cwk spreadsheet (which candidly I have no further use for but which as yet memory usage/ machine speed doesn't press me to ditch) and it performs as described above.
Give it a try ? ( If you had any Appleworks Drawing documents that are still important to you , I think you needed to convert them first to WP documents before transferring them as cwk files which then can be opened in Pages. Again I see some old WP cwk documents I filed away which I know started life as Drawings).
Thank you John. Following your comments and similar ones emailed to me by another member, I tried it and it works!!! Why I didn't try that before I don't know. I assumed that Appleworks was so old that newish Numbers wouldn't open it. I live and learn. Thanks again. Roy
Roy Rainford 