Unit test for string input with custom string handling policy.

Change-Id: I51e8fbe83e94ba66a0e2ef63aacf080ba0e50a9c

1 files changed, 9 insertions, 0 deletions

diff --git a/sc/qa/unit/ucalc.cxx b/sc/qa/unit/ucalc.cxx
index 93e5b803c3f6..b816f5cf6e8a 100644
--- a/sc/qa/unit/ucalc.cxx
+++ b/sc/qa/unit/ucalc.cxx
@@ -362,6 +362,15 @@ void Test::testInput()
     bTest = test == "'apple'";
     CPPUNIT_ASSERT_MESSAGE("Text content should have retained the first apostrophe.", bTest);
 
+    // Customized string handling policy.
+    ScSetStringParam aParam;
+    aParam.mbDetectNumberFormat = false;
+    aParam.mbSetTextCellFormat = true;
+    aParam.mbHandleApostrophe = false;
+    m_pDoc->SetString(0, 0, 0, "000123", &aParam);
+    m_pDoc->GetString(0, 0, 0, test);
+    CPPUNIT_ASSERT_MESSAGE("Text content should have been treated as string, not number.", test == "000123");
+
     m_pDoc->DeleteTab(0);
 }