Apache OpenOffice (AOO) Bugzilla – Issue 120479
Support auto filter per sheet
Last modified: 2012-08-07 10:19:42 UTC
Currently AOO3.4 spreadsheet support only one unnamed database range in a document, which makes sort, filter function can not co-exist at the same time in a same sheet, even in one document. If user wants to use filter and sort in one sheet, at least one user defined range must be defined, and at least one of this operation must be on the predefined range. It's hard to use for end user.
A very old wish. *** This issue has been marked as a duplicate of issue 12666 ***