Prev: Why isn't the iSlate destined to be a failure?
Next: T-Mobile/Chitter Chatter iPhone deal
From: Debbie Wilson on 25 Jan 2010 17:32
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!

Ta,

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: Andy Hewitt on 25 Jan 2010 18:30
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!
>
> Ta,
>
> Deb.

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 :-)

--
Andy Hewitt
<http://web.me.com/andrewhewitt1/>
From: David Empson on 25 Jan 2010 18:45
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?

No. Numbers cannot open ClarisWorks 5 spreadsheets directly.

It does open AppleWorks 6 spreadsheets, and generally preserves
formatting and calculations when importing them. There may be some
obscure function operators which don't work right, but Numbers should
flag them in a list of warnings when importing. There are also some
AppleWorks features missing from Numbers, such as forced page breaks and
"set print range", so they will be ignored.

I don't recall any issues with converting my reasonably simple
AppleWorks 6 spreadsheets to Numbers.

AppleWorks 6 can open ClarisWorks 5 (or AppleWorks 5) spreadsheets,
resave them as AppleWorks 6, and then Numbers can import them.

If you have some really old documents in ClarisWorks 4 or earlier
format, I forget offhand whether AppleWorks 6 can open them, but
ClarisWorks or AppleWorks 5 can.

I still have AppleWorks 5 installed on an old Mac (in Mac OS 9) and
AppleWorks 6 on my MacBook Pro, so I can import old documents.
AppleWorks 6.2.9 still works fine as a native Mac OS X PowerPC
application (via Rosetta) in Snow Leopard.

> 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!

If you want to upgrade to Leopard, or to an Intel Mac, that option will
disappear unless you also keep a working PowerPC Mac.

Assuming you don't have it already, see if you can get hold of a second
hand copy of AppleWorks 6.

It was sold as a retail product as well as being bundled on "consumer"
Mac models (iBook, iMac, eMac) from about 2001 until about 2004.

Ideally you want the retail version, as the copy included on
model-specific CDs won't let you install it on a different model.
--
David Empson
dempson(a)actrix.gen.nz
From: Gareth John on 26 Jan 2010 03:36
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.

G.

--
From Gareth John
Please pull out the plug if you want to reply by email
From: Gareth John on 26 Jan 2010 03:51
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.

I must be dreaming of Multiplan. Aaaah, Multiplan.

G.
--
From Gareth John
Please pull out the plug if you want to reply by email
 |  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