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

Noob Q: char string in Range for Name?

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


Joined: 25 Apr 2012
Posts: 1

PostPosted: Wed Apr 25, 2012 12:50 pm    Post subject: Noob Q: char string in Range for Name? Reply with quote

I imagine this must've been discussed before, but I couldn't find it...

With Calc, I open a spreadsheet chart that I was maintaining in Excel.
In Excel, one of the range names was: ="Grand Total". But this disappears in Calc.

In Calc's "Data Ranges" pop-up window, this Range for Name is blank(!), and in the "Data Series" list, instead of "Grand Total", we see "Row 6" - which, of course, is what's then presented in the legend of the chart.

I suppose I could place the words "Grand Total" in a cell and then refer to that cell in the "Range for Name".
But isn't there some way to just enter your own static char string as a "Range for Name"? Question
Back to top
View user's profile Send private message
UmTheMuse
General User
General User


Joined: 05 Apr 2012
Posts: 33
Location: United States

PostPosted: Wed Apr 25, 2012 1:26 pm    Post subject: Reply with quote

If your question is whether or not it's possible to name a data range, the answer is "yes". I guess it must not be something that translates well between the two programs, but I've used data ranges before and they work fine.

When you're in the pop-up window, you have to press Add (after entering the name) to add the data range. I used to just press OK, but that doesn't add the range.
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