Issue 89549

Summary:

autofilter custom (standard) options lacking

Product:

Calc

Reporter:

johansteyn <johan>

Component:

viewing

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 2.4.0

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

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.

Example:
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 
unfortunately.

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.  (www.faithful.co.za) 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 
emabarrasing.

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 
response.

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 
though.

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

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.