Referencing Other Sheets
पाना कक्षमा तपाईँ कक्षका लागि अर्को पानामा सन्दर्भ देखाउन सक्नुहुन्छ ।
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.
अर्को कागजातमा कक्ष सान्दर्भित गर्दा
-
एउटा नयाँ, खाली स्प्रेडसिट खोल्नुहोस् ।
-
उदाहरणको विधि अनुसार, पाना १ को कक्ष A1 मा निम्न सूत्र प्रविष्ट गर्नुहोस्:
=Sheet2.A1
-
स्प्रेडसिटको तल पाना २ ट्याबमा क्लिक गर्नुहोस् । त्यहाँ कक्ष A1 मा कर्सर सेट गर्नुहोस् र पाठ वा सङ्ख्या प्रविष्ट गर्नुहोस् ।
-
यदि तपाईँ पाना १ लाई पछाडि स्विच गर्नुहुन्छ भने, तपाईँले त्यहाँ कक्ष A1मा उस्तै सामग्री देख्नु हुनेछ । यदि पाना २ का सामग्रीहरू A1 मा परिवर्तन हुँदा, त्यसपछि पाना १ का सामग्रीहरू A1 मा पनि परिवर्तन हुन्छन् ।
अर्को कागजातमा कक्ष सान्दर्भित गर्दा
-
Choose File - Open, to load an existing spreadsheet document.
-
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.
-
Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document.
-
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 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.
-
हरियो जाँच चिनो क्लिक गरेर सूत्र यकीन गर्नुहोस् ।
-
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.