diff options
-rw-r--r-- | sc/qa/unit/bugfix-test.cxx | 14 | ||||
-rw-r--r-- | sc/qa/unit/data/xml/rhbz1390776.xml | 73 |
2 files changed, 87 insertions, 0 deletions
diff --git a/sc/qa/unit/bugfix-test.cxx b/sc/qa/unit/bugfix-test.cxx index 2cf5b1210c82..aedcea60ce64 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 000000000000..141805644a95 --- /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> |