Apache OpenOffice (AOO) Bugzilla – Issue 108389
Only one AutoFilter allowed in a Calc Workbook
Last modified: 2010-01-17 14:56:41 UTC
Open Calc. Create a small list of numbers in one column (only one column required to demo the problem) with a header row. Go to Data menu and setup a filter - Autofilter on this data Now repeat this on a second worksheet within the same workbook. Once the second autofilter is setup, the first one will disappear. And recreating it on the first worksheet will cause it to disappear from the second worksheet. It seems like only one autofilter is allowed per workbook which looks like a bug. Also posted in Ubuntu Launchpad as it was on Karmic 9.10 https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/508714
You have to name the data range. Then you can have as many auto filters as you want. There is only one anonymous filter pro document. *** This issue has been marked as a duplicate of 12666 ***
closing, duplicate