[Libreoffice-bugs] [Bug 124093] New: EDITING Selecting filtered cells with hidden rows in between causes a bug in filter reset.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124093
           Summary: EDITING Selecting filtered cells with hidden rows in
                    between causes a bug in filter reset.
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: j.ragan at ms.pl

Description:
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
visible cells).
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
provided file)
3.Make your own selection in the filtered range (but don't select cells outside
filter range)
4.Reset filter

Actual Results:
Cells outside user selection still have filter applied.

Expected Results:
Reset filter should completely remove applied filter from active sheet.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
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-3.3.0.4

4.0.0.1 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)

5.4.7.2 (x64) Build ID: c838ef25c16710f8838b1faec480ebba495259d0

6.1.1.2 (x64) Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b

6.3.0.0.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c

-- 
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/20190315/6ca7d6e4/attachment.html>