Translations:Faq/Calc/016/3/en

From The Document Foundation Wiki
Jump to: navigation, search

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")