fdo#76294: Write import test for this.

Change-Id: I4d2f98117b783e801916f99fd99e69d43e161e2d

2 files changed, 16 insertions, 0 deletions

diff --git a/sc/qa/unit/data/xls/shared-string/literal-in-formula.xls b/sc/qa/unit/data/xls/shared-string/literal-in-formula.xls
new file mode 100644
index 000000000000..75e48f0d03bf
--- /dev/null
+++ b/sc/qa/unit/data/xls/shared-string/literal-in-formula.xls
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 4411d329d930..2ad313d7c075 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -124,6 +124,8 @@ public:
     void testNewCondFormatODS();
     void testNewCondFormatXLSX();
 
+    void testLiteralInFormulaXLS();
+
     //change this test file only in excel and not in calc
     void testCellValueXLSX();
 
@@ -211,6 +213,7 @@ public:
     CPPUNIT_TEST(testColorScaleXLSX);
     CPPUNIT_TEST(testNewCondFormatODS);
     CPPUNIT_TEST(testNewCondFormatXLSX);
+    CPPUNIT_TEST(testLiteralInFormulaXLS);
 
     CPPUNIT_TEST(testNumberFormatHTML);
     CPPUNIT_TEST(testNumberFormatCSV);
@@ -2347,6 +2350,19 @@ void ScFiltersTest::testNewCondFormatXLSX()
     xDocSh->DoClose();
 }
 
+void ScFiltersTest::testLiteralInFormulaXLS()
+{
+    ScDocShellRef xDocSh = loadDoc("shared-string/literal-in-formula.", XLS);
+    CPPUNIT_ASSERT(xDocSh.Is());
+
+    ScDocument* pDoc = xDocSh->GetDocument();
+    pDoc->CalcAll();
+
+    CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(0,0,0)));
+
+    xDocSh->DoClose();
+}
+
 void ScFiltersTest::testFormulaDependency()
 {
     ScDocShellRef xDocSh = ScBootstrapFixture::loadDoc( "dependencyTree.", ODS );