sc/source/core/tool/interpr1.cxx | 12 ++++++++++++
1 file changed, 12 insertions(+)
New commits:
commit b7a53077fd592c514d2f255cc19e4f0deb483dca
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Tue May 5 18:31:17 2020 +0200
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Tue May 5 21:33:47 2020 +0200
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 <er...@redhat.com>
Tested-by: Jenkins
diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 839c5135d665..644783757893 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;
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
