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 tree / graph
 
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
View All Add an attachment (proposed patch, testcase, etc.)

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 ***