commit b7a53077fd592c514d2f255cc19e4f0deb483dca
author Eike Rathke <erack@redhat.com> Tue May 05 18:31:17 2020 +0200
committer Eike Rathke <erack@redhat.com> Tue May 05 21:33:47 2020 +0200
tree 7d49445c10db15dbab86b5e4e4414b1e985badef
parent e21bc1b3e587c2bd90168b24f3774d98a3837f8e

Resolves: tdf#131536 TEXT() support empty format string mimicking Excel

Change-Id: Iffc37179cafb8b8bcfa1232e7aa54ae119ab5846
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/93504
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 839c513..64478375 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -9562,6 +9562,18 @@ void ScInterpreter::ScText()
        }
        if (nGlobalError != FormulaError::NONE)
            PushError( nGlobalError);
        else if (sFormatString.isEmpty())
        {
            // Mimic the Excel behaviour that
            // * anything numeric returns an empty string
            // * text convertible to numeric returns an empty string
            // * any other text returns that text
            // Conversion was detected above.
            if (bString)
                PushString( aStr);
            else
                PushString( OUString());
        }
        else
        {
            OUString aResult;