Bug 152334

Summary: Autofilter doesn't work on a custom array function range
Product: LibreOffice Reporter: Mike Kaganski <mikekaganski>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: erack, g_e_fox, l.lunak
Priority: medium Keywords: bibisected, bisected, regression
Version: 7.3.0.0 alpha0+   
Hardware: All   
OS: All   
URL: https://ask.libreoffice.org/t/filtering-on-results-of-xpysort-in-calc/84731
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=139444
Whiteboard:
Crash report or crash signature: Regression By: Luboš Luňák
Bug Depends on:    
Bug Blocks: 103512    
Attachments: XPySort + autofilter

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