https://bugs.documentfoundation.org/show_bug.cgi?id=149907
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|INSUFFICIENTDATA |--- Status|RESOLVED |NEW --- Comment #7 from ady <[email protected]> --- (In reply to bugfree from comment #0) > Steps to Reproduce: > 1. Highlight first row in a set of data > 2. Click Data > Auto Filter (to turn Auto Filter on) > 3. Click the drop down arrow on any column > 4. Click "Standard Filter" > 5. Select a "Condition" and "Value" and click OK > 6. The filter is displayed correctly. > 7. Now go back into the "Standard Filter" and update the "Condition" and > click OK. The "Condition" appears to change visually but it does not update > in the spreadsheet. Since others posted that they cannot repro, I am describing in detail exactly what I did. Using attachment 181160 from comment 1 posted by the OP, and following the above steps, I selected the autofilter for column D "Height (cm)", "Filter By Condition", "Standard Filter". In the Condition field I used "<", in the Value field I used "3", then OK. The list was filtered using this first condition (2 rows and the first labels' row). As the "Steps to Reproduce" say, I went back to "Filter By Condition", "Standard Filter". In the Condition field I changed it from "<" to "=", in the Value field I still used "3", then OK. The resulting list was _not_ updated. Let's add a couple more steps. Change both fields, Condition to ">" and Value to "4", then OK. => The resulting list was indeed updated. Now again change _only_ the Condition field (without even touching the Value field) from ">" to "<" (or to "="). The resulting list was _not_ updated. Just in case, I also PageDown, PageUp, to refresh the screen. Additional observation: after the list seems to be not updated, when going back to the "Condition" field in the "Standard Filter" the "Condition" doesn't show the very latest condition that was introduced, but rather the previous one. IOW, it's as if the modification of the "Condition" field was not really performed, just because the “Value” field was not modified too (whereas the user certainly did change the former). Conclusion: * If _only_ the "Condition" field is modified in the Standard Filter, then the resulting list (of filtered rows) is _not_ updated. * An alternative way of expressing it (possibly more accurate): if the "Value" field is left unchanged, then the resulting list is not updated according to the newly modified "Condition" field. Repro in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d8e6b488ceaff7c88856ebcfcfec14d2d8cd7652 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
