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.
