[Libreoffice-bugs] [Bug 130770] New: Autofilter not updated on data change (automatically or manually)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130770
           Summary: Autofilter not updated on data change (automatically
                    or manually)
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: milan.berta at gmail.com

Description:
When filter is applied on a column and data is changed by EDITING (manually),
the filter does not update. Update by F9 (recalculate) does not update filter
either.

Steps to Reproduce:
1. create data two columns

term1   term2
a       0
b       1
a       1
b       0

2. apply autofilter on data header (1st row)

3. filter second column by 1 ([ ]0 [x]1)

Result:
term1   term2
b       1
a       1

4. edit any of the "1" to "0"

term1   term2
b       1
a       0

Result: no change in the applied filter. I have to says, that this behavior is
very fine, because the user is given an opportunity to check on changes.

5. Recalculate (by F9)

no change:
term1   term2
b       1
a       0

expected result: 
term1   term2
b       1

7. open filter dialog to the 2nd column and confirm the settings by pressing
"OK"

no change:
term1   term2
b       1
a       0

expected result:
term1   term2
b       1

Actual Results:
The filter does not update data columns on "Recalculate" or "confirming the
filter settings by OK".

Expected Results:
The filter should update the data columns on "Recalculate" and(!) "confirming
the filter settings by OK", both.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: cs-CZ (cs_CZ); 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/20200219/58ad0272/attachment.htm>