Created attachment 167138 [details]
test xlsx document
Steps to Reproduce:
1. Open the attached xlsx file;
2. Click twice the autofilter toolbar icon (i.e., clear and reset autofilter);
3. Click the autofilter dropdown in column A, then click "Standard Filter";
4. Try to type some text in the standard filter value box.
The special of this xlsx file is that, the autofilter is set in MSO by:
a. Filter and select year 2017 in column B; and
b. Filter in column A and type in "63*" in column A.
When open in LibreOffice, the filter in column A is not shown, which is a different bug and will be reported separately, but I assume it is related to this crash.
Reproduced on Fedora 32 on both 184.108.40.206 release and master as of
2020-11-08 d63b3561efb6b01a11b4a26a0e1e609699915b4d, gtk3.
Created attachment 167139 [details]
Build ID: 8ba9ecaaad1090dafa2e3040e03e532923fd38a4
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Also reproduced in
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 5.7; Render: default;
Locale: en-US (en_US.UTF-8)
Build ID: a2c9d4f8bbde97f175bae4df771273a61251f40
> The special of this xlsx file is that, the autofilter is set in MSO by:
> a. Filter and select year 2017 in column B; and
> b. Filter in column A and type in "63*" in column A.
Just to clarify, "63*" is a wildcard which in MSO matches all the records starting with 63. After b, the filtered result contains all data which has 2017 in column B and 63* in column A.
Repro 7.2+ oldest, no repro 7.2+ master. I set WFM.
Kevin, if you report multiple bugs with the same file, you need to See Also connect them.
In Linux 7.2 I bisected fix to bug 116818 do I'll mark duplicate.
*** This bug has been marked as a duplicate of bug 116818 ***
To be clear : I found this fixed in Linux.
In Windows, fileopen crashes for me, bug 141514, please test.
I think we can close this issue as RESOLVED FIXED, since this one is about the Standard filter dialog and bug 116818 is about autofilter
UItest added in https://gerrit.libreoffice.org/c/core/+/113751
A similar issue I found while working on the UItest -> bug 141547
Xisco Fauli committed a patch related to this issue.
It has been pushed to "master":
tdf#138089: sc: Add UItest
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
In libreoffice-7-1 branch, this issue is fixed by https://git.libreoffice.org/core/commit/7ba4eeb2e9b8153eb17779c93492ab80a5cd4644