https://bugs.documentfoundation.org/show_bug.cgi?id=158185
--- Comment #3 from Mike Kaganski <[email protected]> --- Excel supports wildcards in searches, including autofilters; but they are limited to the three characters that Eike implemented in LI 5.2 [1]. E.g., a search string like "?a" should find both the cells. So the fix should be sanitizing the VBAToRegexp function, which is only used here in sc/source/ui/vba/vbarange.cxx. Note that wildcards are alsoo used in ScInterpreter::ScMatch, which has lines if (rItem.meType == ScQueryEntry::ByString) { bool bIsVBAMode = mrDoc.IsInVBAMode(); if ( bIsVBAMode ) rParam.eSearchType = utl::SearchParam::SearchType::Wildcard; else ... Maybe it might be unified... [1] https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS/XLSX_and_with_ODF_1.2 -- You are receiving this mail because: You are the assignee for the bug.
