From 9d1324d750a07a0209460363b70742db374748ad Mon Sep 17 00:00:00 2001
From: Eike Rathke <erack@redhat.com>
Date: Sat, 2 Feb 2013 18:15:55 +0100
Subject: fdo#57180 return #VALUE! error if a number couls not be parsed

Change-Id: I25ed88b30329b92f80efd329243f85b271d972a7
---
 sc/qa/unit/ucalc.cxx             | 2 +-
 sc/source/core/tool/interpr1.cxx | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

(limited to 'sc')

diff --git a/sc/qa/unit/ucalc.cxx b/sc/qa/unit/ucalc.cxx
index 09ada380d786..f29bac11f696 100644
--- a/sc/qa/unit/ucalc.cxx
+++ b/sc/qa/unit/ucalc.cxx
@@ -779,7 +779,7 @@ void testFuncNUMBERVALUE( ScDocument* pDoc )
     } aChecks[] = {
         { "=NUMBERVALUE(A1;\"b\";\"ag\")",  "199.9" },
         { "=NUMBERVALUE(A2;\"b\";\"ag\")",  "134.56789" },
-        { "=NUMBERVALUE(A2;\"b\";\"g\")",   "Err:502" },
+        { "=NUMBERVALUE(A2;\"b\";\"g\")",   "#VALUE!" },
         { "=NUMBERVALUE(A3;\"d\")",         "12.3456" },
         { "=NUMBERVALUE(A4;\"d\";\"foo\")", "0.4" },
         { "=NUMBERVALUE(A4;)",              "Err:502" },
diff --git a/sc/source/core/tool/interpr1.cxx b/sc/source/core/tool/interpr1.cxx
index 53cb552ce2d8..2ab779afb1fa 100644
--- a/sc/source/core/tool/interpr1.cxx
+++ b/sc/source/core/tool/interpr1.cxx
@@ -3472,7 +3472,7 @@ void ScInterpreter::ScNumberValue()
         PushDouble(fVal);
         return;
     }
-    PushIllegalArgument();
+    PushNoValue();
 }
 
 
-- 
cgit