Bug 105980 - Filter lost the Regular expression after saving
Summary: Filter lost the Regular expression after saving
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency tree / graph
 
Reported: 2017-02-13 14:14 UTC by Juergen Funk (CIB)
Modified: 2023-04-12 07:34 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 Juergen Funk (CIB) 2017-02-13 14:14:44 UTC 
The Filter with Regular expression (RegExp): Only save independencies of = (match) and <> (!match), but in the GUI you can set with other Condition and works, but when save, it ignore the RegExp and lost this information. The RegExp make only sense in dependencies of =, <>. This should be handle in the GUI and than the user can see whats going on.

You can reproduce this with follwing steps:
-------------------------------------------
 1. Insert follwing in
    A1 = "Test" 
    A2 = "abc"
    A3 = "bcd"
    A4 = "cde"
 2. Go to 'Data -> More Filters -> Standartd Filter'
    Open 'Options'
      set 'Range contains column lables'
      set 'Regular expression'
      in first row set 'Field name' to "Test"
      set              'Condition'  to "Begins with"
      set              'Value'      to "a|b"
      press            'OK'
 3. the result must be 
      "abc"
      "bcd"
 4. Save file and close calc
 5. Open the file
 6. Go to Filter see 2. and in 'Options' the RegExp is not set
Comment 1 Juergen Funk (CIB) 2017-02-13 15:05:51 UTC 
It exist four solution for that problem:

1. We save the RegExp too
    Problem: Need a other format for ODF and the compatibility for older 
             vesion is very hard.

2. We remove the RegExp chackbox and insert this in the condition LisBox
    Problem: At the moment the RegExp is global for all, in this case same
             problem as solution 1 we must change the ODF format ...

3. When the RegExp ist checked, in the Condition-ListBox only can choose = <>
    Problem: When the first entry is set with other as = <> and in the second 
             you set the RegExp what to do with the first one

4. In Condition-ListBox you choose other = <> then the RegExp would be inactive
    Problem: You set the first one with = or <> but in the second you use
             other, what to do with the first one.

The best solution is a mix from 3. and 4.
Comment 2 Juergen Funk (CIB) 2017-02-27 06:39:32 UTC 
Here the patch: https://gerrit.libreoffice.org/#/c/34566/ wait of review
Comment 3 Xisco Faulí 2017-10-12 08:04:22 UTC 
Dear Juergen Funk (CIB),
This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.
Comment 4 QA Administrators 2018-10-13 03:14:04 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2020-10-13 04:46:55 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2022-10-14 03:32:45 UTC Comment hidden (obsolete)
Comment 7 ady 2023-04-12 07:34:51 UTC 
Still present.
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 375f85f8518f49ce4381b6663f1e94fc02bacf93
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