From Newsgroup: comp.sys.mac.system
Jon wrote:
Sawney Beane <XXbeadle@qwickconnect.net> wrote:
In Classic, I have Excel 4 spreadsheets that I've created over many
years. I'm moving to a new computer with OS X and a Classic environment.
First: Why not use Excel on Mac OS X? It is still the king of
spreadsheets apps and should open your old Excel sheets with no trouble
at all, including formulae and functions.
Now that you mention it, that would be a good idea. I wish I'd thought
of that before I threw the trial version of Office 2004 into the trash.
Saving as CSV as someone suggested will not retain the formulae and functions, only the numerical values in the cell when you do the save.
I tried it and I agree with you. Excel 4 offers other options. So does Claris. I'll have to check the web for an explanation of what they are
and what extensions I may have to append for OS X.
Anyway, going back to my old computer and saving them there as Claris documents, then transferring them worked. I've noticed that if I copy a
16k Claris document to my OSX disk, then open and save as an Appleworks document, it's 60k. I've also noticed that if I download an
application, it expands similarly when I move it to my Applications
folder. I wonder why.
On my old computer, it would be handy to use Sherlock 2 to find Excel
files so I can convert them. Sherlock has a place for Creator, but OS 9 doesn't seem to present that information to the user.
ClarisWorks5 is a way to save the documents so that AppleWorks can open
them in OS X.
<snip>
Also, I've found workbooks of Excel worksheets. I can't find Excel
Help, and I created the workbooks so long ago that I can't remember how
to use Excel to make them back into individual worksheets so I can open
them with Claris. Where can I find out?
You can right-click (or Ctrl-click) on the tab for a worksheet and copy
or move it to a new workbook. That should do the trick. Might be a bit
of work if there are many sheets, though.
I'll try that. I made my last workbook ten years ago. Now when I open
them in Classic, all I see is one worksheet. I'll look for tabs.
--- Synchronet 3.18b-Win32 NewsLink 1.113