Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 10-16-2008, 11:20 PM   #1
Registered: Sep 2008
Location: Raleigh
Distribution: Ubuntu 8.10
Posts: 88
Blog Entries: 1

Rep: Reputation: 15
How do I define a range in OpenOffice Calc?

Here's a random question about OpenOffice:

I want to define a range that is relative to local sheets. For example, I want the variable "foo" to be equal to the cell D3 in whatever sheet I'm currently in. Whenever I try to use Data > Define Range, it refers to the sheet that I originally set the variable.

In other words:
Name of Range: foo
Range: $'sheet1'.$D$3

I want for foo to access D3 in whatever sheet I'm in, not just sheet1. Is there a keyword I have to use in place of sheet1?

Sorry for the silly question. I'm using 2.4 in Xubuntu, though I doubt that holds any helpful information.
Old 10-17-2008, 09:10 AM   #2
Jerre Cope
Registered: Oct 2003
Location: Texas (central)
Distribution: ubuntu,Slackware,knoppix
Posts: 323

Rep: Reputation: 37
There is not a Global Variable concept in OO Calc. You can if have both spreadsheets open, you can press = within a cell in one and use the mouse to select a cell or range in the other. That "links" the two spreadsheets, and the calling spreadsheet will offer to relink with the other(s) each time you load.

If you want to do more than that, you'll need to delve into UNO. See the

Last edited by Jerre Cope; 10-17-2008 at 09:13 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Shell variables in awk to define range fur Programming 1 09-01-2007 02:22 PM
logic in openoffice calc edgjerp Linux - Software 2 05-14-2006 08:13 AM
Openoffice calc dajomu Linux - Software 1 10-27-2005 05:56 PM
openoffice calc question buffed317 Linux - General 1 09-11-2004 03:27 PM
openoffice calc question... marsques Linux - Software 2 07-10-2004 04:30 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:07 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration