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

New commits:
commit 9eed2e4f491cb4f5432157eec77e6f5b525acb8f
Author:     Karthik Godha <[email protected]>
AuthorDate: Fri Jan 2 17:49:44 2026 +0530
Commit:     Michael Stahl <[email protected]>
CommitDate: Fri Jan 2 14:01:00 2026 +0100

    tdf#170201: XLSX - empty values in array formulas
    
    LO supports empty values in array formulas but Excel doesn't. Export
    '0' when an array formula contains an empty value.
    
    Change-Id: I5f289c0bf3f98cb75dffa925245afab67641eac2
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/196421
    Tested-by: Jenkins CollaboraOffice <[email protected]>
    Reviewed-by: Michael Stahl <[email protected]>

diff --git a/sc/source/core/tool/compiler.cxx b/sc/source/core/tool/compiler.cxx
index 0ff3960bdee7..8134f4168c81 100644
--- a/sc/source/core/tool/compiler.cxx
+++ b/sc/source/core/tool/compiler.cxx
@@ -5436,7 +5436,7 @@ void ScCompiler::CreateStringFromMatrix( OUStringBuffer& 
rBuffer, const FormulaT
                 }
             }
             else if( pMatrix->IsEmpty( nC, nR ) )
-                ;
+                AppendDouble(rBuffer, 0);
             else if( pMatrix->IsStringOrEmpty( nC, nR ) )
                 AppendString( rBuffer, pMatrix->GetString(nC, nR).getString() 
);
         }

Reply via email to