Importing ClarisWorks 5 spreadsheets [UK Mac]

Prev: Why isn't the iSlate destined to be a failure?
Next: T-Mobile/Chitter Chatter iPhone deal

From: David Empson on 26 Jan 2010 04:04

From: Gareth John on 26 Jan 2010 04:13

David Empson <dempson(a)actrix.gen.nz> wrote:

> Gareth John <g.john(a)PLUG.btinternet.com> wrote:
>
> > Gareth John <g.john(a)PLUG.btinternet.com> wrote:
> >
> > > Debbie Wilson <djmaizels(a)mac.com> wrote:
> > >
> > > > Does anyone who uses iWork know if you can directly open or import
> > > > Claris Works 5 spreadsheets in Numbers without loss of cell formatting,
> > > > calcuations etc? I really need to get my (very simple) tax spreadsheets
> > > > into an OSX program, it's stupid firing up Classic once a year just for
> > > > these - but want to avoid any mess-ups in the process!
> > >
> > > Gulp. On 25th January, It sounds like you're leaving things later than
> > > even I'm comfortable with...
> > >
> > > Does exporting the CW5 sheets to SYLK format help? Excel, at least can
> > > import those, with formulas, but Numbers I don't know.
> >
> > Doh!
> >
> > Scratch that. I just checked with the two versions I've got available,
> > and neither CW4 nor AppleWorks 6 will save as SYLK. So presumably CW%
> > won't either.
>
> AppleWorks 6 can save as SYLK, IF you run it in Mac OS 9. It has a lot
> more translators available than when running in Mac OS X.
>
> AppleWorks 5 can also save as SYLK. (I've done it.) ClarisWorks 5 should
> be identical.
>
> Numbers doesn't appear to be able to sensibly import SYLK files (despite
> taking ownership of that extension), but Excel can, as you noted.

Ah, that's a relief. I wasn't dreaming, then. In my haste I had only
tried CW4 (not CW5) under Classic, and AW6 under OSX.

But it still sounds as though Debbie will need to go via Excel to
Numbers.

G.
--
From Gareth John
Please pull out the plug if you want to reply by email

From: David Empson on 26 Jan 2010 05:29

Gareth John <g.john(a)PLUG.btinternet.com> wrote:

> David Empson <dempson(a)actrix.gen.nz> wrote:
>
> > Gareth John <g.john(a)PLUG.btinternet.com> wrote:
> >
> > > Gareth John <g.john(a)PLUG.btinternet.com> wrote:
> > >
> > > > Debbie Wilson <djmaizels(a)mac.com> wrote:
> > > >
> > > > > Does anyone who uses iWork know if you can directly open or import
> > > > > Claris Works 5 spreadsheets in Numbers without loss of cell
> > > > > formatting, calcuations etc? I really need to get my (very simple)
> > > > > tax spreadsheets into an OSX program, it's stupid firing up
> > > > > Classic once a year just for these - but want to avoid any
> > > > > mess-ups in the process!
> > > >
> > > > Gulp. On 25th January, It sounds like you're leaving things later than
> > > > even I'm comfortable with...
> > > >
> > > > Does exporting the CW5 sheets to SYLK format help? Excel, at least can
> > > > import those, with formulas, but Numbers I don't know.
> > >
> > > Doh!
> > >
> > > Scratch that. I just checked with the two versions I've got available,
> > > and neither CW4 nor AppleWorks 6 will save as SYLK. So presumably CW%
> > > won't either.
> >
> > AppleWorks 6 can save as SYLK, IF you run it in Mac OS 9. It has a lot
> > more translators available than when running in Mac OS X.
> >
> > AppleWorks 5 can also save as SYLK. (I've done it.) ClarisWorks 5 should
> > be identical.
> >
> > Numbers doesn't appear to be able to sensibly import SYLK files (despite
> > taking ownership of that extension), but Excel can, as you noted.
>
> Ah, that's a relief. I wasn't dreaming, then. In my haste I had only
> tried CW4 (not CW5) under Classic, and AW6 under OSX.
>
> But it still sounds as though Debbie will need to go via Excel to
> Numbers.

