Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||autofilter custom (standard) options lacking|
|Status:||CLOSED DUPLICATE||QA Contact:||issues@sc <issues>|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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