fdo#74014: Add unit test for pasting an unformatted text into cells.

Change-Id: I87f7b3012a2c139b0ecc3dd699ccecb31af77ac7

4 files changed, 79 insertions, 2 deletions

diff --git a/sc/inc/scopetools.hxx b/sc/inc/scopetools.hxx
index a7983e0f4831..5a16c2c46361 100644
--- a/sc/inc/scopetools.hxx
+++ b/sc/inc/scopetools.hxx
@@ -37,6 +37,15 @@ public:
     ~ExpandRefsSwitch();
 };
 
+class SC_DLLPUBLIC UndoSwitch
+{
+    ScDocument& mrDoc;
+    bool mbOldValue;
+public:
+    UndoSwitch(ScDocument& rDoc, bool bUndo);
+    ~UndoSwitch();
+};
+
 }
 
 #endif
diff --git a/sc/qa/unit/ucalc.cxx b/sc/qa/unit/ucalc.cxx
index 8cdcb4d2258a..4a9907a4453e 100644
--- a/sc/qa/unit/ucalc.cxx
+++ b/sc/qa/unit/ucalc.cxx
@@ -6,6 +6,9 @@
  * License, v. 2.0. If a copy of the MPL was not distributed with this
  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
  */
+
+#include "ucalc.hxx"
+
 #include <sal/config.h>
 #include <test/bootstrapfixture.hxx>
 
@@ -50,6 +53,8 @@
 #include "queryparam.hxx"
 #include "edittextiterator.hxx"
 #include "editutil.hxx"
+#include <asciiopt.hxx>
+#include <impex.hxx>
 
 #include "formula/IFunctionDescription.hxx"
 
@@ -72,8 +77,6 @@
 #include <sstream>
 #include <vector>
 
-#include "ucalc.hxx"
-
 struct TestImpl
 {
     ScDocShellRef m_xDocShell;
@@ -5167,6 +5170,57 @@ void Test::testCondCopyPaste()
     m_pDoc->DeleteTab(0);
 }
 
+void Test::testImportStream()
+{
+    sc::AutoCalcSwitch aAC(*m_pDoc, true); // turn on auto calc.
+    sc::UndoSwitch aUndo(*m_pDoc, true); // enable undo.
+
+    m_pDoc->InsertTab(0, "Test");
+
+    m_pDoc->SetString(ScAddress(0,1,0), "=SUM(A1:C1)");
+
+    CPPUNIT_ASSERT_EQUAL(0.0, m_pDoc->GetValue(ScAddress(0,1,0)));
+
+    // CSV import options.
+    ScAsciiOptions aOpt;
+    aOpt.SetFieldSeps(",");
+
+    ScImportExport aObj(m_pDoc, ScAddress(0,0,0));
+    aObj.SetExtOptions(aOpt);
+    aObj.ImportString("1,2,3", FORMAT_STRING);
+
+    CPPUNIT_ASSERT_EQUAL(1.0, m_pDoc->GetValue(ScAddress(0,0,0)));
+    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1,0,0)));
+    CPPUNIT_ASSERT_EQUAL(3.0, m_pDoc->GetValue(ScAddress(2,0,0)));
+
+    // Formula value should have been updated.
+    CPPUNIT_ASSERT_EQUAL(6.0, m_pDoc->GetValue(ScAddress(0,1,0)));
+
+    // Undo, and check the result.
+    SfxUndoManager* pUndoMgr = m_pDoc->GetUndoManager();
+    CPPUNIT_ASSERT_MESSAGE("Failed to get the undo manager.", pUndoMgr);
+    pUndoMgr->Undo();
+
+    CPPUNIT_ASSERT_EQUAL(0.0, m_pDoc->GetValue(ScAddress(0,0,0)));
+    CPPUNIT_ASSERT_EQUAL(0.0, m_pDoc->GetValue(ScAddress(1,0,0)));
+    CPPUNIT_ASSERT_EQUAL(0.0, m_pDoc->GetValue(ScAddress(2,0,0)));
+
+    CPPUNIT_ASSERT_EQUAL(0.0, m_pDoc->GetValue(ScAddress(0,1,0))); // formula
+
+    // Redo, and check the result.
+    pUndoMgr->Redo();
+
+    CPPUNIT_ASSERT_EQUAL(1.0, m_pDoc->GetValue(ScAddress(0,0,0)));
+    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1,0,0)));
+    CPPUNIT_ASSERT_EQUAL(3.0, m_pDoc->GetValue(ScAddress(2,0,0)));
+
+    CPPUNIT_ASSERT_EQUAL(6.0, m_pDoc->GetValue(ScAddress(0,1,0))); // formula
+
+
+    pUndoMgr->Clear();
+    m_pDoc->DeleteTab(0);
+}
+
 void Test::testMixData()
 {
     m_pDoc->InsertTab(0, "Test");
diff --git a/sc/qa/unit/ucalc.hxx b/sc/qa/unit/ucalc.hxx
index 8a4e350bab3d..8ddd6f00f449 100644
--- a/sc/qa/unit/ucalc.hxx
+++ b/sc/qa/unit/ucalc.hxx
@@ -307,6 +307,8 @@ public:
     void testCondFormatInsertCol();
     void testCondCopyPaste();
 
+    void testImportStream();
+
     CPPUNIT_TEST_SUITE(Test);
 #if CALC_TEST_PERF
     CPPUNIT_TEST(testPerf);
@@ -425,6 +427,7 @@ public:
     CPPUNIT_TEST(testCondFormatInsertRow);
     CPPUNIT_TEST(testCondFormatInsertCol);
     CPPUNIT_TEST(testCondCopyPaste);
+    CPPUNIT_TEST(testImportStream);
     CPPUNIT_TEST_SUITE_END();
 
 private:
diff --git a/sc/source/core/tool/scopetools.cxx b/sc/source/core/tool/scopetools.cxx
index af65cff29e46..a1a52a1f07fd 100644
--- a/sc/source/core/tool/scopetools.cxx
+++ b/sc/source/core/tool/scopetools.cxx
@@ -34,6 +34,17 @@ ExpandRefsSwitch::~ExpandRefsSwitch()
     mrDoc.SetExpandRefs(mbOldValue);
 }
 
+UndoSwitch::UndoSwitch(ScDocument& rDoc, bool bUndo) :
+    mrDoc(rDoc), mbOldValue(rDoc.IsUndoEnabled())
+{
+    mrDoc.EnableUndo(bUndo);
+}
+
+UndoSwitch::~UndoSwitch()
+{
+    mrDoc.EnableUndo(mbOldValue);
+}
+
 }
 
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */