• converting spreadsheets for OS X

    From Sawney Beane@XXbeadle@qwickconnect.net to comp.sys.mac.system on Friday, April 07, 2006 16:01:56
    From Newsgroup: comp.sys.mac.system

    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.

    ClarisWorks5 is a way to save the documents so that AppleWorks can open
    them in OS X. Claris will open Excel 4 spreadsheets under the Classic environment in the new computer, but I have trouble saving them as
    Claris spreadsheets. In a batch I converted yesterday, they would save
    if I opened them through the Claris application, but if I opened them by clicking the document and choosing Claris, saving would cause an error 48.

    Today, saving in Claris brings an error 48 no matter which way I open
    them. What could be wrong?


    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?
    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From Ilgaz Ocal@ilgaz_ocal@yahoo.com to comp.sys.mac.system on Friday, April 07, 2006 23:10:42
    From Newsgroup: comp.sys.mac.system

    On 2006-04-07 23:01:56 +0300, Sawney Beane <XXbeadle@qwickconnect.net> said:

    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.

    I say if you can , export them to CSV format. It is the universal
    format for spreadsheets.

    It is "comma seperated value"

    You can than use anything to open them.

    Workbooks can be tricky, there should be a way to make CSV of each
    individual workbook.

    BTW looking to "Carbon errors", -48 is "duplicate filename (rename)"

    (you can get carbon errors for os x from http://www.clamxav.com )

    Ilgaz

    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From TaliesinSoft@taliesinsoft@mac.com to comp.sys.mac.system on Friday, April 07, 2006 15:22:58
    From Newsgroup: comp.sys.mac.system

    On Fri, 7 Apr 2006 15:10:42 -0500, Ilgaz Ocal wrote
    (in article <49nv9vFotggoU1@individual.net>):

    I say if you can , export them to CSV format. It is the universal
    format for spreadsheets.

    It is "comma seperated value"

    If available I prefer tab separated over comma separated as it is relatively common for a comma to be a character within a field, not normally so with tabs.

    --
    James Leo Ryan ..... Austin, Texas ..... taliesinsoft@mac.com

    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From see_signature@see_signature@mac.com.invalid (Jon) to comp.sys.mac.system on Friday, April 07, 2006 22:23:04
    From Newsgroup: comp.sys.mac.system

    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.

    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.

    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.
    --
    /Jon
    For mail address, run the following in Terminal:
    echo 36199371860304980107073482417748002696458P|dc
    Skype: storhaugen
    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From Sawney Beane@XXbeadle@qwickconnect.net to comp.sys.mac.system on Friday, April 07, 2006 18:09:20
    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
  • From nonesuch@nonesuch@place.com (Adrian) to comp.sys.mac.system on Friday, April 07, 2006 23:40:05
    From Newsgroup: comp.sys.mac.system

    Sawney Beane <XXbeadle@qwickconnect.net> wrote:

    ClarisWorks5 is a way to save the documents so that AppleWorks can open
    them in OS X. Claris will open Excel 4 spreadsheets under the Classic environment in the new computer, but I have trouble saving them as
    Claris spreadsheets. In a batch I converted yesterday, they would save
    if I opened them through the Claris application, but if I opened them by clicking the document and choosing Claris, saving would cause an error 48.

    I always found that saving as SYLK enabled extremely good transfers
    between Clarisworks4 and Excel. Unfortunately by Appleworks 6 the SYLK
    option is no longer available.

    --
    Adrian
    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From Tim McNamara@timmcn@bitstream.net to comp.sys.mac.system on Friday, April 07, 2006 18:00:50
    From Newsgroup: comp.sys.mac.system

    In article <1hdg3co.jfyj8cunirrhN%see_signature@mac.com.invalid>,
    see_signature@mac.com.invalid (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.

    Or for that matter, NeoOffice which is an OS X port of OpenOffice.org.

    http://www.neooffice.org

    Works great and doesn't feed the Evil Empire.
    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From Michelle Steiner@michelle@michelle.org to comp.sys.mac.system on Friday, April 07, 2006 19:44:10
    From Newsgroup: comp.sys.mac.system

    In article <e16nvf$5phn$1@news3.infoave.net>,
    Sawney Beane <XXbeadle@qwickconnect.net> wrote:

    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.

    You can reinstall it from the install disk that came with the computer,
    or you can download it from Microsoft.

    <http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/d ownload/office2004/office2004.xml&secid=4&ssid=1&flgnosysreq=True>

    --
    Stop Mad Cowboy Disease: Impeach the son of a Bush.
    --- Synchronet 3.18b-Win32 NewsLink 1.113
  • From Sawney Beane@XXbeadle@qwickconnect.net to comp.sys.mac.system on Friday, April 07, 2006 23:16:53
    From Newsgroup: comp.sys.mac.system

    Tim McNamara wrote:
    In article <1hdg3co.jfyj8cunirrhN%see_signature@mac.com.invalid>,
    see_signature@mac.com.invalid (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.

    Or for that matter, NeoOffice which is an OS X port of OpenOffice.org.

    http://www.neooffice.org

    Works great and doesn't feed the Evil Empire.
    Thanks for the reminder. I'll have access to DSL next week.
    --- Synchronet 3.18b-Win32 NewsLink 1.113