https://bugs.documentfoundation.org/show_bug.cgi?id=173827
--- Comment #12 from Octavio Alvarez <[email protected]> --- (In reply to ady from comment #11) > (In reply to Octavio Alvarez from comment #10) > > If I take the steps you describe in comment 10, I do not understand why you > have to mix a data named range with Autofilter; some additional step or > condition is not being explained in this report. Because Calc automatically adds a database range when importing external data. (Try it with View > Data Sources and importing a table). > Taking the example provided in comment 0, you would need to define at least > 1 data named range for the 2 columns together (letters and numbers, cells > A1:B4), so the 2 columns (and their AutoFilters) would behave as 1 cohesive > list. This is how it currently works, and this is what I am reporting as problematic. Modifying the database range to include the extra columns makes "Data > Refresh Range" erase the data in extra columns, so the workflow gets unnecessarily complex, having to modify the range each time an AutoFilter or Refresh Data is needed, instead of just selecting the cell range and applying AutoFilter. It is "technically" allowed, but it results in multiple independent AutoFilters, which is unexpected, instead of a single one that combines with an AND each column filter. -- You are receiving this mail because: You are the assignee for the bug.
