According to Excel 2007's default behavior, "protect Sheet" could allow users to use auto filter, but it's not default setting. Spreadsheet allows users to auto filter.
- display an Excel 2007 file
- enable a filter.
- click "Protect Sheet" on the tool-bar
- click drop-down list to change auto filter's setting
drop-down list is not displayed when clicking it. (Like Excel)
Some rows visibility is changed by auto filter.