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

Multiple filters in one sheet

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


Joined: 23 Sep 2006
Posts: 39

PostPosted: Sat Mar 08, 2008 9:39 am    Post subject: Multiple filters in one sheet Reply with quote

In OOo 1.x I could have many autofilters in one sheet.

Is it possible to do it in OOo 2.x?

...or, at least, can I perform something similar to excel's "Data-->List..."?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Mar 08, 2008 12:42 pm    Post subject: Reply with quote

Same as in OOo1.x. You have to define a named database range explicitly (Menu:Data>Define...).
See also: http://www.oooforum.org/forum/viewtopic.phtml?p=276782#276782
Back to top
View user's profile Send private message
evilpilch
Newbie
Newbie


Joined: 06 Mar 2012
Posts: 1

PostPosted: Tue Mar 06, 2012 8:01 am    Post subject: Reply with quote

Hi Villeroy,

Any chance you can expand on your reply here please? I too could use several auto filters in one sheet. When I try and name my 'defined range' however, I just get the response: invalid name ???

What are the restrictions on naming a defined range?

Thanks.
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 400
Location: victoria

PostPosted: Tue Mar 06, 2012 2:59 pm    Post subject: Reply with quote

Help - F1
Quote:
Allowed names
Names in Calc can contain letters, numeric characters, and some special characters. Names must start with a letter or an underline character.
Allowed special characters:
underline (_)
period (.) - allowed within a name, but not as first or last character
blank ( ) - allowed within a name, but not as first or last character, and not for a cell range
Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.
Names for cell ranges must not include blanks. Blanks are allowed within names for single cells, sheets and documents.

_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
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