| View previous topic :: View next topic |
| Author |
Message |
scoazera
General User
Joined: 23 Sep 2006
Posts: 39
|
 Posted: Sat Mar 08, 2008 9:39 am Post subject: Multiple filters in one sheet |
 |
|
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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
evilpilch
Newbie
Joined: 06 Mar 2012
Posts: 1
|
| Posted: Tue Mar 06, 2012 8:01 am Post subject: |
|
|
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 |
|
|
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 330
Location: victoria
|
| Posted: Tue Mar 06, 2012 2:59 pm Post subject: |
|
|
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 |
|
|
|
