[Solved] Linking cells in different spreadsheets

Discuss the spreadsheet application

[Solved] Linking cells in different spreadsheets

Postby jennydawg » Fri May 16, 2008 7:03 pm

Version 2.4.0

Windows XP

Question:
In Excel I am able to link cells from one spreadsheet to another within the same file. For example, I enter a number into a checking account and then go to a different sheet where I keep track of the expense by adding the checking account number into a summary cell on another sheet. How can I do this in Open Office?

thank you
Last edited by Hagar Delest on Tue Jun 10, 2008 2:29 pm, edited 3 times in total.
Reason: tagged the thread as solved.
jennydawg
 
Posts: 2
Joined: Fri May 16, 2008 6:57 pm

Re: linking cells in different spreadsheets

Postby Villeroy » Fri May 16, 2008 10:12 pm

Same as in Excel with one difference: The sheet-separator is dot rather than exclamation mark.
Use =SheetX.A1 instead of =SheetX!A1. You can also click the referenced cell while editing the formula or you can copy and paste-special with option "Link".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29149
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: linking cells in different spreadsheets

Postby jennydawg » Sat May 17, 2008 3:13 am

Thank you!
jennydawg
 
Posts: 2
Joined: Fri May 16, 2008 6:57 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests