Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.6 released

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

How can I use cells from different Calc files?

You can open the source file, select and copy onto the clipboard (CTRL + C) the desired cells and then in the target file you should select a target cell and choose Edit > Paste Special from the Menu Bar and enable the link option in the choice shown in the dialog box that opens.

A more direct way to do this is to write a formula of the following kind in the formula bar or in a target cell:
=DDE(soffice; YourFilePath; SourceSheetName.SourceCellName)

Example: =DDE(soffice;c:\myfile.sxi;MySheet.A1)

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.