13#include <com/sun/star/sheet/XFormulaQuery.hpp>
14#include <com/sun/star/sheet/XSheetCellRanges.hpp>
15#include <com/sun/star/sheet/XSpreadsheet.hpp>
16#include <com/sun/star/table/CellRangeAddress.hpp>
17#include <com/sun/star/table/XCell.hpp>
18#include <com/sun/star/uno/Reference.hxx>
19#include <com/sun/star/uno/Sequence.hxx>
21#include <cppunit/TestAssert.h>
30 uno::Reference<sheet::XSpreadsheet> xSheet(
getXSpreadsheet(), UNO_QUERY_THROW);
31 xSheet->getCellByPosition(0, 0)->setValue(1);
32 xSheet->getCellByPosition(1, 0)->setValue(1);
33 xSheet->getCellByPosition(2, 0)->setValue(1);
34 xSheet->getCellByPosition(3, 0)->setValue(1);
36 uno::Reference<table::XCell> xCell =
getXCell();
37 xCell->setFormula(
"=SUM(A1:D1)");
39 uno::Reference<sheet::XFormulaQuery> xFormulaQuery(
init(), UNO_QUERY_THROW);
40 uno::Reference<sheet::XSheetCellRanges> xSCR = xFormulaQuery->queryDependents(
false);
41 uno::Sequence<table::CellRangeAddress> aCellRangeAddress = xSCR->getRangeAddresses();
48 uno::Reference<sheet::XSpreadsheet> xSheet(
getXSpreadsheet(), UNO_QUERY_THROW);
49 xSheet->getCellByPosition(0, 0)->setValue(1);
50 xSheet->getCellByPosition(1, 0)->setValue(1);
51 xSheet->getCellByPosition(2, 0)->setValue(1);
52 xSheet->getCellByPosition(3, 0)->setValue(1);
53 xSheet->getCellByPosition(1, 2)->setFormula(
"=A16 * 2");
55 uno::Reference<table::XCell> xCell =
getXCell();
56 xCell->setFormula(
"=SUM(A1:D1)");
58 uno::Reference<sheet::XFormulaQuery> xFormulaQuery(
init(), UNO_QUERY_THROW);
59 uno::Reference<sheet::XSheetCellRanges> xSCR = xFormulaQuery->queryPrecedents(
false);
60 uno::Sequence<table::CellRangeAddress> aCellRangeAddress = xSCR->getRangeAddresses();