Referencing data from other spreadsheets
From Apache OpenOffice Wiki
You can reference data from other spreadsheets and update it.
To reference a cell value in another spreadsheet, do the
following steps:
- In your current spreadsheet, select the cell to add the reference.
- On the Formula toolbar, click the Function icon.
- In the Formula Input Line, enter the code
in the following format.
<code>'file:/<strong class="ph b"><var class="keyword varname">FilePath</var></strong>'#<strong class="ph b"><var class="keyword varname">SheetName</var></strong>.<strong class="ph b"><var class="keyword varname">DataRange</var></strong></code>
For example, to reference A1:B5 in the example.ods file
under the c:/temp/ directory, enter 'file:/c:/temp/example.ods'#Sheet1.A1:B5. - Press Enter.