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

[RESOLVED]STANDARD FILTER AND "CONTAIN"

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


Joined: 11 Feb 2006
Posts: 4

PostPosted: Sat Feb 11, 2006 12:58 am    Post subject: [RESOLVED]STANDARD FILTER AND "CONTAIN" Reply with quote

Hi all,

Something really boring me with OpenOffice CALC.

With filter and standard filter above cells, there is no request to sort column using term "CONTAIN" but only "=" "<" ">" etc.......
So I have to play with generic letters like: ? . *

If I forget a space or a ".", it return anything in result !!

Its really difficult and ancomfortable to use.

Is there another solution more simple ??

Thanks for help


Last edited by barbarello on Sat Feb 11, 2006 1:36 am; edited 1 time in total
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Sat Feb 11, 2006 1:19 am    Post subject: Reply with quote

I'm sure there's some advice on the forum on this subject from the more experienced users. Try a search.

I think the filter is not as easy as in Excel, but I haven't used it much yet in Calc.
Back to top
View user's profile Send private message
barbarello
Newbie
Newbie


Joined: 11 Feb 2006
Posts: 4

PostPosted: Sat Feb 11, 2006 1:35 am    Post subject: Reply with quote

You're Right
I finally found this, searching in 459 results from my criteria.... Smile

Quote:
The solution is to go Tools >Option> OpenOffice.org Calc > Calculate and remove the check mark against "Search criteria" = and <> must apply to whole cell" option.
Now the filter works perfectly.


And it's resolve my problem

Thanks for your help !!
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