From 6ed555d9889982f95b0846a451c95c9abd54c498 Mon Sep 17 00:00:00 2001
From: Kohei Yoshida <kohei.yoshida@gmail.com>
Date: Fri, 2 Aug 2013 17:42:15 -0400
Subject: Ensure that we import a value of 0 correctly.

Change-Id: I1ada3cf4a162bc4a85ce4e6d2cd0c13adf3156e6
---
 sc/qa/unit/data/ods/basic-cell-content.ods | Bin 10041 -> 10552 bytes
 sc/qa/unit/subsequent_filters-test.cxx     |   7 +++++++
 2 files changed, 7 insertions(+)

(limited to 'sc')

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
Binary files a/sc/qa/unit/data/ods/basic-cell-content.ods and b/sc/qa/unit/data/ods/basic-cell-content.ods 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();
 }
 
-- 
cgit