[Libreoffice-commits] core.git: sc/qa

[David Tardon]

 sc/qa/unit/bugfix-test.cxx          |   14 ++++++
 sc/qa/unit/data/xml/rhbz1390776.xml |   73 ++++++++++++++++++++++++++++++++++++
 2 files changed, 87 insertions(+)

New commits:
commit c52d1403c3b9874bd1454093e0379e8766679609
Author: David Tardon <dtardon at redhat.com>
Date:   Fri Nov 4 16:06:31 2016 +0100

    add test case for rhbz#1390776
    
    Disabled, because the file fails to load for some reason...
    
    Change-Id: Ida79b9de4ff53d76fed86e0495f9479addc228f8

diff --git a/sc/qa/unit/bugfix-test.cxx b/sc/qa/unit/bugfix-test.cxx
index 2cf5b12..aedcea6 100644
--- a/sc/qa/unit/bugfix-test.cxx
+++ b/sc/qa/unit/bugfix-test.cxx
@@ -89,6 +89,7 @@ public:
     void testTdf98657();
     void testTdf88821();
     void testTdf88821_2();
+    // void testRhbz1390776();
 
     CPPUNIT_TEST_SUITE(ScFiltersTest);
     CPPUNIT_TEST(testTdf64229);
@@ -100,6 +101,7 @@ public:
     CPPUNIT_TEST(testTdf98657);
     CPPUNIT_TEST(testTdf88821);
     CPPUNIT_TEST(testTdf88821_2);
+    // CPPUNIT_TEST(testRhbz1390776);
     CPPUNIT_TEST_SUITE_END();
 private:
     uno::Reference<uno::XInterface> m_xCalcComponent;
@@ -269,6 +271,18 @@ void ScFiltersTest::testTdf88821_2()
     xDocSh->DoClose();
 }
 
+#if 0
+void ScFiltersTest::testRhbz1390776()
+{
+    ScDocShellRef xDocSh = loadDoc("rhbz1390776.", FORMAT_XLS_XML);
+    ScDocument& rDoc = xDocSh->GetDocument();
+
+    ASSERT_FORMULA_EQUAL(rDoc, ScAddress(0, 27, 0), "SUM(A18:A23)", "Wrong range");
+
+    xDocSh->DoClose();
+}
+#endif
+
 ScFiltersTest::ScFiltersTest()
       : ScBootstrapFixture( "/sc/qa/unit/data" )
 {
diff --git a/sc/qa/unit/data/xml/rhbz1390776.xml b/sc/qa/unit/data/xml/rhbz1390776.xml
new file mode 100644
index 0000000..1418056
--- /dev/null
+++ b/sc/qa/unit/data/xml/rhbz1390776.xml
@@ -0,0 +1,73 @@
+<?xml version="1.0"?>
+<?mso-application progid="Excel.Sheet"?>
+<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
+ xmlns:o="urn:schemas-microsoft-com:office:office"
+ xmlns:x="urn:schemas-microsoft-com:office:excel"
+ xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
+ xmlns:html="http://www.w3.org/TR/REC-html40">
+    <Styles>
+        <Style ss:ID="Default" ss:Name="Normal">
+            <Alignment ss:Vertical="Bottom"/>
+        </Style>
+        <Style ss:ID="black">
+            <Font ss:Color="#000000" />
+        </Style>
+        <Style ss:ID="red">
+            <Font ss:Color="#FF0000" ss:Bold="1"/>
+        </Style>
+        <Style ss:ID="blue">
+            <Font ss:Color="#0000FF" ss:Bold="1"/>
+        </Style>
+    </Styles>
+    <Worksheet ss:Name="Sheet1">
+        <Table ss:ExpandedColumnCount="18" x:FullColumns="1" x:FullRows="1">
+            <Column ss:Index="1" ss:AutoFitWidth="0" ss:Width="150"/>
+            <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="4" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="6" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="7" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="8" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="9" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="10" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="11" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="12" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="13" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="14" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="15" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="16" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="17" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Column ss:Index="18" ss:AutoFitWidth="0" ss:Width="50"/>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+            <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row>
+
+            <Row><Cell ss:Formula="=sum(R[-10]C:R[-5]C"><Data ss:Type="Number">10</Data></Cell></Row>
+        </Table>
+    </Worksheet>
+</Workbook>