Difference between revisions of "Referencing data in a spreadsheet"
From Apache OpenOffice Wiki
(+cat) |
m |
||
| Line 1: | Line 1: | ||
| − | + | You can reference data from other cells or sheets in the same document. The result data changes accordingly when the source data has changed. | |
| − | same document. The result data changes accordingly when the source | + | |
| − | data has changed. | + | Suppose that in a spreadsheet, you are trying to sum the values of cell A1 in Sheet1 and cell B1 in Sheet2, and put the result into cell C1 in Sheet3. To accomplish the task, do the following steps: |
| − | + | <ol> | |
| − | values of cell A1 in Sheet1 and cell B1 in Sheet2, and put the result | + | <li>Select cell C1 in Sheet3.</li> |
| − | into cell C1 in Sheet3. To accomplish the task, do the following steps:<ol | + | <li>On the <span class="ph uicontrol">Formula</span> toolbar, click the '''Function''' icon [[File:s_function_icon.jpg]].</li> |
| − | <li | + | <li>You can use either of the following ways to edit the formula. |
| − | <li | + | <ul> |
| − | (=).</li> | + | <li>Enter <tt>Sheet1.A1+Sheet2.B1</tt> after the Equal sign (=).</li> |
| − | <li | + | <li>You can also complete the formula by selecting the cells in the |
| − | following way | + | following way: |
| − | <li | + | <ol type="a"> |
| − | + | <li>In Sheet1, select cell A1.</li> | |
| − | <li | + | <li>In Sheet3, enter a Plus sign (+) in the '''Formula InputLine'''.</li> |
| + | <li>In Sheet2, select cell B1.</li> | ||
</ol> | </ol> | ||
</li> | </li> | ||
</ul> | </ul> | ||
</li> | </li> | ||
| − | <li | + | <li>In Sheet3, click the '''Accept''' icon on the '''Formula''' toolbar.</li> |
| − | |||
| − | |||
</ol> | </ol> | ||
| − | + | ||
| − | + | You can see that the sum value of cell A1 in Sheet1 and cell B1 in Sheet2 is displayed in C1. | |
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Calc]] | [[Category:Calc]] | ||
Revision as of 09:31, 8 June 2026
You can reference data from other cells or sheets in the same document. The result data changes accordingly when the source data has changed.
Suppose that in a spreadsheet, you are trying to sum the values of cell A1 in Sheet1 and cell B1 in Sheet2, and put the result into cell C1 in Sheet3. To accomplish the task, do the following steps:
- Select cell C1 in Sheet3.
- On the Formula toolbar, click the Function icon
. - You can use either of the following ways to edit the formula.
- Enter Sheet1.A1+Sheet2.B1 after the Equal sign (=).
- You can also complete the formula by selecting the cells in the
following way:
- In Sheet1, select cell A1.
- In Sheet3, enter a Plus sign (+) in the Formula InputLine.
- In Sheet2, select cell B1.
- In Sheet3, click the Accept icon on the Formula toolbar.
You can see that the sum value of cell A1 in Sheet1 and cell B1 in Sheet2 is displayed in C1.
