commit df8ae4fddb77f5621f651f05e72f8c2bd4ae111b
author Eike Rathke <erack@redhat.com> Wed Apr 19 21:45:22 2023 +0200
committer Eike Rathke <erack@redhat.com> Thu Apr 20 14:32:46 2023 +0200
tree da15fa0131f3f40e763f58ef5c81bd262dda9356
parent 0ed12710d743e12501292d688caf6e4a72f16376

Related: tdf#154915 #NULL! is not an "Internal syntactical error"

... but "Error: No code or intersection".

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

sc/inc/globstr.hrc

diff --git a/sc/inc/globstr.hrc b/sc/inc/globstr.hrc
index 16fce3f..0aa8d01 100644
--- a/sc/inc/globstr.hrc
+++ b/sc/inc/globstr.hrc
@@ -239,6 +239,7 @@
#define STR_NO_MACRO                            NC_("STR_NO_MACRO", "#MACRO?")
#define STR_LONG_ERR_NO_MACRO                   NC_("STR_LONG_ERR_NO_MACRO", "Error: Macro not found")
#define STR_LONG_ERR_SYNTAX                     NC_("STR_LONG_ERR_SYNTAX", "Internal syntactical error")
#define STR_LONG_ERR_NO_CODE                    NC_("STR_LONG_ERR_NO_CODE", "Error: No code or intersection")
#define STR_LONG_ERR_ILL_ARG                    NC_("STR_LONG_ERR_ILL_ARG", "Error: Invalid argument")
#define STR_LONG_ERR_ILL_PAR                    NC_("STR_LONG_ERR_ILL_PAR", "Error in parameter list")
#define STR_LONG_ERR_ILL_CHAR                   NC_("STR_LONG_ERR_ILL_CHAR", "Error: Invalid character")

sc/source/core/data/global.cxx

diff --git a/sc/source/core/data/global.cxx b/sc/source/core/data/global.cxx
index 61c8737..0216759 100644
--- a/sc/source/core/data/global.cxx
+++ b/sc/source/core/data/global.cxx
@@ -391,9 +391,11 @@ OUString ScGlobal::GetLongErrorString(FormulaError nErr)
        case FormulaError::UnknownOpCode:
        case FormulaError::UnknownStackVariable:
        case FormulaError::UnknownToken:
        case FormulaError::NoCode:
            pErrNumber = STR_LONG_ERR_SYNTAX;
        break;
        case FormulaError::NoCode:
            pErrNumber = STR_LONG_ERR_NO_CODE;
        break;
        case FormulaError::CircularReference:
            pErrNumber = STR_LONG_ERR_CIRC_REF;
        break;