Frequently asked questions - Calc

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

How to retrieve the content of cells originating from other files

You can:

1. open the source file;
2. select and copy the desired cell(s) to the clipboard with CTRL + C;
3. open the target file;
4. choose the target cell;
5. Go to Edit ▸ Paste special
6. 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")