Related: tdf#127293 Fix regex search mode in XLOOKUP wildcards mode
If relevant Option in Calc was set for regex, xlookup still used the
wildcard search mode.
Change-Id: I318c3f368b6f59644c43ec518542910be72a5e0c
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/166015
Tested-by: Jenkins
Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 8ea81b3..6f3c330 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -11455,14 +11455,7 @@ bool ScInterpreter::SearchVectorForValue( VectorSearchArguments& vsa )
if ( mrDoc.IsInVBAMode() )
rParam.eSearchType = utl::SearchParam::SearchType::Wildcard;
else
{
// set searchtype hard to wildcard or regexp if applicable, the XLOOKUP
// argument prevails over the configuration setting
if ( MayBeWildcard( vsa.sSearchStr.getString() ) )
rParam.eSearchType = utl::SearchParam::SearchType::Wildcard;
else if ( MayBeRegExp( vsa.sSearchStr.getString() ) )
rParam.eSearchType = utl::SearchParam::SearchType::Regexp;
}
rParam.eSearchType = DetectSearchType(vsa.sSearchStr.getString(), mrDoc);
}
}
else
