Bug 159633 - UI: tables in which items can be "matched" by typing characters don't allow hyphen or underscore searches (- and _)
Summary: UI: tables in which items can be "matched" by typing characters don't allow h...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: AutoCorrect-Complete Sidebar-Styles Cell-Name
  Show dependency treegraph
Reported: 2024-02-08 06:02 UTC by 박이준
Modified: 2024-02-27 04:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

sample ODS with named ranges and test styles (11.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-27 04:45 UTC, Stéphane Guillou (stragu)

Note You need to log in before you can comment on or make changes to this bug.
Description 박이준 2024-02-08 06:02:35 UTC
When search with input keys in autocorrect table, it can't take only hyphen key words. 

Actual Results:
Enter Tools -> AutoCorrect -> AutoCorrect Options
Go "Replace" tab and click&focus word table.
press hyphen key. it doesn't work unlike others.

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: TextDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Rafael Lima 2024-02-08 13:17:58 UTC
This works fine in gtk3 but fails with kf5 (Plasma) and gen (X11).
Comment 2 Stéphane Guillou (stragu) 2024-02-27 04:38:10 UTC
Thank you both. Reproduced as well in gen VCL plugin but not gtk3.

Version: (X86_64) / LibreOffice Community
Build ID: d2fa44db6f8a1badece63856ee0f12db4cba9b28
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: x11
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

This is also visible in other searchable tables e.g. the Styles sidebar deck: typing "-" and "_" won't jump to styles named e.g. "-test" and "_test".
Same thing with Calc > Sheet > Named Ranges and Expressions > Manage (for underscore at least, as hyphens are not allowed).

For the Stylist, I can reproduce in libreoffice-, so it's a long-standing issue.

Caolán, maybe you have some insights on this?
Comment 3 Stéphane Guillou (stragu) 2024-02-27 04:45:36 UTC
Created attachment 192813 [details]
sample ODS with named ranges and test styles

Sample file to make it easy to test the filtering for named ranges and styles.

(Same issue in Gallery sidebar deck, if custom themes are added.)