diff options
authorKohei Yoshida <>2014-02-14 20:39:18 -0500
committerMarkus Mohrhard <>2014-02-18 00:20:54 +0000
commit30363f94b94b183f4e9b0f6d9699e76f398154dc (patch)
parenta8a4d42c15f38ed7c8595179263239f9e8b7824f (diff)
fdo#72691: Allow overwriting of string value with numeric one.
This can legitimately happen when you have a matrix with a reference to another cell inside, and the referenced cell originally contained a string value then later overwritten by a numeric value. Example. Put a "Text" in A1, and in B1 put a 1x1 matrix {=A1}. It displays "Text" in B1. Then put 11 in A1. Prior to this change, B1 would become blank. With this change, B1 will display 11. Change-Id: I3feba3a8658e1a5ebf6f9e5ac34de2d579464ddb (cherry picked from commit 9bf907a8278cecd816368db7b8c4ab745a914a59) Reviewed-on: Reviewed-by: Markus Mohrhard <> Reviewed-by: Michael Meeks <> Reviewed-by: Jacobo Aragunde Pérez <> Tested-by: Jacobo Aragunde Pérez <>
1 files changed, 3 insertions, 0 deletions
diff --git a/sc/source/core/tool/token.cxx b/sc/source/core/tool/token.cxx
index ff456eb4a12d..fc9ad75e476d 100644
--- a/sc/source/core/tool/token.cxx
+++ b/sc/source/core/tool/token.cxx
@@ -1146,6 +1146,9 @@ void ScMatrixFormulaCellToken::SetUpperLeftDouble( double f )
case svDouble:
const_cast<FormulaToken*>(xUpperLeft.get())->GetDoubleAsReference() = f;
+ case svString:
+ xUpperLeft = new FormulaDoubleToken( f);
+ break;
case svUnknown:
if (!xUpperLeft)