https://bugs.documentfoundation.org/show_bug.cgi?id=111730
stefan_lange...@t-online.de <stefan_lange...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |stefan_lange...@t-online.de
--- Comment #4 from stefan_lange...@t-online.de <stefan_lange...@t-online.de>
---
Created attachment 144244
--> https://bugs.documentfoundation.org/attachment.cgi?id=144244&action=edit
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)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
