Created attachment 135490 [details] zip-File with 2 spreadsheets to reproduce resp. demonstrate the problems There are several problems at "Reset Filter", when Auto filters are set. Case 1: Auto filters are located in the first row. - open the test file "Test Reset Filters V0.ods" from attached zip file - select one of the not empty cells - click on any autofilter icon and select any entries, but not "(empt"! [-> why not "(empty)"? / in german version "(leer)" - OK!] --> Result: displayed are the rows with selected entries, but no emtpy rows - select any cell so, that Data -> More Filters -> Reset Filter is enabled - do: Data -> More Filters -> Reset Filter --> Result: not empty rows are displayed (OK), but empty rows are still not displayed (IMHO a Bug)! Problem: The Autofilter lists do no longer contain the entries "(empt" and I haven't found any way that they are shown in the lists again (IMHO a Bug) - except "Undo" until they are shown in the lists again. The empty rows can be shown by select the wole sheet and Format -> Rows -> Show, but after this the empty lines can't be de-selected by any filter. Reproduced in LO 5.4.0.3 and LO 6.0.0.0.alpha0+. In LO 5.3.5 I couldn't reproduce the problem because there is no way to de-select by filter empty entries. Case 2: Auto filters are not located in the first row, but in the second or later. - open the test file "Test Reset Filters V0_2a.ods" from attached zip file - select one of the not empty cells - click on any autofilter icon and select any entries - select or de-select "(empt" --> Result: displayed are the rows with selected entries, when "(empt" was de-selected, no emtpy rows are displayed - select any cell so, that Data -> More Filters -> Reset Filter is enabled - do: Data -> More Filters -> Reset Filter --> Results: - not empty rows are displayed (OK), but when "(empt" was de-selected before, empty rows are still not displayed (IMHO a Bug)! - no AutoFilter lists are updated, means the arrows of filters set before are still blue instead black and contents of all lists is in state before "Reset Filter" is done (IMHO a Bug) Problem: When after this "Undo Filter" is done, all AutoFilters are deactivated (IMHO a Bug).
I forgot - to case 2: Reproduced in In LO 5.3.5, LO 5.4.0.3 and LO 6.0.0.0.alpha0+.
When an Autofilter is created without select the data, it selects up to the last not empty row, so when the filter it's created againg after reset, seems fine not having <empty> for select. On the sample file the data for the 'AutoFilter' covers all sheet rows: <table:database-ranges> <table:database-range table:name="__Anonymous_Sheet_DB__0" table:target-range-address="Tabelle1.A1:Tabelle1.B1048576" table:display-filter-buttons="true" table:orientation="column"/> </table:database-ranges> this is why <empty> it's selectable. But looks like a bug not showing empty rows after reset the filter.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Created attachment 144244 [details] zip file with 2 new sheet documents to show the actual probems with reset filter The behavior of Autofilter and Reset Filter was changed from LO 5.x to LO 6.1 and with my "original" test files I can't reproduce the problems as described. But there are still problems at Reset Filter when there are completely empty rows within a sheet. I could close this bug and report a new, but first I describe the actual problems. For demonstration I attach a zip file with 2 sheet documents. Test case 1: ------------ - open "Test Reset Filters V0b2.ods" (Autofilter in the first row, 2 empty rows within the sheet) - filter out in column B values b4 and b5 - Autofilter lists contain values (empty) + a1..a3 for column A (OK) and (empty) + b1..b3 (checked) + b4..b5 (unchecked) for column B (OK) - position cursor in one of cells A1..A4 or B1..A4 - Reset Filter - Result: only rows 1..4 are displayed, Autofiter lists contain only values a1..a3 (column A) and b1..b3 (column B) Variation 1: - after filter out cells position cursor in cell A5 or B5 before Reset Filter - Result of Reset Fiter: Rows 1..6 are dieplayed, Autofilter lists contain values (empty), a1..a4 resp. (empty), b1..b4 Variation 2: - after filter out cells position cursor in cell B7 before Reset Filter - Result of Reset Fiter: Rows 1..5 and 7 + 8 are dieplayed (not row 6!), Autofilter lists contain values (empty), a1..a3 for column A resp. (empty) + b1..b3 (checked) + b4 and b5 (unchecked) for column B Test case 2: ------------ - open "Test Reset Filters V0_2ab.ods" (Autofilter in the second row, 1 empty row within the sheet) - filter out in column B values b4 and b5 - Autofilter lists contain values (empty) + a1..a3 for column A (OK) and (empty) + b1..b3 (checked) + b4..b5 (unchecked) for column B (OK) - position cursor in cells A2..A5 or B2..A5 - Reset Filter - Result: displayed rows and Autofilter lists are not changed Variation: - after filter out cells position cursor in cells A2..A5 or B2..A5 and Select all before Reset Filter - Result of Reset Filter: all rows are displayed, but Autofilter lists are not changed and the Autofilter Array is blue (means cells are filtered)
Supplement to Comment 4: I have tested with Version: 6.1.0.3 (x64) Build-ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU-Threads: 4; BS: Windows 10.0; UI-Render: GL; Gebietsschema: de-DE (de_DE); Calc: CL
Dear Stefan_Lange_KA@T-Online.de, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
As written in Comment_4 I will close this bug and check if a new bug must be reported.