LibreOffice 25.2 Help
āĻāĻāĻāĻŋ āĻĒāĻžāϤāĻž āĻāĻā§āώ⧠āĻāĻĒāύāĻŋ āĻ āύā§āϝ āĻĒāĻžāϤāĻžāϰ āϰā§āĻĢāĻžāϰā§āύā§āϏ āĻĻā§āĻāĻžāϤ⧠āĻĒāĻžāϰāĻŦā§āύāĨ¤
āĻāĻāĻ āĻĒāĻĻā§āϧāϤāĻŋāϤā§, āĻ āύā§āϝ āύāĻĨāĻŋ āĻĨā§āĻā§ āĻāĻāĻāĻŋ āĻāĻā§āώ⧠āϰā§āĻĢāĻžāϰā§āύā§āϏ āϤā§āϰāĻŋ āĻāϰāĻž āϝāĻžāĻŦā§ āϝāĻž āύāĻĨāĻŋāĻāĻŋ āĻāϤāĻŽāϧā§āϝ⧠āĻāĻāĻāĻŋ āĻĢāĻžāĻāϞ āĻšāĻŋāϏā§āĻŦā§ āϏāĻāϰāĻā§āώāĻŋāϤ āĻāĻā§ āϤāĻž āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§āĨ¤
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).
āĻāĻĻāĻšāĻžāϰāĻŖā§āϰ āĻŽāĻžāϧā§āϝāĻŽā§, āĻĒāĻžāϤāĻž ā§§ āĻāϰ āĻāϰ A1 āĻ āύāĻŋāĻŽā§āύā§āĻā§āϤ āϏā§āϤā§āϰ āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāĻžāύ :
=Sheet2.A1
āϏā§āĻĒā§āϰā§āĻĄāĻļā§āĻā§āϰ āύāĻŋāĻŽā§āύ⧠āĻĒāĻžāϤāĻž ⧍ āĻā§āϝāĻžāĻŦ āĻ āĻā§āϞāĻŋāĻ āĻāϰā§āύāĨ¤ āĻāĻāĻžāύ⧠āĻāϰ A1 āĻ āĻāĻžāϰā§āϏāĻžāϰ āϏā§āĻ āĻāϰā§āύ āĻāĻŦāĻ āĻĒāĻžāĻ ā§āϝ āĻ āĻĨāĻŦāĻž āϏāĻāĻā§āϝāĻž āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāĻžāύāĨ¤
āϝāĻĻāĻŋ āĻāĻĒāύāĻŋ āĻĒāĻžāϤāĻž ā§§ āĻ āĻĢā§āϰāϤ āϝāĻžāύ, āĻāĻĒāύāĻŋ āĻāĻāĻžāύ⧠āĻāϰ A1 āĻ āĻāĻāĻ āĻŦāĻŋāώāϝāĻŧāĻŦāϏā§āϤ⧠āĻĻā§āĻāϤ⧠āĻĒāĻžāĻŦā§āύāĨ¤ āϝāĻĻāĻŋ āĻĒāĻžāϤāĻž t2.A1 āĻāϰ āĻŦāĻŋāώāϝāĻŧāĻŦāϏā§āϤ⧠āĻĒāϰāĻŋāĻŦāϰā§āϤāύ āĻšāϝāĻŧ, āϤāĻāύ āĻĒāĻžāϤāĻž t2.A1 āĻāϰ āĻŦāĻŋāώāϝāĻŧāĻŦāϏā§āϤ⧠āĻ āĻĒāϰāĻŋāĻŦāϰā§āϤāύ āĻšāĻŦā§āĨ¤
When referencing a sheet with name containing spaces, use single quotes around the name: ='Sheet with spaces in name'.A1
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.
āĻāĻāĻāĻŋ āĻŦāĻŋāĻĻā§āϝāĻŽāĻžāύ āϏā§āĻĒā§āϰā§āĻĄāĻļā§āĻ āύāĻĨāĻŋ āϞā§āĻĄ āĻāϰāϤā§, āĻĢāĻžāĻāϞ - āĻā§āϞā§āύāĻĒāĻāύā§āĻĻ āĻāϰā§āύ
āύāϤā§āύ āϏā§āĻĒā§āϰā§āĻĄāĻļā§āĻ āύāĻĨāĻŋ āĻā§āϞāϤā§, āĻĢāĻžāĻāϞ - āύāϤā§āύ āĻĒāĻāύā§āĻĻ āĻāϰā§āύāĨ¤ āĻāĻĒāύāĻŋ āĻāĻāĻāĻŋ āϏā§āϤā§āϰ āĻāϰāĻŽā§āĻ āĻāϰāϤ⧠āĻāĻžāύ āϏā§āĻāĻŋ āύāĻŋāϰā§āĻĻā§āĻļ āĻāϰāϤ⧠āĻāĻā§āώ⧠āĻāĻžāϰā§āϏāĻžāϰāĻāĻŋ āύāĻŋāϰā§āϧāĻžāϰāĻŖ āĻāϰā§āύ āϝā§āĻāĻžāύ⧠āĻāĻĒāύāĻŋ āĻŦāĻšāĻŋāĻāϏā§āĻĨ āĻĄāĻžāĻāĻž āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāĻžāϤ⧠āĻĒāĻžāϰā§āύ āĻāĻŦāĻ āĻāĻāĻāĻŋ āϏāĻŽāĻžāύ āĻāĻŋāĻšā§āύ āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāĻžāύāĨ¤
āĻāĻĒāύāĻžāϰ āĻŽāĻžāϤā§āϰ āϞā§āĻĄ āĻāϰāĻž āύāĻĨāĻŋāϤ⧠āϏā§āĻāĻ āĻāϰā§āύāĨ¤ āĻĄāĻžāĻāĻž āϏāĻš āĻāĻā§āώ⧠āĻā§āϞāĻŋāĻ āĻāϰā§āύ āϝāĻž āĻāĻĒāύāĻŋ āύāϤā§āύ āύāĻĨāĻŋāϤ⧠āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāĻžāϤ⧠āĻāĻžāύāĨ¤
āύāϤā§āύ āϏā§āĻĒā§āϰā§āĻĄāĻļā§āĻā§ āĻĢā§āϰāϤ āϝāĻžāύāĨ¤ āĻāύāĻĒā§āĻ āϰā§āĻāĻžāϝāĻŧ āĻāĻĒāύāĻŋ āĻĻā§āĻāϤ⧠āĻĒāĻžāϰā§āύ āĻāĻŋāĻāĻžāĻŦā§ LibreOffice Calc āϏā§āϤā§āϰ⧠āĻāĻĒāύāĻžāϰ āĻāύā§āϝ āϰā§āĻĢāĻžāϰā§āύā§āϏ āϝā§āĻā§āϤ āĻāϰā§āĨ¤
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, 'file:///C:/Users/user/Documents/Price list.ods'#$'Information SKU'.H51'file:///home/user/Documents/Price list.ods'#$'Information SKU'.H51.
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).
āϏāĻŦā§āĻ āĻĒāϰā§āĻā§āώāύ āĻā§āĻšā§āύ⧠āĻā§āϞāĻŋāĻ āĻāϰ⧠āϏā§āϤā§āϰ āύāĻŋāĻļā§āĻāĻŋāϤ āĻāϰā§āύāĨ¤
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.
āϝāĻĻāĻŋ āĻāĻĒāύāĻŋ āĻāĻ āϏā§āϤā§āϰ⧠āĻ āύā§āϝ āύāĻĨāĻŋāϰ āύāĻžāĻŽ āϏāϤāϰā§āĻāϤāĻžāϰ āϏāĻžāĻĨā§ āĻĒāϰā§āĻā§āώāĻž āĻāϰ⧠āĻĻā§āĻā§āύ, āĻāĻĒāύāĻŋ āϞāĻā§āώ āĻāϰāĻŦā§āύ āϝ⧠āĻāĻāĻŋ URLāĻšāĻŋāϏā§āĻŦā§ āϞā§āĻāĻž āĻšāϝāĻŧā§āĻā§āĨ¤ āĻāϰ āĻŽāĻžāύ⧠āĻāĻĒāύāĻŋ āĻāύā§āĻāĻžāϰāύā§āĻ āĻĨā§āĻā§ āĻāĻāĻāĻŋ URL āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāĻžāϤ⧠āĻĒāĻžāϰā§āύāĨ¤