[Libreoffice-commits] core.git: sc/source

[Libreoffice Gerrit user]

 sc/source/core/tool/interpr1.cxx |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 2107e08fe4798d48610f7472fa581103462081aa
Author:     Eike Rathke <erack at redhat.com>
AuthorDate: Fri Oct 26 11:25:47 2018 +0200
Commit:     Eike Rathke <erack at redhat.com>
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 <erack at redhat.com>
    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);