sc/source/core/tool/interpr1.cxx | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 2107e08fe4798d48610f7472fa581103462081aa Author: Eike Rathke <[email protected]> AuthorDate: Fri Oct 26 11:25:47 2018 +0200 Commit: Eike Rathke <[email protected]> CommitDate: Fri Oct 26 15:23:49 2018 +0200 Let REGEX() return #N/A instead of #VALUE! if no match, tdf#113977 follow-up So match can be checked with IFNA(REGEX(...);...) and IF(ISNA(REGEX(...);FALSE();TRUE()) Change-Id: I2b75dce78ad8a955aa6f94ea5d225a79ae0e2dc5 Reviewed-on: https://gerrit.libreoffice.org/62386 Reviewed-by: Eike Rathke <[email protected]> Tested-by: Jenkins diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx index 020a9cc56b3a..414cb8a19ba3 100644 --- a/sc/source/core/tool/interpr1.cxx +++ b/sc/source/core/tool/interpr1.cxx @@ -9248,7 +9248,7 @@ void ScInterpreter::ScRegex() utl::TextSearch aSearch( aParam, *ScGlobal::pCharClass); const bool bMatch = aSearch.SearchForward( aText, &nPos, &nEndPos, &aResult); if (!bMatch) - PushNoValue(); + PushError( FormulaError::NotAvailable); else { assert(aResult.subRegExpressions >= 1); _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
