If you drag the box in the lower right corner of the active cell to select a range of cells, LibreOffice automatically inserts the corresponding references in the adjacent cells. The reference to a cell of another document contains the name of the other document in single inverted commas, then a hash #, then the name of the sheet of the other document, followed by a point and the name of the cell.Ĭonfirm the formula by clicking the green check mark. In the input line you will now see how LibreOffice Calc has added the reference to the formula for you. Click the cell with the data that you want to insert in the new document. Now switch to the document you have just loaded. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula.
:max_bytes(150000):strip_icc()/007-openoffice-calc-formulas-how-to-1a074ce1c72b4433be21e81f7152770f.jpg "openoffice calc reference cell in another sheet")
It is also possible to use Excel A1 ot R1C1 formula syntax this is configured on Formula options page.Ĭhoose File - Open, to load an existing spreadsheet document.Ĭhoose File - New, to open a new spreadsheet document.
0 kommentar(er)
