Referencing a Cell in Another Document

U ─çeliji mo┼żete prikazati referencu za ─çeliju u drugoj tablici.

Na isti na─Źin se mo┼że napraviti referenca za ─çeliju iz drugog dokumenta pod uslovom da je taj dokument ve─ç sa─Źuvan kao datoteka.

Referiranje (pozivanje) ─ćelije u Drugom Dokumentu

  1. Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on + button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).

  2. Na na─Źin u primjeru, unesite slijede─çu formulu u ─çeliju A1 u Sheet1:

    #NAME?

  3. Kliknite Sheet 2 tab na dnu tablice. Postavite kursor u ─çeliju A1 i unesite tekst ili broj.

  4. Ukoliko se prebacite nazad na Sheet1 (Tablica 1), tu ─çete vidjeti isti sadr┼żaj u ─çeliji A1. Ako se sadr┼żaj u Sheet2.A1 promijeni, onda ─çe se i sadr┼żaj Sheet1.A1 tako─Ĺer promijeniti.

tip

When referencing a sheet with name containing spaces, use single quotes around the name: ='Sheet with spaces in name'.A1


tip

The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on Formula options page.


Referiranje (pozivanje) ─ćelije u Drugom Dokumentu

  1. Izaberite Datoteka - Otvori, da bi u─Źitali postoje─çi dokument sa prora─Źunskim tablicama.

  2. Izaberite Datoteka - New, da bi otvorili novi dokument. Postavite kursor u ─çeliju u koju ┼żelite unijeti vanjske podatke i unesite znak jednakosti da bi nazna─Źili da ┼żelite zabo─Źeti formulu.

  3. Sada se prebacite u dokument koji ste upravo o─Źitali. Kliknite ─çeliju sa podacima koje ┼żelite unijeti u novi dokument.

  4. Vratite se u novu tablicu. U liniju za unos ─çete vidjeti kako je LibreOffice Calc dodao referencu formuli za vas.

    The reference to a cell of another document contains the fully qualified name of the other document between single quotes ('), then a hash #, then the name of the sheet of the other document, followed by a period and the name or reference of the cell.

    For example, .

    note

    The path and document name URI must always be enclosed in single quotes. If the name contains single quotes (') they must be escaped using two single quotes (''). Only a sheet name may not be quoted if it does not contain a space or a character that would be an operator or the name would be pure numeric (for example, '123' must be quoted).


  5. Potvrdite formulu klikanjem zelene kva─Źice.

  6. 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. As a result, the sheet name is preceded with a "$" sign to designate it as an absolute reference.

Ukoliko pogledate ime drugog dokumenta u ovoj formuli, primjeticete da je napisano kao URL. Ovo zna─Źi da mo┼żete unijeti i URL sa Interneta.

Please support us!