PRODUCT  :  QUATTRO PRO                            NUMBER  :  224
VERSION  :  1.0
     OS  :  MS/PC DOS
   DATE  :  April 30, 1990			     PAGE  :  1/3

  TITLE  :  QUATTRO PRO AND THE LOTUS 2.2 LINKING FORMULA




Since Lotus 2.2 saves files with the extension WK1, they are
still somewhat compatible with 2.01.  Since Quattro Pro will load
in these spreadsheets, it is possible to convert linking formulas
created in Lotus 2.2 to Quattro Pro format.  When Lotus 2.2 saves
a linked formula, it saves it in the following format:

	@@("<<filename>>address")

	where filename is the worksheet to get the data from, and
	address is the address in the worksheet filename to get
	data from.

The syntax of the Quattro Pro link formula, using the same
arguments as above, is as follows:

	+[filename]address

	where filename and address are the same as above.

By replacing the << & >> characters in the Lotus 2.2 formula with
the [ & ] in Quattro Pro, we can convert the Lotus formula into a
Quattro Pro linking formula.  The macro below will traverse each
cell of the current worksheet, and convert any link formulas that
it finds.

To Run The Macro:

   1.  Enter this macro into a spreadsheet and save it as a macro
       library.  Use / <E>dit <N>ames <L>abels <R>ight on the
       first column of the macro to name all the macros
       correctly.

   2.  Open the spreadsheet you wish to convert.

   3.  Select / <T>ools <M>acro <E>xecute (/ <W>orksheet <M>acro
       <E>xecute in Lotus Compatible Menus).

   4.  Type in CONVERT, and press <Enter>.

NOTE that the windows have been turned off to speed execution, so
you won't see the changes take place on the screen until the
macro has finished.














PRODUCT  :  QUATTRO PRO                            NUMBER  :  224
VERSION  :  1.0
     OS  :  MS/PC DOS
   DATE  :  April 30, 1990			     PAGE  :  2/3

  TITLE  :  QUATTRO PRO AND THE LOTUS 2.2 LINKING FORMULA




	       The Macro In Cell-Formula Notation


 A1: 'Convert
 B1: '{indicate "WAIT"}{/ Defaults;Suppress}b
 B2: '{/ Startup;Beep}n
 B3: '{end}{home}{let maxrow,@cellpointer("row")}~
 B4: '{let maxcol,@cellpointer("col")}~
 B5: '{}
 B6: '{home}{for row,0,maxrow-1,1,col_loop}
 B7: '{indicate}{/ Startup;Beep}y~{quit}
 A9: 'col_loop
 B9: '{indicate @string(row,0)}
B10: '{for col,0,maxcol-1,1,move}{down}{bigleft 32}{return}
A12: 'move
B12: '{recalc 2.2Converter}{2.2Converter}{right}{return}
A14: 'maxrow
B14: 0
A15: 'maxcol
B15: 0
A16: 'row
B16: 0
A17: 'col
B17: 0
A19: '_CONTENT
B19: @CELLPOINTER("contents")
A21: '2.2Converter
B21: +"{if #not# @iserr("&@CELLPOINTER("address")&")}{return}"
B22: '{edit}{home}'+~{calc}
B23: '{if @iserr(@find("@@(""<<",_CONTENT,0))}{edit}{home}{del
2}~{return}
B24: '{edit}{home}{del 2}~
B25: '{EDIT}
B26: '{HOME}
B27: '{DEL 3}+
B28: '{END}
B29: '{BACKSPACE}~
B30: '{/ Audit;SearchReset}
B31: '{/ Audit;ReplaceRange}~
B32: '{/ Audit;SearchString}<<~
B33: '{/ Audit;ReplaceString}[~
B34: '{/ Audit;Replace}a
B35: '{/ Audit;SearchReset}













PRODUCT  :  QUATTRO PRO                            NUMBER  :  224
VERSION  :  1.0
     OS  :  MS/PC DOS
   DATE  :  April 30, 1990			     PAGE  :  3/3

  TITLE  :  QUATTRO PRO AND THE LOTUS 2.2 LINKING FORMULA




B36: '{/ Audit;ReplaceRange}~
B37: '{/ Audit;SearchString}>>~
B38: '{/ Audit;ReplaceString}]~
B39: '{/ Audit;Replace}a
B40: '{EDIT}
B41: '{BACKSPACE}
B42: '{HOME}
B43: '{RIGHT}
B44: '{DEL}~
B45: '{return}














































PRODUCT  :  QUATTRO PRO                            NUMBER  :  224
VERSION  :  1.0
     OS  :  MS/PC DOS
   DATE  :  April 30, 1990			     PAGE  :  4/3

  TITLE  :  QUATTRO PRO AND THE LOTUS 2.2 LINKING FORMULA




	   The Macro As It Appears In The Spreadsheet


Convert      {indicate "WAIT"}{/ Defaults;Suppress}b
	     {/ Startup;Beep}n
	     {end}{home}{let maxrow,@cellpointer("row")}~
	     {let maxcol,@cellpointer("col")}~
	     {}
	     {home}{for row,0,maxrow-1,1,col_loop}
	     {indicate}{/ Startup;Beep}y~{quit}

col_loop     {indicate @string(row,0)}
	     {for col,0,maxcol-1,1,move}{down}{bigleft
32}{return}

move	     {recalc 2.2Converter}{2.2Converter}{right}{return}

maxrow	     0
maxcol	     0
row	     0
col	     0

_CONTENT	    0

2.2Converter {if #not# @iserr($B$18)}{return}
	     {edit}{home}'+~{calc}
	     {if
@iserr(@find("@@(""<<",_CONTENT,0))}{edit}{home}{del 2}~{return}
	     {edit}{home}{del 2}~
	     {EDIT}
	     {HOME}
	     {DEL 3}+
	     {END}
	     {BACKSPACE}~
	     {/ Audit;SearchReset}
	     {/ Audit;ReplaceRange}~
	     {/ Audit;SearchString}<<~
	     {/ Audit;ReplaceString}[~
	     {/ Audit;Replace}a
	     {/ Audit;SearchReset}
	     {/ Audit;ReplaceRange}~
	     {/ Audit;SearchString}>>~
	     {/ Audit;ReplaceString}]~













PRODUCT  :  QUATTRO PRO                            NUMBER  :  224
VERSION  :  1.0
     OS  :  MS/PC DOS
   DATE  :  April 30, 1990			     PAGE  :  5/3

  TITLE  :  QUATTRO PRO AND THE LOTUS 2.2 LINKING FORMULA




	     {/ Audit;Replace}a
	     {EDIT}
	     {BACKSPACE}
	     {HOME}
	     {RIGHT}
	     {DEL}~
	     {return}