summaryrefslogtreecommitdiff
path: root/sc/qa/unit
diff options
context:
space:
mode:
authorUrsache Vladimir <ursache@collabora.co.uk>2015-02-10 23:06:35 +0200
committerMarkus Mohrhard <markus.mohrhard@collabora.co.uk>2015-02-14 01:40:42 +0100
commit23159e5a23687683d8478a302b5634097e6c518d (patch)
tree572341443555f392cf8103f0607f0f46a19b1fad /sc/qa/unit
parent480de8e23d4fc39e33646eb11987a00c311ee28d (diff)
tdf#68117 Unit test
Change-Id: I2c1b935648ea2728878f606dfe8a141c3c1ddda2
Diffstat (limited to 'sc/qa/unit')
-rw-r--r--sc/qa/unit/data/xlsx/check-boolean.xlsxbin0 -> 4659 bytes
-rw-r--r--sc/qa/unit/subsequent_filters-test.cxx26
2 files changed, 26 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/check-boolean.xlsx b/sc/qa/unit/data/xlsx/check-boolean.xlsx
new file mode 100644
index 000000000000..a7643d19fbe2
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/check-boolean.xlsx
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 13c616d350e2..a793239a27ff 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -18,6 +18,9 @@
#include <sfx2/docfile.hxx>
#include <sfx2/sfxmodelfactory.hxx>
#include <svl/stritem.hxx>
+#include <svl/nfkeytab.hxx>
+//#include <zformat.hxx>
+#include <svl/zformat.hxx>
#include <svx/svdograf.hxx>
#include "drwlayer.hxx"
@@ -86,6 +89,7 @@ public:
virtual void tearDown() SAL_OVERRIDE;
//ods, xls, xlsx filter tests
+ void testBooleanFormatXLSX();
void testBasicCellContentODS();
void testRangeNameXLS();
void testRangeNameLocalXLS();
@@ -186,6 +190,7 @@ public:
void testEmbeddedImageXLS();
CPPUNIT_TEST_SUITE(ScFiltersTest);
+ CPPUNIT_TEST(testBooleanFormatXLSX);
CPPUNIT_TEST(testBasicCellContentODS);
CPPUNIT_TEST(testRangeNameXLS);
CPPUNIT_TEST(testRangeNameLocalXLS);
@@ -352,6 +357,27 @@ void ScFiltersTest::testBasicCellContentODS()
xDocSh->DoClose();
}
+void ScFiltersTest::testBooleanFormatXLSX()
+{
+ ScDocShellRef xDocSh = loadDoc("check-boolean.", XLSX);
+ ScDocument& rDoc = xDocSh->GetDocument();
+ SvNumberFormatter *pNumFormatter = rDoc.GetFormatTable();
+ const OUString aBooleanTypeStr = "\"TRUE\";\"TRUE\";\"FALSE\"";
+
+ CPPUNIT_ASSERT_MESSAGE("Failed to load check-boolean.xlsx", xDocSh.Is());
+ sal_uInt32 nNumberFormat;
+
+ for (SCROW i = 0; i <= 1; i++)
+ {
+ rDoc.GetNumberFormat(0, i, 0, nNumberFormat);
+ const SvNumberformat *pSvnumberFormat = pNumFormatter->GetEntry(nNumberFormat);
+ const OUString &rFormatStr = pSvnumberFormat->GetFormatstring();
+ CPPUNIT_ASSERT_MESSAGE("Number format != boolean", rFormatStr == aBooleanTypeStr);
+ }
+
+ xDocSh->DoClose();
+}
+
void ScFiltersTest::testRangeNameXLS()
{
ScDocShellRef xDocSh = loadDoc("named-ranges-global.", XLS);