Apache OpenOffice (AOO) Bugzilla – Issue 89549
autofilter custom (standard) options lacking
Last modified: 2008-05-29 18:45:37 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.
Created attachment 53706 [details] This is my Excel Pricelist with the macros and filters
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.
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.
Please use the IssueTracker's search facilities before filing an issue. Thanks. *** This issue has been marked as a duplicate of 35579 ***
Closing dup.