Bug 152334 - Autofilter doesn't work on a custom array function range
Summary: Autofilter doesn't work on a custom array function range
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/filteri...
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: AutoFilter
  Show dependency tree / graph
 
Reported: 2022-12-01 07:06 UTC by Mike Kaganski
Modified: 2022-12-18 23:26 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
XPySort + autofilter (38.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-01 07:06 UTC, Mike Kaganski 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2022-12-01 07:06:34 UTC 
Created attachment 183933 [details]
XPySort + autofilter

1. Install XPySort.oxt from https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=56916#p474771
2. Open the attachment (taken from https://ask.libreoffice.org/t/filtering-on-results-of-xpysort-in-calc/84731/3)
3. Using the autofilter on SortedData.R1, uncheck the item "No"

In 7.3 and later versions, all the data gets filtered out, including the single 7th row that has the "Yes" value in column R. 7.2 and prior work OK, showing the row 7, as expected.

This is a regression from commit ec0edb0969c23b25576f4d1b3b2ee5d3f21990ad (optimize VLOOKUP by returning SharedString if possible (tdf#139444), 08-10-2021).
Comment 1 Stéphane Guillou (stragu) 2022-12-18 23:26:01 UTC 
repro in:

Version: 7.5.0.0.beta1 (X86_64) / LibreOffice Community
Build ID: 3aca23eec42e9d6fbe57071d7633ae1fc4bc5fcc
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded