Frequently asked questions - Calc
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
How to retrieve the content of cells originating from other files
You can:
- open the source file;
- select and copy the desired cell(s) to the clipboard with CTRL+C;
- open the target file;
- choose the target cell;
- Go to ▸
- Select the Paste option.
Or you can do this more directly by writing the following formula directly into the formula bar or into the target cell:
=DDE("soffice";"YourFilePath";"SourceFileName.SourceCellName")
For example :
=DDE("soffice";"C:\My Documents\LibreOffice\MyFile.ods";"Sheet.A1")