Ch 6: Linking Spreadsheet Data
Linking Spreadsheet Data
Linking avoids retyping data — it references data so any change in the source updates automatically, preventing errors.
Reference (same file):
$'SheetName'.CellAddress, e.g. $'Term 1'.C4 (single quotes because the name has a space).Reference (different file): path in single quotes, then
#$, then Sheet.Cell. A file path uses three forward slashes (///).Hyperlinks
| Type | Meaning |
|---|---|
| Absolute | Stores the complete location. Breaks if the file is moved. |
| Relative | Stores location relative to the current one. Works if the folder moves together. |
External data: Sheet > Link to External Data → enter a URL → choose a table. Register a Base database (.odb) via Tools > Options > LibreOffice Base > Databases.
Summary
- Linking references data so changes update automatically.
- File paths use three slashes (///).
- Absolute hyperlink = full path (breaks if moved); relative = based on current location.
Spreadsheet Data Linking
Linking data दोबारा टाइप करने से बचाता है — data reference होता है, तो source में बदलाव अपने आप update होता है।
Reference (same file):
$'SheetName'.CellAddress, जैसे $'Term 1'.C4 (नाम में space के कारण single quotes)।Reference (दूसरी file): path single quotes में, फिर
#$, फिर Sheet.Cell। File path में तीन forward slashes (///)।Hyperlinks
| Type | अर्थ |
|---|---|
| Absolute | पूरा location store करता है। File move होने पर टूट जाता है। |
| Relative | Current location के सापेक्ष। Folder साथ move हो तो काम करता है। |
External data: Sheet > Link to External Data → URL डालें → table चुनें। Base database (.odb) register करें Tools > Options > LibreOffice Base से।
सारांश
- Linking data reference करता है ताकि बदलाव अपने आप update हों।
- File paths में तीन slashes (///)।
- Absolute hyperlink = पूरा path (move पर टूटता है); relative = current location पर आधारित।
Frequently Asked Questions
How many forward slashes does a file path use?
A file path uses three forward slashes (///).
What is the difference between absolute and relative hyperlinks?
An absolute hyperlink stores the full path and breaks if the file is moved; a relative hyperlink stores the location relative to the current one.