commit 8dc4bea8323783b4abbf8010c492bf8d8de76481
author Eike Rathke <erack@redhat.com> Tue Mar 14 00:41:02 2023 +0100
committer Eike Rathke <erack@redhat.com> Tue Mar 14 14:02:08 2023 +0000
tree 036d727779d5b169c6a7f0036faacffbbed4a8bb
parent 1bc004f67feb51beb00113cedd5f98a1e6e2bcdd

Resolves: tdf#154167 ERROR.TYPE(#NULL!) must return 1

Error #NULL! is an alias of FormularError::NoCode Err:521 that is also
mapped to import/export Excel docs. ParameterExpected Err:511 was wrong.

Change-Id: I08dc4e5747cb6c6ab7c2b309b02b942340ed4484
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148820
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins

sc/source/core/tool/interpr1.cxx

diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 94dd944..a73be31 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -10036,7 +10036,7 @@ void ScInterpreter::ScErrorType_ODF()

    switch ( nErr )
    {
        case FormulaError::ParameterExpected :  // #NULL!
        case FormulaError::NoCode :             // #NULL!
            nErrType = 1;
            break;
        case FormulaError::DivisionByZero :     // #DIV/0!
@@ -10054,7 +10054,7 @@ void ScInterpreter::ScErrorType_ODF()
        case FormulaError::IllegalFPOperation : // #NUM!
            nErrType = 6;
            break;
        case FormulaError::NotAvailable :          // #N/A
        case FormulaError::NotAvailable :       // #N/A
            nErrType = 7;
            break;
        /*