Bug ID: 124093
Summary: EDITING Selecting filtered cells with hidden rows in
between causes a bug in filter reset.
Version: 3.3.0 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
When column or range is filtered by some criteria and in result some rows are
hidden, there is a potential to trigger a bug in filter reset function. To
trigger it, the user has to make a partial selection with hidden rows in
between. If the user decides to reset the filter with his selection still
active (or being the last selection in that column), then using reset filter
option will reset only the last selection, leaving some rows still hidden (with
filter applied, selecting rows and pressing delete removes content only from
To fix the sheet, the user has to apply any standard filter and reset it
without making selection.
Steps to Reproduce:
1.Select a column or columns to filter out the duplicates
2.Set criteria for filter (non empty + no duplication will work best in the
3.Make your own selection in the filtered range (but don't select cells outside
Cells outside user selection still have filter applied.
Reset filter should completely remove applied filter from active sheet.
User Profile Reset: Yes
OpenGL enabled: Yes
This bug causes loss of ability to add columns on left or right from context
menu (try adding columns with context menu on Sheet2), and also causes loss of
ability to paste multi row selection from other sheets if there is a collision
with hidden rows (try copying rows from Sheet1 to Sheet2).
The result of this bug is saved to the file, please see Sheet2
The bug has been reproduced in the following builds:
3.3.0 OOO330m19 (Build:6) tag libreoffice-188.8.131.52
184.108.40.206 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)
220.127.116.11 (x64) Build ID: c838ef25c16710f8838b1faec480ebba495259d0
18.104.22.168 (x64) Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
22.214.171.124.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c
You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list