test/source/sheet/xsheetoutline.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  */
   9
  10 #include <test/sheet/xsheetoutline.hxx>
  11
  12 #include <com/sun/star/sheet/XSpreadsheet.hpp>
  13 #include <com/sun/star/table/CellRangeAddress.hpp>
  14 #include <com/sun/star/table/XCellRange.hpp>
  15
  16 #include <com/sun/star/sheet/XCellRangeAddressable.hpp>
  17 #include <com/sun/star/table/TableOrientation.hpp>
  18
  19 #include <com/sun/star/sheet/XSheetCellRanges.hpp>
  20 #include <com/sun/star/sheet/XCellRangesQuery.hpp>
  21
  22 #include <cppunit/extensions/HelperMacros.h>
  23 #include <rtl/ustring.hxx>
  24
  25 using namespace css;
  26 using namespace css::uno;
  27
  28 namespace apitest {
  29
  30 const OUString colLevel1 = "OutlineSheet.A1:Z1";
  31 const OUString colLevel2 = "OutlineSheet.C1:W1";
  32 const OUString colLevel3 = "OutlineSheet.E1:U1";
  33 const OUString colLevel4 = "OutlineSheet.G1:S1";
  34
  35 const OUString rowLevel1 = "OutlineSheet.A1:A30";
  36 const OUString rowLevel2 = "OutlineSheet.A3:A27";
  37 const OUString rowLevel3 = "OutlineSheet.A5:A24";
  38 const OUString rowLevel4 = "OutlineSheet.A7:A21";
  39
  40 static OUString getVisibleAdress(
  41     uno::Reference<sheet::XSpreadsheet> const& xSheet,
  42     const OUString& aLevelRangeString)
  43 {
  44
  45     uno::Reference<table::XCellRange> aSheetRangeAccess(xSheet, UNO_QUERY_THROW);
  46     uno::Reference<table::XCellRange> aLevelRange = aSheetRangeAccess->getCellRangeByName(aLevelRangeString);
  47
  48     uno::Reference<sheet::XCellRangesQuery> xCellRangesQuery(aLevelRange,UNO_QUERY_THROW);
  49     uno::Reference<sheet::XSheetCellRanges> xRanges = xCellRangesQuery->queryVisibleCells();
  50     OUString aResult = xRanges->getRangeAddressesAsString();
  51
  52     return aResult;
  53
  54 }
  55
  56 static table::CellRangeAddress getAddressFromRangeString(
  57     uno::Reference<sheet::XSpreadsheet> const& xSheet,
  58     const OUString& aStringAddress)
  59 {
  60
  61     uno::Reference< table::XCellRange > aSheetRangeAccess(xSheet, UNO_QUERY_THROW);
  62     uno::Reference<table::XCellRange> aRange = aSheetRangeAccess->getCellRangeByName(aStringAddress);
  63
  64     uno::Reference<sheet::XCellRangeAddressable> xCellRangeAddressable(aRange, UNO_QUERY_THROW);
  65     table::CellRangeAddress aLevelRangeAddress = xCellRangeAddressable->getRangeAddress();
  66
  67     return aLevelRangeAddress;
  68
  69 }
  70
  71 void XSheetOutline::testHideDetail()
  72 {
  73
  74     uno::Reference< sheet::XSpreadsheet > aSheet(init(), UNO_QUERY_THROW);
  75     uno::Reference< sheet::XSheetOutline > aSheetOutline(aSheet, UNO_QUERY_THROW);
  76
  77     // Column level 2
  78     table::CellRangeAddress aLevelRangeAddress = getAddressFromRangeString(aSheet, colLevel2);
  79     aSheetOutline->hideDetail(aLevelRangeAddress);
  80
  81     CPPUNIT_ASSERT_EQUAL_MESSAGE("Column level 2 not hidden",
  82             getVisibleAdress(aSheet, colLevel2), OUString());
  83
  84     // Row Level 2
  85     aLevelRangeAddress = getAddressFromRangeString(aSheet, rowLevel2);
  86     aSheetOutline->hideDetail(aLevelRangeAddress);
  87
  88     CPPUNIT_ASSERT_EQUAL_MESSAGE("Row level 2 not hidden",
  89             getVisibleAdress(aSheet, rowLevel2), OUString());
  90
  91 }
  92
  93 void XSheetOutline::testShowDetail()
  94 {
  95     uno::Reference< sheet::XSpreadsheet > aSheet(init(), UNO_QUERY_THROW);
  96     uno::Reference< sheet::XSheetOutline > aSheetOutline(aSheet, UNO_QUERY_THROW);
  97
  98     aSheetOutline->showDetail(getAddressFromRangeString(aSheet, colLevel1));
  99     aSheetOutline->showDetail(getAddressFromRangeString(aSheet, rowLevel1));
 100
 101     // Row Level 2
 102     table::CellRangeAddress  aLevelRangeAddress = getAddressFromRangeString(aSheet, rowLevel2);
 103     aSheetOutline->showDetail(aLevelRangeAddress);
 104
 105     CPPUNIT_ASSERT_EQUAL_MESSAGE("Row level 2 still hidden",
 106             getVisibleAdress(aSheet, rowLevel2), rowLevel2);
 107
 108     // Column Level 2
 109     aLevelRangeAddress = getAddressFromRangeString(aSheet, colLevel2);
 110     aSheetOutline->showDetail(aLevelRangeAddress);
 111
 112     CPPUNIT_ASSERT_EQUAL_MESSAGE("Column level 2 still hidden",
 113             getVisibleAdress(aSheet, colLevel2), colLevel2);
 114
 115 }
 116
 117 void XSheetOutline::testShowLevel()
 118 {
 119
 120     uno::Reference< sheet::XSpreadsheet > aSheet(init(), UNO_QUERY_THROW);
 121     uno::Reference< sheet::XSheetOutline > aSheetOutline(aSheet, UNO_QUERY_THROW);
 122
 123     // test columns
 124
 125     table::CellRangeAddress aLevel1 = getAddressFromRangeString(aSheet, colLevel1);
 126     table::CellRangeAddress aLevel2 = getAddressFromRangeString(aSheet, colLevel2);
 127     table::CellRangeAddress aLevel3 = getAddressFromRangeString(aSheet, colLevel3);
 128     table::CellRangeAddress aLevel4 = getAddressFromRangeString(aSheet, colLevel4);
 129
 130     aSheetOutline->showDetail(getAddressFromRangeString(aSheet, colLevel1));
 131     aSheetOutline->showDetail(getAddressFromRangeString(aSheet, colLevel2));
 132     aSheetOutline->showDetail(getAddressFromRangeString(aSheet, rowLevel1));
 133
 134     aSheetOutline->hideDetail(aLevel1);
 135     aSheetOutline->hideDetail(aLevel2);
 136     aSheetOutline->hideDetail(aLevel3);
 137     aSheetOutline->hideDetail(aLevel4);
 138
 139     aSheetOutline->showLevel(2, table::TableOrientation_COLUMNS);
 140
 141     std::cout << " verifiy showLevel col apres" << getVisibleAdress(aSheet, "OutlineSheet.A1:Z30") << std::endl;
 142
 143     // verify that level 2 and level 1 are shown --> column 0..3 & column 22..26
 144     // level 3 & 4 are hidden --> column 4..19
 145
 146     CPPUNIT_ASSERT_EQUAL_MESSAGE("testShowLevel Column", OUString("OutlineSheet.A1:D1"), getVisibleAdress(aSheet, "OutlineSheet.A1:D1"));
 147     CPPUNIT_ASSERT_EQUAL_MESSAGE("testShowLevel Column", OUString("OutlineSheet.V1:Z1"), getVisibleAdress(aSheet, "OutlineSheet.V1:Z1"));
 148     CPPUNIT_ASSERT_EQUAL_MESSAGE("testShowLevel Column", OUString(), getVisibleAdress(aSheet, colLevel3));
 149
 150 /* FIXME !!
 151
 152     // test Rows
 153
 154     aLevel1 = getAddressFromRangeString(rowLevel1);
 155     aLevel2 = getAddressFromRangeString(rowLevel2);
 156     aLevel3 = getAddressFromRangeString(rowLevel3);
 157     aLevel4 = getAddressFromRangeString(rowLevel4);
 158
 159     aSheetOutline->showDetail(getAddressFromRangeString(colLevel1));
 160     aSheetOutline->showDetail(getAddressFromRangeString(rowLevel1));
 161     aSheetOutline->showDetail(getAddressFromRangeString(rowLevel2));
 162
 163     std::cout << " verifiy showLevel row avant" << OUStringToOString(getVisibleAdress("OutlineSheet.A1:Z30"), RTL_TEXTENCODING_UTF8).getStr() << std::endl;
 164
 165     aSheetOutline->hideDetail(aLevel1);
 166     aSheetOutline->hideDetail(aLevel2);
 167     aSheetOutline->hideDetail(aLevel3);
 168     aSheetOutline->hideDetail(aLevel4);
 169
 170     std::cout << " verifiy showLevel row juste avant" << OUStringToOString(getVisibleAdress("OutlineSheet.A1:Z30"), RTL_TEXTENCODING_UTF8).getStr() << std::endl;
 171
 172     aSheetOutline->showLevel(2, table::TableOrientation_ROWS);
 173
 174     std::cout << " verifiy showLevel row apres" << OUStringToOString(getVisibleAdress("OutlineSheet.A1:Z30"), RTL_TEXTENCODING_UTF8).getStr() << std::endl;
 175
 176     // verify rows visible 0..3 & 24..29
 177     // verfiy rows hidden 4..23
 178
 179     CPPUNIT_ASSERT_EQUAL_MESSAGE("testShowLevel Row", OUString("OutlineSheet.A1:A4"), getVisibleAdress("OutlineSheet.A1:A4"));
 180     CPPUNIT_ASSERT_EQUAL_MESSAGE("testShowLevel Row", OUString("OutlineSheet.A25:A30"), getVisibleAdress("OutlineSheet.A25:A30"));
 181     CPPUNIT_ASSERT_EQUAL_MESSAGE("testShowLevel Row", OUString(), getVisibleAdress(rowLevel3));
 182
 183 */
 184
 185 }
 186
 187 void XSheetOutline::testGroup()
 188 {
 189
 190     uno::Reference< sheet::XSpreadsheet > aSheet(init(), UNO_QUERY_THROW);
 191     uno::Reference< sheet::XSheetOutline > aSheetOutline(aSheet, UNO_QUERY_THROW);
 192
 193     // Column level 2
 194     OUString aNewString = "OutlineSheet.AB1:AG1";
 195     table::CellRangeAddress aLevelRangeAddress = getAddressFromRangeString(aSheet, aNewString);
 196     aSheetOutline->group(aLevelRangeAddress, table::TableOrientation_COLUMNS);
 197
 198     aSheetOutline->hideDetail(aLevelRangeAddress);
 199
 200     CPPUNIT_ASSERT_EQUAL_MESSAGE("testGroup Column still visible", getVisibleAdress(aSheet, aNewString), OUString());
 201
 202     // Row Level 2
 203     aNewString = "OutlineSheet.A50:A60";
 204     aLevelRangeAddress = getAddressFromRangeString(aSheet, aNewString);
 205     aSheetOutline->group(aLevelRangeAddress, table::TableOrientation_ROWS);
 206
 207     aSheetOutline->hideDetail(aLevelRangeAddress);
 208
 209     CPPUNIT_ASSERT_EQUAL_MESSAGE("testGroup Row still visible", getVisibleAdress(aSheet, aNewString), OUString());
 210
 211 }
 212
 213 void XSheetOutline::testUngroup()
 214 {
 215     uno::Reference< sheet::XSpreadsheet > aSheet(init(), UNO_QUERY_THROW);
 216     uno::Reference< sheet::XSheetOutline > aSheetOutline(aSheet, UNO_QUERY_THROW);
 217
 218     // New Column level
 219     OUString aNewString = "OutlineSheet.BB1:BG1";
 220     table::CellRangeAddress aLevelRangeAddress = getAddressFromRangeString(aSheet, aNewString);
 221     aSheetOutline->group(aLevelRangeAddress, table::TableOrientation_COLUMNS);
 222     aSheetOutline->hideDetail(aLevelRangeAddress);
 223
 224     aSheetOutline->ungroup(aLevelRangeAddress, table::TableOrientation_COLUMNS);
 225
 226     aSheetOutline->showDetail(aLevelRangeAddress);
 227     // should remain hidden ?
 228
 229     CPPUNIT_ASSERT_EQUAL_MESSAGE("testUnGroup Column becomes visible after ungroup", getVisibleAdress(aSheet, aNewString), OUString());
 230
 231     // New Row level
 232     aNewString = "OutlineSheet.A70:A80";
 233     aLevelRangeAddress = getAddressFromRangeString(aSheet, aNewString);
 234     aSheetOutline->group(aLevelRangeAddress, table::TableOrientation_ROWS);
 235     aSheetOutline->hideDetail(aLevelRangeAddress);
 236
 237     aSheetOutline->ungroup(aLevelRangeAddress, table::TableOrientation_ROWS);
 238
 239     aSheetOutline->showDetail(aLevelRangeAddress);
 240     // should remain hidden ?
 241
 242     CPPUNIT_ASSERT_EQUAL_MESSAGE("testUnGroup Row becomes visible after ungroup", getVisibleAdress(aSheet, aNewString), OUString());
 243
 244 }
 245
 246 void XSheetOutline::testClearOutline()
 247 {
 248     uno::Reference< sheet::XSpreadsheet > aSheet(init(), UNO_QUERY_THROW);
 249     uno::Reference< sheet::XSheetOutline > aSheetOutline(aSheet, UNO_QUERY_THROW);
 250
 251     aSheetOutline->clearOutline();
 252
 253     table::CellRangeAddress aLevelRangeAddress = getAddressFromRangeString(aSheet, colLevel1);
 254     aSheetOutline->hideDetail(aLevelRangeAddress);
 255     aLevelRangeAddress = getAddressFromRangeString(aSheet, rowLevel1);
 256     aSheetOutline->hideDetail(aLevelRangeAddress);
 257
 258     CPPUNIT_ASSERT_EQUAL_MESSAGE("testClearOutline Columns are hidden after clear", getVisibleAdress(aSheet, colLevel1), colLevel1);
 259     CPPUNIT_ASSERT_EQUAL_MESSAGE("testClearOutline Rows are hidden after clear", getVisibleAdress(aSheet, rowLevel1), rowLevel1);
 260
 261 }
 262
 263 }
 264
 265 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */