aaron@bbm.UUCP (Aaron Burns) (11/04/89)
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"
lisbon@vpnet.UUCP (Gerry Swetsky) (11/07/89)
In item 2717 aaron@bbm.UUCP [Aaron Burns] says: > 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? Three suggestions. Get ahold of a later version of Supercalc which supports output in 123 format as well as others. I know version 4 has this because I just used that feature to move all my sheets to Excel (a MAN's spreadsheet!). Same thing with 123. My experience here is limited, however there should be some kind of "import" utility. Get ahold of a third party program which does the conversion. There are several, all commercial unfortunately. > 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. Believe me, I tried. Your mail bounced. -- ============================================================================= | Help stamp out stupid .signature files! Gerry Swetsky | | | | Home (708)833-8122 Vpnet (708)833-8126 lisbon@vpnet.uucp | =============================================================================