sc/source/core/tool/interpr8.cxx |   15 ++++++---------
 1 file changed, 6 insertions(+), 9 deletions(-)

New commits:
commit f4f2c94513e7d06691a73d9f12707c33d131d537
Author:     Eike Rathke <er...@redhat.com>
AuthorDate: Wed Oct 20 13:41:03 2021 +0200
Commit:     Eike Rathke <er...@redhat.com>
CommitDate: Wed Oct 20 16:38:11 2021 +0200

    Resolves: tdf#145235 TEXTJOIN() clear last string also for referenced empty
    
    Change-Id: If6d20a1629e001708c700c5c25bef8a75fa34e25
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/123889
    Reviewed-by: Eike Rathke <er...@redhat.com>
    Tested-by: Jenkins

diff --git a/sc/source/core/tool/interpr8.cxx b/sc/source/core/tool/interpr8.cxx
index b11ccec62428..2c2f1c212b3f 100644
--- a/sc/source/core/tool/interpr8.cxx
+++ b/sc/source/core/tool/interpr8.cxx
@@ -1742,17 +1742,14 @@ void ScInterpreter::ScTextJoin_MS()
                         aAdr.SetRow( nRow );
                         aAdr.SetCol( nCol );
                         ScRefCellValue aCell( mrDoc, aAdr );
-                        if ( !aCell.isEmpty() )
+                        if (aCell.hasEmptyValue())
+                            aStr.clear();
+                        else
                         {
-                            if ( !aCell.hasEmptyValue() )
-                            {
-                                svl::SharedString aSS;
-                                GetCellString( aSS, aCell);
-                                aStr = aSS.getString();
-                            }
+                            svl::SharedString aSS;
+                            GetCellString( aSS, aCell);
+                            aStr = aSS.getString();
                         }
-                        else
-                            aStr.clear();
                         if ( !aStr.isEmpty() || !bSkipEmpty )
                         {
                             if ( !bFirst )

Reply via email to