| Summary: | Autofilter can't be easily/obviously re-run against additional data | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Tim B <tin> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | aron.budea, holspam, info, libreoffice, serge.krot, telesto, vsfoote |
| Priority: | medium | Keywords: | bibisected, bisected, regression |
| Version: | 6.3.0.4 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=117276 https://bugs.documentfoundation.org/show_bug.cgi?id=140098 https://bugs.documentfoundation.org/show_bug.cgi?id=130770 |
||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 103512 | ||
| Attachments: | Example file to demonstrate the problem | ||
|
Description
Tim B
2020-05-29 09:01:50 UTC
Confirming. Simple sheet with mix of data across columns with Header row assigned. Apply autofilter to reduce shown rows. Add additional rows of the same format to sheet (i.e. create on another sheet and cut/paste) with some that match the current autofilter some that do not. Unable to 're-run' the filter against the newly added rows. Confirmed Selections must be changed and autofilter must be opened a second time. After changed data pressing "OK" should be enough to filter changed data also. Stuart, reports says it worked, so that would be a regression? (I didn't test) Created attachment 169386 [details] Example file to demonstrate the problem Example created by instructions in comment #1 - Copy the first 4 rows from Sheet2 to A11 - Drop down the filter on column B, press OK -> Filtering not updated - Drop down the filter on column A, press OK -> Filtering updated, rows containing Wolf in column A are hidden. This started to work like this in 6.3, in 6.2 and before pressing OK on Column B rerun the whole filtering as expected. Also, my Excel 2013 updates the whole filtering if column B is opened and closed with OK. This seems to have started with: https://git.libreoffice.org/core/+/4e7e3670c31329d60f5cc782abc4568c2aba33a7 author Serge Krot <Serge.Krot@cib.de> Tue Mar 05 17:03:31 2019 +0100 committer Thorsten Behrens <Thorsten.Behrens@CIB.de> Fri Apr 12 11:46:58 2019 +0200 tdf#117276 sc: autofilter was unexpected reset with OK pressed Adding CC to: Serge Krot This issue seems to be a duplicate of Bug 130770. Both issues are bibisected to the same commit 4e7e3670c31329d60f5cc782abc4568c2aba33a7. Bug 130770 is fixed since 6.4.5. (I've fixed it.) Can you verify and mark as duplicate? *** This bug has been marked as a duplicate of bug 130770 *** |