Bug 121854 - CALC: Make available wildcards with Standard and Advanced filters like in find & replace.
Summary: CALC: Make available wildcards with Standard and Advanced filters like in fin...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
Reported: 2018-12-02 01:50 UTC by m_a_riosv
Modified: 2018-12-09 13:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2018-12-02 01:50:09 UTC
Currently the wildcards are available in Functions and in Find & Replace, but not in Standard and Advanced filters. 

Steps to Reproduce:

Actual Results:

Expected Results:
Add the option in Standard and Advanced filters to use also 'Wildcars'

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Eike Rathke 2018-12-04 12:54:52 UTC
Note that ODF defines a <table:filter-condition> table:operator attribute with values 'match' and '!match' that use regular expressions, but does not define anything for wildcards, so this would need an ODF extension.
See https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1418546_253892949

Does Excel handle wildcards in its filters?
Comment 3 m_a_riosv 2018-12-04 13:46:08 UTC
In any case seems a hard task to do, so if you are agree can be closed as wontfix.
Comment 4 Eike Rathke 2018-12-04 18:32:20 UTC
Why close? It's a valid request.
Comment 5 m_a_riosv 2018-12-04 19:23:05 UTC
Of course can be valid, perhaps I misunderstood your comment.