[Libreoffice-bugs] [Bug 138438] New: CALC AutoFilter Top 10 malfunctions when another column is already filtered

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138438
           Summary: CALC AutoFilter Top 10 malfunctions when another
                    column is already filtered
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
When an array column has been filtered to exclude a number of specific entries
the selection of "top 10" in any other column's filter returns an empty array.
When the recalcitrent filter is then amended to select "all" it remains empty -
the "all" selection is simply ignored.
Choosing  "Not Empty" then re-establishes a positive array which can be further
manipulated. "All" can then be selected and functions as expected.

Steps to Reproduce:
Sample File "Filter Error" attached
Column B has already been filtered to sort inverted and column C has been
filtered to exclude the final 6 days of November.
1 Filter column J "Top Ten" - observe the effect
2 Filter column J "All" - observe the effect
3 Filter column J "Not Empty" - observe the effect
4 Filter column C "All" - observe the effect
5 Repeat steps 1 & 2 - observe the effect

Note: The division by zero error in K3 & L3 is obviously anticipated 


Actual Results:
Entire array disappears

Expected Results:
Top 10 filter


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
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/20201123/89800dc3/attachment-0001.htm>