https://bugs.documentfoundation.org/show_bug.cgi?id=124701
Bug ID: 124701
Summary: EDITING existing spreadsheet: counting the number of
autofiltered records doesn't work
Product: LibreOffice
Version: 6.3.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice Calc shows the number of shown records in the status bar at the
bottom when an autofilter is applied in the active column (like: “6 of 9
records found”). This works well until the file is saved and then reopened. The
filter is still applied but the status bar shows the value as if every record
would be shown (like: “9 of 9 records found”). Changing the filter settings
updates the value showing the correct value once again, until the file is
reloaded again. The issue can be reproduced both with using ODS or XLSX format
for saving the spreadsheet.
Steps to Reproduce:
1. Create a new spreadsheet in LibreOffice Calc.
2. Fill the first few rows in the A column with (preferably repeating)
values.
3. Apply an AutoFilter to the first column and filter out a few results.
4. Check the status bar: it should show the correct number of filtered
records (like: “7 of 10 records found”)
5. Save the file as ODS.
6. Reload the file and check the value of filtered records in the status
bar.
Actual Results:
The status bar shows the wrong value, as if every record would be shown (like:
“9 of 9 records found”)
Expected Results:
The status bar should show the correct value for the number of filtered
records, even after saving and reloading the file.
Reproducible: Always
User Profile Reset: No
Additional Info:
LibreOffice details:
Version: 6.3.0.0.alpha0+ (x64)
Build ID: 74288f5af28de3d14044c951e7e5d62bb2e22301
CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win;
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-12_00:11:21
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
