Bug 149098 - Changing Standard Filter condition does not work unless you also update the value
Summary: Changing Standard Filter condition does not work unless you also update the v...
Status: RESOLVED DUPLICATE of bug 149907
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.3.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2022-05-15 14:54 UTC by pavelz
Modified: 2023-09-17 06:05 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Test Case (7.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-20 05:42 UTC, flywire
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pavelz 2022-05-15 14:54:43 UTC
Description:
When Standard Filter is set and you only want to change the condition (e.g. change '=' to '<>') it does not work unless you also update the value.

Steps to Reproduce:
1. Set a standard filter, e.g. A = 1
2. Change the condition of the standard filter, e.g. to A > 1 (without updating the value 1) and click OK.

Actual Results:
The standard filter is not changed, the condition remains the same.

Expected Results:
The standard filter should be changed according to the new condition.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.3.3.2 / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 4; OS: Linux 5.17; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Flatpak
Calc: threaded
Comment 1 m_a_riosv 2022-05-17 10:19:34 UTC
Reproducible
Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: fe687d1b8f5305edfb167152a4fb19ffa20c5404
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: threaded
Comment 2 pavelz 2022-08-29 16:19:42 UTC
Still reproducible in 7.4

Version: 7.4.0.3 / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: cs-CZ
Flatpak
Calc: threaded
Comment 3 flywire 2023-02-20 05:42:00 UTC
Created attachment 185483 [details]
Test Case

standard-filter-fails.ods has Standard filter set to Test = 1

1. Select the Filter dropdown icon
2. Filter by Condition
3. Standard Filter
4. Change condition to <>
5. OK
6. Filter fails
7. Inspection shows filter not changed
Comment 4 flywire 2023-02-20 05:43:02 UTC
Version: 7.5.0.2 (X86_64) / LibreOffice Community
Build ID: c0dd1bc3f1a385d110b88e26ece634da94921f58
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded
Comment 5 ady 2023-02-20 12:35:28 UTC
See also bug 149907 comment 7
Comment 6 TANAKA Hidemune 2023-04-11 11:26:23 UTC
Reproducible

Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 24; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: CL threaded
Comment 7 Kira Tubo 2023-09-17 06:05:42 UTC
Results of bibisect same as in bug 149907, so I think they're the same bug.

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