https://bugs.documentfoundation.org/show_bug.cgi?id=173827
--- Comment #11 from ady <[email protected]> --- (In reply to Octavio Alvarez from comment #10) > Maybe there is a misunderstanding There is indeed. 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. Let's review the 2 basic possibilities regarding the desired result / effect for AutoFilter in this report, as far as I understand, with the information provided. If I say that I importing data to columns A:E, that could mean, for instance, that I importing the data from a CSV, or with some other method. I add a calculation to column F, enable AutoFilter on all 6 columns, and I have not defined any data named ranged at all. In this case, the single list has 6 headers, each with its down-arrow to apply AutoFilter, and all the 6 filters act as "AND", meaning that all conditions apply simultaneously to each row. The alternative would be to have data named ranges (instead of none). In this case, the entire list – meaning the 6 columns as a whole, including the calculated values in column F – has to be named. For the purpose of this report, it does not matter whether each column has its own data named range in addition to the data named range for the entire list. Once the entire list (all 6 columns) are considered one list (i.e. one data named range), then the AutoFilter should act on the entire list as an "AND", exactly as described. So, that basically describes the 2 cases in which the AutoFilter would behave as requested in this report for the entire list. 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. -- You are receiving this mail because: You are the assignee for the bug.
