Path: utzoo!yunexus!stpl!bbm!aaron
From: aaron@bbm.UUCP (Aaron Burns)
Newsgroups: comp.sys.ibm.pc
Subject: Supercalc 1.10 to Lotus transfer
Keywords: supercalc lotus conversion
Message-ID: <806@bbm.UUCP>
Date: 3 Nov 89 23:29:44 GMT
Article-I.D.: bbm.806
Reply-To: aaron@bbm.UUCP (Aaron Burns)
Organization: BBM Bureau of Measurement, Toronto
Lines: 28

Here's a good one for you:

Years ago I created several megs of spreadsheets under Supercalc 1.10, and 
now it's time to move on.  Re-entering the spreadsheets will take days or
weeks.   I would like to move the information into a format that 
Lotus 123 version 2.1 will understand.  Starting from Supercalc 1.10, how
can we do this?  SC 1.10 can't dump into any formats except it's own
and ascii that looks like this:
....
C7      P= C5(IF(B6>2,(B6-2)/10,IF(B6=1,.01,.05))+(B7-1)5/100)
E7      P= LOOKUP(B6,J1:J5)IF(B7=1,1,IF(B7=2,1.3,1.5))C5
H7       = 7
I7       = 50
J7       = 2
K7       = 160
....
where C7 is the cell identifier, P means protected, and the rest is the
contents, either formulas, numbers, or text.

Please reply via e-mail, as my newsfeed junks old postings with 
lightning enthusiasm.  If there's much interest i'll summarize to the 
net.

-- 
Aaron 'crash and' Burns      "Nothing I say on the net is binding
Metro Works                   to our corporation"
Toronto, Ontario             "Life is a forge, and the purest metal
(416)392-4310                 comes from the hottest fire"