Bug 138185 - Calc AutoFilter shows wrong number of shown rows when opening a doc with an active filter
Summary: Calc AutoFilter shows wrong number of shown rows when opening a doc with an a...
Status: RESOLVED DUPLICATE of bug 124701
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-13 11:49 UTC by Josete
Modified: 2020-11-13 13:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example sheet demonstrating the issue (9.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-11-13 12:57 UTC, Wolfgang Jäger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Josete 2020-11-13 11:49:23 UTC
Description:
If I activate a filter the status bar shows (for example) "10 of 200 records found".
That's right!
If I close the document and open again, the filter is still active but the status bar shows "200 of 200 records found". 
That's not true. I only see 10 lines, not 200.
It should still show "10 of 200 records found".


Steps to Reproduce:
1.Set a filter
2.Save the calc document
3.Open it

Actual Results:
The status bar shows wrong information.
It shows the total number of rows as if not filter was active.

Expected Results:
The status bar should show the right number of rows shown


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
The status bar should show the right number of active rows
Comment 1 Wolfgang Jäger 2020-11-13 12:57:51 UTC
Created attachment 167273 [details]
Example sheet demonstrating the issue

Whjen the  autofilter in the example was created, the status bar correctly reported "7 of 40 records found". Then it was saved.

If you now open it (I did with V7.0.1.2) filtering is active, and only matcj´hing rows are shown, but the status bar rports "40 of 40 records found".  

As soon as you confirm the same selection, or choose a different one, the status bar shows the correct count again.
Comment 2 Josete 2020-11-13 13:11:13 UTC
Exactly!
If I confirm the same selection, or choose a different one, the status bar shows the correct count again.
Tested on a 6.4.0.3 release (both Windows and Linux)
Comment 3 Wolfgang Jäger 2020-11-13 13:15:11 UTC

*** This bug has been marked as a duplicate of bug 124701 ***