https://bugs.documentfoundation.org/show_bug.cgi?id=141893
Buovjaga <ilmari.lauhakan...@libreoffice.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ilmari.lauhakangas@libreoff | |ice.org Whiteboard| QA:needsComment | --- Comment #6 from Buovjaga <ilmari.lauhakan...@libreoffice.org> --- (In reply to Colin from comment #0) > Steps to Reproduce: > 1 Create a list of 8 unique events at B:4 and then replicate them 5 times. > 2 At B:3, create a label "Events" and an AutoFilter from the toolbar using > the "Events" label > 3 Mouse select the label and all events > 4 Data>More Filters>Advanced Filter > > Observation - the process fails if the selected column of data - step 3 - > doesn't include the label "Events" or has NOT previously been > selected/focused prior to 4&5 > > 5 From within the little Advanced filter pane AGAIN select the entire data > column - NOT the column in its entirety > 6 Expand >options > 7 Select >No duplicates > 8 Select >Copy results to > 9 Mouse select E:3 which is conveniently adjacent to the Filtered List > commencing B3 Using your attachment 171403, I removed the AutoFilter from B3 and created it again. At this step 9, when I click OK, I get this warning and nothing happens: This range does not contain a valid query. It focuses me to the Read Filter Criteria From field, where I have $Sheet1.$B$4:$B$46 Please advise. Arch Linux 64-bit Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 3a4a12b3801b0b88d119c6e7aaca1e183f7e470f CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 29 April 2022 -- You are receiving this mail because: You are the assignee for the bug.