Referencing a Cell in Another Sheet

किसी शीट कक्ष में आप अन्य शीट के कक्ष का संदर्भ दिखा सकते हैं.

In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file.

कक्ष को अन्य दस्तावेज़ में संदर्भित करना

  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. उदाहरण के द्वारा, निम्न सूत्र को शीट 1 के कक्ष A1 में भरें

    =Sheet2.A1

  3. Click the Sheet 2 tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number.

  4. If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.

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.


कक्ष को अन्य दस्तावेज़ में संदर्भित करना

  1. Choose File - Open, to load an existing spreadsheet document.

  2. Choose File - New, to open a new spreadsheet document. 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.

  3. Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document.

  4. Switch back to the new spreadsheet. In the input line you will now see how LibreOffice Calc has added the reference to the formula for you.

    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. हरा चेक मार्क को क्लिक कर सूत्र की पुष्टि करें

  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.

If you examine the name of the other document in this formula, you will notice that it is written as a URL. This means that you can also enter a URL from the Internet.

Please support us!