In Excel xls format I have a spreadsheet which keeps track of my dvd collection. Used to Select All, turn on Autofilter, click the arrow at top of column and select Custom, then would enter *frost* to bring up list of everything with "frost" in the dvd title.
Cannot figure out how to do this simple thing in Openoffice Calc (I'm using version 2.0). I get as far as the Autofilter arrow at the top of the column then the only option seems to be Standard (no Custom filter in sight). Have selected the DVD Title heading for the first column, tried every option listed in middle column =, ,>,etc. with *frost* and with .*frost.* (something Google mentioned) in the Value box in the third column but just get blank page each time.
Yes I get the drop-down list with Autofilter turned on but this doesn't do what I want.
As an example supposing I want to know which DVDs of A Touch of Frost I have in my collection. If I scroll down the drop-down list they should appear under "A Touch of Frost" but sometimes I forget to put A at the front so some DVDs might be under "Touch of Frost".
That is why I used the Custom Filter in Excel so that I could definitely see all in one list which titles I have and eliminate the danger of ordering the same title again.
OpenOffice doesn't seem to have this. Closest I have so far found is the Find function but this only takes me to each title one at a time. I would much prefer a complete list.
Are there any other free spreadsheet programs that have the Excel Custom Filter functionality?
Using OpenOffice Calc 3.2 then you filter the list then instead of clicking on "a touch of frost" or "touch of frost" you then click on standard filter this then brings up a window in this you should insert the field name eg Title (the heading at the top of the column) = a touch of frost and then on the next line or (note don't use and) the title again, =, touch of frost. This gives you the result you want.