Created attachment 149441 [details] autofilter demo steps to reproduce: - open attached spreadsheet - filter as shown in picture - autofilter icons are enabled on sheet "Result" - apply filter - save & reload - autofilter icons disappeard - filtered rows are hidden IMHO the Autofilter icons should not appear on sheet "Result".
Not for me with Version: 6.2.1.1 (x64) Build ID: 757c58e8cb70b2982843211a54750fb3cd79acd5 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded
(In reply to Oliver Brinzing from comment #0) > Created attachment 149441 [details] > autofilter demo > > steps to reproduce: > > - open attached spreadsheet > - filter as shown in picture > - autofilter icons are enabled on sheet "Result" > - apply filter > - save & reload > - autofilter icons disappeard > - filtered rows are hidden > > IMHO the Autofilter icons should not appear on sheet "Result". Olivier, what varsion of LO and what OS do you use?
(In reply to Roman Kuznetsov from comment #2) > Olivier, what varsion of LO and what OS do you use? lo version is: Version: 6.1.5.2 (x64) Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc:
Created attachment 149495 [details] filter result after save and reload attached pdf shows, the autofilter icons are lost on save and reload from sheet "Result"
checked with Version: 6.2.1.1 (x64) Build-ID: 757c58e8cb70b2982843211a54750fb3cd79acd5 CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: same result: autofilter icons are lost on save & reload from sheet "Result"
I can confirm with Version: 6.3.0.0.alpha0+ Build ID: 465939feb0e9c382e5581b53b72008979ece4807 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; and Version: 4.1.0.0.alpha1+ Build ID: 863d38fbfa4fb4861e476828c46410602100919
for the Bug Hunting Session 7.0.0.0.a1+: OP behaviour still repro, buttons on sheet Result are gone after re-load, but filtering condition - tried with c="33" - is still active, if i re-activate autofilter in the data on sheet Result i get a filtered condition for col C, blue dotted triangle, with '33' checked and '333' unchecked in the dropdown,
I reproduce as in the Description with: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 94d552f94b427f884c004dba5d4619ecf729d605 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-18_13:30:27 Calc: threaded I agree with the original comment that there shouldn't be any AutoFilter menu at all in the copy in the first place, but instead only a static copy of the data show when filtering. (Especially given that the AutoFilter menu in the copy is useless: it can't be used to reset the filter and show all the original data.)
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/15684e5d595289e0a94efd80bbe203ca133845f2 tdf#123598 sc UI: don't show autofilter dropdown arrows It will be available in 7.3.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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/aab72a3f9a8d51403428098c7a4324b41236c5e6 tdf#123598 sc UI: don't show autofilter dropdown arrows It will be available in 7.2.0.2. 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d1f1f546b212ecd651146addeb328806bb270d5f CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded