Download it now!
Bug 142574 - Help article is required for Wildcard functionality; and disambiguation with regular expressions.
Summary: Help article is required for Wildcard functionality; and disambiguation with ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
5.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2021-05-31 06:50 UTC by Mike Kaganski
Modified: 2021-06-25 16:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2021-05-31 06:50:10 UTC
In 5.2 [1], wildcard match was added to be interoperable with Excel's matching syntax (and 5.3 made it default [2]). But the help still does not explain what wildcards are - see e.g. MATCH [3], which does not provide a clickable link on "wildcards"; and typing "wildcards" in help search gives a link to regular expressions [4] - even the help entry name in the right-hand "Contents" panel is "Using Wildcards in Text Searches".

We have an issue which mentions the need to provide help for wildcards in Find & Replace (bug 103587); this one is not related to F&R, but for spreadsheet functions. Note how the term "wildcards" is confusing - e.g., it's used in bug 91336 to denote regular expressions.

[1] https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2
[2] https://wiki.documentfoundation.org/ReleaseNotes/5.3#Option_settings
[3] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3158407
[4] https://help.libreoffice.org/latest/en-US/text/swriter/guide/search_regexp.html#bm_id3150099
Comment 1 Mike Kaganski 2021-05-31 10:16:44 UTC
FTR: release notes for 5.2 document the wildcard syntax; related MS documentation is at [1] (it tells it is related to filters - see bug 121854 - and searches), and also in related spreadsheet function documentation: e.g., [2] for MATCH.

[1] https://support.microsoft.com/en-us/office/using-wildcard-characters-in-searches-ef94362e-9999-4350-ad74-4d2371110adb
[2] https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a
Comment 2 Steve Fanning 2021-06-25 16:50:06 UTC
I included some (hopefully) useful material about wildcards in the 7.0 Calc Guide. This could be used as the basis of a help page on the topic.