Re: Cell Link

[Jody Goldberg <jody gnome org>]

On Wed, Sep 04, 2002 at 05:25:53PM +0200, Tino Meinen wrote:
> Op wo 04-09-2002, om 12:18 schreef Tino Meinen:
> > Op wo 04-09-2002, om 05:22 schreef Rajiv Vyas:
> > > What is the best way to link cells (using data from cell in one
> > > spreadsheet with that in another).
> > Do you perhaps mean, linking cells between two *workbooks* (but both of
> > them within the same spreadsheet)?
>
> Ok so what you want is something like this: 
> the cell A1 on sheet1 refers to the cell B2 on sheet2:
>
> A1=sheet2!B2

Actually that terminology is incorrect

An application contains multiple workbooks
a workbook contains multiple worksheets
a worksheet contains cells

To link from 1 workbook to another the syntax is
[workbookname]Sheetname!cell

The easiest way to set it up is to cut a cell with a local reference
in 1 workbook and paste it into the other.  That will create a link.
Gnumeric does not currently import this correctly from xls files