Issue 89549

Summary: autofilter custom (standard) options lacking
Product: Calc Reporter: johansteyn <johan>
Component: viewingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.4.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
This is my Excel Pricelist with the macros and filters none

Description johansteyn 2008-05-16 10:17:49 UTC
Excel has the options of: Contain, Does not Contain, Begins with, does not 
begin with, end with, does not end with. I have waited for every new OO for 
these features to be added to no avail.  OO only accept full values which 
limmits its functionality greatly.

1  AMD 4200+ CPU
2  AMD 4400+ CPU
3  Intel 8400e CPU
4  AMD 5600+ CPU
5  1G DDR2 Memory

Filter "Contains AMD": only lists 1,2,4 or "does not contain Intel" lists the 
same, or "does not End with CPU" lists 5 etc. Can not do with OO filter 

I find it quite strange that nobody else misses these options.  This is one of 
the main reasons I still need to use Excel.  I cannot even give a OO pricelist 
on my webpage because of this.  ( I use it to create Menus 
on my pricelists.  I own Computer Shops.  I do reccomend OO, but use Excel 
myself.  I always need to explain to my customers why that is, a bit 

Otherwise I think you guys are doing great.  Cannot wait for vba to work 
propperly.  I use it extensively.  The vba is progressing nicely, but still 
needs a lot of work before it is Excel compatible.  Looking forward to a 
Comment 1 johansteyn 2008-05-16 10:27:15 UTC
Created attachment 53706 [details]
This is my Excel Pricelist with the macros and filters
Comment 2 johansteyn 2008-05-16 10:45:16 UTC
I have been able to get by with wild cards - silly me.  Just a bit cumbersome 

I would still like to see these as options added.  It would make it more user 

One more bug is that changing the autofilter adjusts my buttons' sizes.
Comment 3 johansteyn 2008-05-16 11:01:38 UTC
Wildcards does not solve the problem at all unfortunately.  <> *amd* does not 
work correctly.  This still remains an issue.  Open Office also does not 
correctly translate the filter conditions from Excel in this case.

When I load a previously filtered excel file, it looks right and the filter 
translates it to wildcard, but try to recreate it - impossible.
Comment 4 ooo 2008-05-29 18:45:12 UTC
Please use the IssueTracker's search facilities before filing an issue. Thanks.

*** This issue has been marked as a duplicate of 35579 ***
Comment 5 ooo 2008-05-29 18:45:37 UTC
Closing dup.