summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2013-02-02 18:15:55 +0100
committerEike Rathke <erack@redhat.com>2013-02-02 18:16:36 +0100
commit9d1324d750a07a0209460363b70742db374748ad (patch)
treecd69cfa5110c71f1590daa49ba536389f76eff5b
parent22a722320e5c7c94eacd8aab707c941755b08512 (diff)
fdo#57180 return #VALUE! error if a number couls not be parsed
Change-Id: I25ed88b30329b92f80efd329243f85b271d972a7
-rw-r--r--sc/qa/unit/ucalc.cxx2
-rw-r--r--sc/source/core/tool/interpr1.cxx2
2 files changed, 2 insertions, 2 deletions
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();
}