commit 3ed87ba36e59f774917eac49389770da404cbc06
author Matti Lehtonen <m-Matti-a.Lehtonen@IKI.Fi> Sat Oct 07 12:56:38 2017 +0300
committer Eike Rathke <erack@redhat.com> Mon Nov 20 17:08:05 2017 +0100
tree 26e582ec05501c0810ae512ed1e8be6dd89ab15b
parent 66dbd4da3afcadb1393daf9be9cecff71b86509a

tdf#89216 forward empty cells as empty to BASIC instead of 0.0

This change causes that either empty or unknown cells are forwarded to macros
as empty, not as zero (double).

Change-Id: Ia73bcb2ab48e08f97b46cdb45ae4dc3d21bbffd5
Reviewed-on: https://gerrit.libreoffice.org/43226
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>

sc/source/core/tool/interpr4.cxx

diff --git a/sc/source/core/tool/interpr4.cxx b/sc/source/core/tool/interpr4.cxx
index 6a05c5c..7285d83 100644
--- a/sc/source/core/tool/interpr4.cxx
+++ b/sc/source/core/tool/interpr4.cxx
@@ -3544,11 +3544,12 @@ bool ScInterpreter::SetSbxVariable( SbxVariable* pVar, const ScAddress& rPos )
                }
                break;
            default :
                pVar->PutDouble( 0.0 );
                pVar->PutEmpty();
        }
    }
    else
        pVar->PutDouble( 0.0 );
        pVar->PutEmpty();

    return bOk;
}