https://bugs.documentfoundation.org/show_bug.cgi?id=152334
Bug ID: 152334
Summary: Autofilter doesn't work on a custom array function
range
Product: LibreOffice
Version: 7.3.0.0 alpha0+
Hardware: All
URL: https://ask.libreoffice.org/t/filtering-on-results-of-
xpysort-in-calc/84731
OS: All
Status: UNCONFIRMED
Keywords: bibisected, bisected, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: er...@redhat.com, l.lu...@collabora.com
Created attachment 183933
--> https://bugs.documentfoundation.org/attachment.cgi?id=183933&action=edit
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).
--
You are receiving this mail because:
You are the assignee for the bug.
