Language

The Free and Open Productivity Suite
Apache OpenOffice 4.1.8 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 Events

Apache Software Foundation

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

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