[Libreoffice-bugs] [Bug 122260] New: EDITING Autofilters not properly cleared

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122260

            Bug ID: 122260
           Summary: EDITING Autofilters not properly cleared
           Product: LibreOffice
           Version: 6.2.0.1 rc
          Hardware: x86-64 (AMD64)
                OS: Android
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Stefan_Lange_KA at T-Online.de

Created attachment 147747
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147747&action=edit
Sheet document in 3 states

In a sheet document I have filtered rows by Autofilter on several columns and
then I have cleared all Autofilters one after the other (set to "All").
Result: Not all rows of the sheet were displayed.
Steps to reproduce: 
1. open "Test_Autofilter_V3_no_filters_active.ods" from attached zip file
2. set autofilters:
- column A (Modell): select only "Tenax"
- column G (Sucher): select only "Klappsucher"
- column H (Spaannhebel): select only "Unterteil Blech"
3. reset autofilters:
- column G (Sucher): set to "All" (only 1 item in the list) --> filter arrow
remains blue
- column A (Modell): set to "All" (only 1 item in the list) --> filter arrow
- column H (Spannhebel): set to "All" --> filter arrow blue
Actual result:
All autofilters are set to "All", but not all rows are displayed, see attached
document "Test_Autofilter_V3_all_Autofilters_are_set_to_all.ods".
Expected result: All rows are displayed.
Further check on all autofilters with black filter arrows (not activated until
now): All are set to "All", see attached document
"Test_Autofilter_V3_all_Autofilters_are_set_to_all.ods"

The only way I have found to clear the filters and show all rows is select
"standard filter" on any column with blue filter arrow and set field name in
the first line to "- none -".

Tested with 
Version: 6.2.0.1 (x64)
Build-ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181221/9f950ca6/attachment.html>