fix another assertion related to string length in calc functions

Change-Id: I6ef2091c9c5aea500b3af1b78acc954cd892acad

1 files changed, 3 insertions, 2 deletions

diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 3c411008a40d..ad1e72000645 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -7798,7 +7798,7 @@ void ScInterpreter::ScLeft()
     sal_uInt8 nParamCount = GetByte();
     if ( MustHaveParamCount( nParamCount, 1, 2 ) )
     {
-        xub_StrLen n;
+        sal_Int32 n;
         if (nParamCount == 2)
         {
             double nVal = ::rtl::math::approxFloor(GetDouble());
@@ -7808,11 +7808,12 @@ void ScInterpreter::ScLeft()
                 return ;
             }
             else
-                n = (xub_StrLen) nVal;
+                n = (sal_Int32) nVal;
         }
         else
             n = 1;
         OUString aStr = GetString().getString();
+        n = std::min(n, aStr.getLength());
         aStr = aStr.copy( 0, n );
         PushString( aStr );
     }