[Enhancement][Calc]autofilter works just on one sheet (only one auto-range per document)

[Zhang Lu <zh...@gmail.com>]

Currently AOO3.4 spreadsheet support only one unnamed database range
in a document, which makes auto filter and sort 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.

In this story, We want to make some improvement. With our improvement,
user can define 1 auto filter, 1 sort and 1 subtotal in each sheet,
which can co-exist in one sheet, without predefining database range
manually. This will solve an old issue, i12666

What's your suggestion?

Re: [Enhancement][Calc]autofilter works just on one sheet (only one auto-range per document)

[Andreas Säger <vi...@t-online.de>]

Am 08.08.2012 08:29, Zhang Lu wrote:
> Currently AOO3.4 spreadsheet support only one unnamed database range
> in a document, which makes auto filter and sort 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.
>
> In this story, We want to make some improvement. With our improvement,
> user can define 1 auto filter, 1 sort and 1 subtotal in each sheet,
> which can co-exist in one sheet, without predefining database range
> manually. This will solve an old issue, i12666
>
> What's your suggestion?
>

My suggestion since 2006 is this:
> https://issues.apache.org/ooo/show_bug.cgi?id=66015