Or via AppleWorks 6, if she can find a copy, which will also eliminate
almost all compatibility issues, and give her a way to access the old
spreadsheets in Mac OS X without having to convert them JUST yet.

I'm in the same boat, with lots of spreadsheets dating back to 1996
which were done in ClarisWorks 4 or AppleWorks 5. I rarely need to refer
to the pre-2001 spreadsheets, and I had AppleWorks 6 from that point.

--
David Empson
dempson(a)actrix.gen.nz

From: Debbie Wilson on 26 Jan 2010 06:31

Andy Hewitt <thewildrover(a)me.com> wrote:

> AFAIK it won't do ClarisWorks 5 files, only AppleWorks 6, but AW6 files
> do open just fine in Numbers.
>
> AppleWorks 6 does run natively in OSX, although in Rosetta on an Intel,
> but it runs OK here in 10.6.
>
> If you only have a few files, I'm sure some helpful folk might do the
> conversion for you :-)

Thanks Andy - problem now solved by saving as SYLK and opening in Excel.
I'm sure the helpful people here would have a good laugh at my pathetic
tax spreadsheets if they did do the conversion for me. Fortunately not
now necessary :-)

Deb.
--
http://www.scientific-art.com

"He looked a fierce and quarrelsome cat, but claw he never would;
He only bit the ones he loved, because they tasted good." S. Greenfield

From: Rowland McDonnell on 26 Jan 2010 08:02

Gareth John <g.john(a)PLUG.btinternet.com> wrote:

> Gareth John <g.john(a)PLUG.btinternet.com> wrote:
>
> > Debbie Wilson <djmaizels(a)mac.com> wrote:
> >
> > > Does anyone who uses iWork know if you can directly open or import
> > > Claris Works 5 spreadsheets in Numbers without loss of cell formatting,
> > > calcuations etc? I really need to get my (very simple) tax spreadsheets
> > > into an OSX program, it's stupid firing up Classic once a year just for
> > > these - but want to avoid any mess-ups in the process!
> >
> > Gulp. On 25th January, It sounds like you're leaving things later than
> > even I'm comfortable with...
> >
> > Does exporting the CW5 sheets to SYLK format help? Excel, at least can
> > import those, with formulas, but Numbers I don't know.
>
> Doh!
>
> Scratch that. I just checked with the two versions I've got available,
> and neither CW4 nor AppleWorks 6 will save as SYLK. So presumably CW%
> won't either.

Umm. Actually, CW4 *can* save as SYLK (IIRC). But you do need to have
the translators to hand.

AW 6 can save spreadsheets as Excel and CW4 and AW5 format.

I assume it can open at least some Excel spreadsheets - and CW4 and AW5
SS's.[1]

> I must be dreaming of Multiplan. Aaaah, Multiplan.

Nah, dreaming of an installation you no longer have.

Debbie: I am in an incapable state at the moment. I should not offer to
do anything for anyone. I am too unreliable.

But: I have CW4 (and CW 1) and AW 6 and a shedload of translators. An
old version or two of MacLinkPlus is included in that. Also MS Office
(not on this machine, but more than one version) and iWork '09.

If you are unable to solve this problem some other way, let me know.

If I should be able to dig out the old bits and set 'em up on the Mac
next to this one (which has a PPC and 10.4 and Classic), I would be able
provide the best translation you're likely to find.

I happen to know that I've got it all on HDD - not got all my floppies
read, but most of 'em. All praise be to FW800, that's all I'm saying.

Rowland.

[1] You wanna argue about that use of an apostrophe? All right then,
come and have a go if you think you're hard enough.

I've got Lynne Truss on my side and she's a serious heavyweight bruiser.

You have been warned.

--
Remove the animal for email address: rowland.mcdonnell(a)dog.physics.org
Sorry - the spam got to me
http://www.mag-uk.org http://www.bmf.co.uk
UK biker? Join MAG and the BMF and stop the Eurocrats banning biking

First | Prev | Next | Last
Pages: 1 2 3 4
Prev: Why isn't the iSlate destined to be a failure?
Next: T-Mobile/Chitter Chatter iPhone deal