https://bugs.documentfoundation.org/show_bug.cgi?id=173827
--- Comment #14 from Octavio Alvarez <[email protected]> --- (In reply to ady from comment #13) > (In reply to Octavio Alvarez from comment #12) > > (In reply to ady from comment #11) > > > (In reply to Octavio Alvarez from comment #10) > > > Because Calc automatically adds a database range when importing external > > data. (Try it with View > Data Sources and importing a table). > > If that is the issue – which is barely mentioned, if at all – then this > report does not focus on that aspect of importing data. Instead, it focuses > on something completely different (i.e. autofilter) which is currently > working correctly. You are missing the point. *AutoFilter IS the issue*. I says so in the report, I says so in the subject for the report. Everything you claim I didn't say, it is said in the initial submission. The very first paragraph of this report's description clearly states what you claim I didn't say: > When data is imported from a database, a range is automatically defined > without user's knowledge. This is *the context* of the issue but this is *not* the issue! Importing data is not mentioned in the *steps* because *there is no need* to import data to replicate the issue, just to create a database range. But the context *is described*. The issue is *AutoFilter*, as I already said, and as the subject says. AutoFilter (or its documentation) is the issue because it behaves in direct contradiction to what the help text says. Again, from comment 10, the help says: > When no cell range is selected, the AutoFilter will apply to the column up to > the first empty cell. Please ensure that you select the appropriate range > before applying the AutoFilter. This is not true as it is stated, because a database range is considered before all this. And it says that selecting an appropriate range (cell range, from context) *will* create an expected AutoFilter, not 2 AutoFilters, not independent AutoFilters. And the Guide says: > It is possible to add AutoFilters to individual columns by selecting those > columns before choosing Data > AutoFilter, clicking the AutoFilter icon, or > pressing Ctrl+Shift+L, but this is not normally necessary for a database > table. Even if it were correctly documented as to the current behavior, there is room for improvement: just select the range to AutoFilter, apply, and we should get one single AutoFilter in which all columns can combine instead of independent AutoFilters. -- You are receiving this mail because: You are the assignee for the bug.
