Difference between revisions of "Referencing data from other spreadsheets"
From Apache OpenOffice Wiki
(+cat) |
m |
||
| Line 1: | Line 1: | ||
| − | + | You can reference data from other spreadsheets and update | |
| − | it. | + | it. |
| − | < | + | <ol> |
| − | + | <li>In your current spreadsheet, select the cell to add the reference.</li> | |
| − | <li | + | <li>On the '''Formula''' toolbar, click the '''Function''' icon.</li> |
| − | <li | + | <li>In the '''Formula Input Line''', enter the code in the following format:<br /> <tt>FilePathSheetNameDataRange</tt><br /> |
| − | in the following format | + | 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</samp>.</li> |
| − | For | + | <li>Press {{key|Enter}}.</li> |
| − | example, to reference A1:B5 in the | ||
| − | under the | ||
| − | <li | ||
</ol> | </ol> | ||
| − | + | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Calc]] | [[Category:Calc]] | ||
Latest revision as of 09:23, 8 June 2026
You can reference data from other spreadsheets and update it.
- 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:
FilePathSheetNameDataRange
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 .
