[Libreoffice-bugs] [Bug 124701] New: EDITING existing spreadsheet: counting the number of autofiltered records doesn't work

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 12 09:10:23 UTC 2019


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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190412/402e1827/attachment.html>


More information about the Libreoffice-bugs mailing list