summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sc/qa/unit/data/ods/basic-cell-content.odsbin10041 -> 10552 bytes
-rw-r--r--sc/qa/unit/subsequent_filters-test.cxx7
2 files changed, 7 insertions, 0 deletions
diff --git a/sc/qa/unit/data/ods/basic-cell-content.ods b/sc/qa/unit/data/ods/basic-cell-content.ods
index 70f6b6e82746..2b8c8bc64d15 100644
--- a/sc/qa/unit/data/ods/basic-cell-content.ods
+++ b/sc/qa/unit/data/ods/basic-cell-content.ods
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 61e36829e404..36ae617a449d 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -46,6 +46,7 @@
#include "scitems.hxx"
#include "docsh.hxx"
#include "editutil.hxx"
+#include "cellvalue.hxx"
#include <com/sun/star/drawing/XDrawPageSupplier.hpp>
#include <com/sun/star/drawing/XControlShape.hpp>
@@ -278,6 +279,12 @@ void ScFiltersTest::testBasicCellContentODS()
aStr = pDoc->GetString(1, 3, 0); // B4
CPPUNIT_ASSERT_EQUAL(OUString("A < B"), aStr);
+ // Numeric value of 0.
+ ScRefCellValue aCell;
+ aCell.assign(*pDoc, ScAddress(1,4,0)); // B5
+ CPPUNIT_ASSERT_MESSAGE("This cell must be numeric.", aCell.meType == CELLTYPE_VALUE);
+ CPPUNIT_ASSERT_EQUAL(0.0, aCell.mfValue);
+
xDocSh->DoClose();
}