/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*/
#include <test/calc_unoapi_test.hxx>
#include <test/chart/xchartdata.hxx>
#include <test/sheet/cellproperties.hxx>
#include <test/sheet/sheetcellrange.hxx>
#include <test/sheet/xarrayformularange.hxx>
#include <test/sheet/xcellformatrangessupplier.hxx>
#include <test/sheet/xcellrangeaddressable.hxx>
#include <test/sheet/xcellrangedata.hxx>
#include <test/sheet/xcellrangeformula.hxx>
#include <test/sheet/xcellrangesquery.hxx>
#include <test/sheet/xcellseries.hxx>
#include <test/sheet/xformulaquery.hxx>
#include <test/sheet/xmultipleoperation.hxx>
#include <test/sheet/xsheetcellrange.hxx>
#include <test/sheet/xsheetfilterable.hxx>
#include <test/sheet/xsheetfilterableex.hxx>
#include <test/sheet/xsheetoperation.hxx>
#include <test/sheet/xsubtotalcalculatable.hxx>
#include <test/sheet/xuniquecellformatrangessupplier.hxx>
#include <test/table/xcolumnrowrange.hxx>
#include <test/util/xindent.hxx>
#include <test/util/xmergeable.hxx>
#include <test/util/xreplaceable.hxx>
#include <test/util/xsearchable.hxx>
#include <comphelper/propertysequence.hxx>
#include <com/sun/star/sheet/XSpreadsheet.hpp>
#include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
#include <com/sun/star/table/XCellRange.hpp>
#include <com/sun/star/util/SortField.hpp>
#include <com/sun/star/util/XSortable.hpp>
#include <com/sun/star/uno/Any.hxx>
#include <com/sun/star/uno/Reference.hxx>
#include <com/sun/star/uno/Sequence.hxx>
using namespace css;
namespace sc_apitest
{
class ScCellRangeObj : public CalcUnoApiTest,
public apitest::CellProperties,
public apitest::SheetCellRange,
public apitest::XArrayFormulaRange,
public apitest::XCellFormatRangesSupplier,
public apitest::XCellRangeAddressable,
public apitest::XCellRangeData,
public apitest::XCellRangeFormula,
public apitest::XCellRangesQuery,
public apitest::XCellSeries,
public apitest::XChartData,
public apitest::XColumnRowRange,
public apitest::XFormulaQuery,
public apitest::XIndent,
public apitest::XMergeable,
public apitest::XMultipleOperation,
public apitest::XReplaceable,
public apitest::XSearchable,
public apitest::XSheetCellRange,
public apitest::XSheetFilterable,
public apitest::XSheetFilterableEx,
public apitest::XSheetOperation,
public apitest::XSubTotalCalculatable,
public apitest::XUniqueCellFormatRangesSupplier
{
public:
ScCellRangeObj();
virtual void setUp() override;
virtual void tearDown() override;
virtual uno::Reference<uno::XInterface> init() override;
virtual uno::Reference<uno::XInterface> getXCellRangeData() override;
virtual uno::Reference<uno::XInterface> getXSpreadsheet() override;
void testSortOOB();
CPPUNIT_TEST_SUITE(ScCellRangeObj);
// CellProperties
CPPUNIT_TEST(testVertJustify);
CPPUNIT_TEST(testRotateReference);
// SheetCellRange
CPPUNIT_TEST(testSheetCellRangeProperties);
// XArrayFormulaRange
CPPUNIT_TEST(testGetSetArrayFormula);
// XCellFormatRangesSupplier
CPPUNIT_TEST(testGetCellFormatRanges);
// XCellRangeAddressable
CPPUNIT_TEST(testGetRangeAddress);
// XCellRangeData
CPPUNIT_TEST(testGetDataArray);
CPPUNIT_TEST(testSetDataArray);
// XCellRangeFormula
CPPUNIT_TEST(testGetSetFormulaArray);
// XCellRangesQuery
CPPUNIT_TEST(testQueryColumnDifference);
CPPUNIT_TEST(testQueryContentDifference);
CPPUNIT_TEST(testQueryEmptyCells);
//CPPUNIT_TEST(testQueryFormulaCells);
CPPUNIT_TEST(testQueryIntersection);
CPPUNIT_TEST(testQueryRowDifference);
CPPUNIT_TEST(testQueryVisibleCells);
// XCellSeries
CPPUNIT_TEST(testFillAuto);
CPPUNIT_TEST(testFillSeries);
// XChartData
CPPUNIT_TEST(testGetNotANumber);
CPPUNIT_TEST(testIsNotANumber);
CPPUNIT_TEST(testChartDataChangeEventListener);
// XColumnRowRange
CPPUNIT_TEST(testGetColumns);
CPPUNIT_TEST(testGetRows);
// XFormulaQuery
CPPUNIT_TEST(testQueryDependents);
CPPUNIT_TEST(testQueryPrecedents);
// XIndent
CPPUNIT_TEST(testIncrementIndent);
CPPUNIT_TEST(testDecrementIndent);
// XMergeable
CPPUNIT_TEST(testGetIsMergedMerge);
// XMultipleOperation
CPPUNIT_TEST(testSetTableOperation);
// XReplaceable
CPPUNIT_TEST(testReplaceAll);
CPPUNIT_TEST(testCreateReplaceDescriptor);
// XSearchable
CPPUNIT_TEST(testFindAll);
CPPUNIT_TEST(testFindFirst);
// XSheetCellRange
CPPUNIT_TEST(testGetSpreadsheet);
// XSheetFilterable
CPPUNIT_TEST(testCreateFilterDescriptor);
CPPUNIT_TEST(testFilter);
// XSheetFilterableEx
CPPUNIT_TEST(testCreateFilterDescriptorByObject);
// XSheetOperation
CPPUNIT_TEST(testComputeFunction);
CPPUNIT_TEST(testClearContents);
// XSubTotalCalculatable
CPPUNIT_TEST(testCreateSubTotalDescriptor);
CPPUNIT_TEST(testApplyRemoveSubTotals);
// XUniqueCellFormatRangesSupplier
CPPUNIT_TEST(testGetUniqueCellFormatRanges);
CPPUNIT_TEST(testSortOOB);
CPPUNIT_TEST_SUITE_END();
private:
uno::Reference<lang::XComponent> mxComponent;
};
ScCellRangeObj::ScCellRangeObj()
: CalcUnoApiTest("/sc/qa/extras/testdocuments")
, XCellSeries(2, 1)
, XFormulaQuery(table::CellRangeAddress(0, 15, 15, 15, 15),
table::CellRangeAddress(0, 0, 15, 0, 15))
, XReplaceable("15", "35")
, XSearchable("15", 1)
{
}
uno::Reference<uno::XInterface> ScCellRangeObj::init()
{
uno::Reference<sheet::XSpreadsheetDocument> xDoc(mxComponent, uno::UNO_QUERY_THROW);
uno::Reference<container::XIndexAccess> xIndex(xDoc->getSheets(), uno::UNO_QUERY_THROW);
uno::Reference<sheet::XSpreadsheet> xSheet(xIndex->getByIndex(0), uno::UNO_QUERY_THROW);
uno::Reference<table::XCellRange> xReturn(xSheet->getCellRangeByPosition(0, 0, 4, 4),
uno::UNO_SET_THROW);
return xReturn;
}
uno::Reference<uno::XInterface> ScCellRangeObj::getXSpreadsheet()
{
uno::Reference<sheet::XSpreadsheetDocument> xDoc(mxComponent, uno::UNO_QUERY_THROW);
uno::Reference<container::XIndexAccess> xIndex(xDoc->getSheets(), uno::UNO_QUERY_THROW);
uno::Reference<sheet::XSpreadsheet> xSheet(xIndex->getByIndex(0), uno::UNO_QUERY_THROW);
setXCell(xSheet->getCellByPosition(15, 15));
return xSheet;
}
uno::Reference<uno::XInterface> ScCellRangeObj::getXCellRangeData()
{
uno::Reference<sheet::XSpreadsheetDocument> xDoc(mxComponent, uno::UNO_QUERY_THROW);
uno::Reference<container::XIndexAccess> xIndex(xDoc->getSheets(), uno::UNO_QUERY_THROW);
uno::Reference<sheet::XSpreadsheet> xSheet(xIndex->getByIndex(1), uno::UNO_QUERY_THROW);
uno::Reference<table::XCellRange> xReturn(xSheet->getCellRangeByPosition(0, 0, 3, 3),
uno::UNO_SET_THROW);
return xReturn;
}
void ScCellRangeObj::testSortOOB()
{
uno::Reference<util::XSortable> xSortable(init(), uno::UNO_QUERY_THROW);
uno::Sequence<beans::PropertyValue> aEmptyDescriptor;
xSortable->sort(aEmptyDescriptor);
uno::Sequence<util::SortField> aSort(1);
aSort[0].Field = 0xffffff;
aSort[0].SortAscending = true;
uno::Sequence<beans::PropertyValue> aProps(
comphelper::InitPropertySequence({ { "SortFields", uno::Any(aSort) } }));
xSortable->sort(aProps);
}
void ScCellRangeObj::setUp()
{
CalcUnoApiTest::setUp();
OUString aFileURL;
createFileURL(u"xcellrangesquery.ods", aFileURL);
mxComponent = loadFromDesktop(aFileURL, "com.sun.star.sheet.SpreadsheetDocument");
}
void ScCellRangeObj::tearDown()
{
closeDocument(mxComponent);
CalcUnoApiTest::tearDown();
}
CPPUNIT_TEST_SUITE_REGISTRATION(ScCellRangeObj);
} // namespace sc_apitest
CPPUNIT_PLUGIN_IMPLEMENT();
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */