OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

reference to sheet with blank in the name

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
hihat
Newbie
Newbie


Joined: 11 Dec 2006
Posts: 2

PostPosted: Mon Dec 11, 2006 10:11 am    Post subject: reference to sheet with blank in the name Reply with quote

Dear OO-users

I looked for this in the help for vain.
I have a document with several sheets, called after months and year, like July 2005, December 2006 and so on. Now I have to refer to some cells in those sheets in an overview sheet. Actually I thought it was like $July 2005.H37 for cell H37 f.ex. If the sheet was just called July $July.H37 would work great, but since there is a space bar / blank in the name, it doesn't want to work.

There must be a way of encapsulating such variable names. I hope there is an easier way than to rename all sheets (there's so many).

Thanks a lot for help.

David

PS: Is there a way to retrieve (and link with) the internal name of a sheet?
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2477
Location: 3rd Rock From The Sun

PostPosted: Mon Dec 11, 2006 10:36 am    Post subject: Reply with quote

David:

You asked:
David wrote:
Actually I thought it was like $July 2005.H37 for cell H37

Change it slightly, to this: $'July 2005'.H37

Since, your sheet name includes a space . . . then . . . encapsulate the sheet name with single quotes ( ' ) and . . . you will get what you want.

I hope this helps, please be sure to let me / us know.

Sliderule
Back to top
View user's profile Send private message
hihat
Newbie
Newbie


Joined: 11 Dec 2006
Posts: 2

PostPosted: Mon Dec 11, 2006 1:56 pm    Post subject: Reply with quote

Dear One

Thanks for the suggestion. I really thought I tried that one before I posted, but appearantly I must have done s.th. else wrong that time because...

...now it works

Thanks buddy, have a nice advent season

David
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group