1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
/* This file is part of the KDE project
Copyright 2007 Stefan Nikolaus <stefan.nikolaus@kdemail.net>
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Library General Public
License as published by the Free Software Foundation; only
version 2 of the License.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Library General Public License for more details.
You should have received a copy of the GNU Library General Public License
along with this library; see the file COPYING.LIB. If not, write to
the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
Boston, MA 02110-1301, USA.
*/
#include "TestDependencies.h"
#include <QTest>
#include "CellStorage.h"
#include "DependencyManager.h"
#include "DependencyManager_p.h"
#include "Formula.h"
#include "Map.h"
#include "Region.h"
#include "Sheet.h"
#include "Value.h"
using namespace Calligra::Sheets;
void TestDependencies::initTestCase()
{
m_map = new Map(0 /* no Doc */);
m_sheet = m_map->addNewSheet();
m_sheet->setSheetName("Sheet1");
m_storage = m_sheet->cellStorage();
}
void TestDependencies::testCircleRemoval()
{
Formula formula(m_sheet);
formula.setExpression("=A1");
m_storage->setFormula(1, 1, formula); // A1
QApplication::processEvents(); // handle Damages
QCOMPARE(m_storage->value(1, 1), Value::errorCIRCLE());
DependencyManager* manager = m_map->dependencyManager();
QVERIFY(manager->d->consumers.count() == 1);
QVERIFY(manager->d->providers.count() == 1);
QList<Cell> consumers = manager->d->consumers.value(m_sheet)->contains(QRect(1, 1, 1, 1));
QCOMPARE(consumers.count(), 1);
QCOMPARE(consumers.first(), Cell(m_sheet, 1, 1));
QCOMPARE(manager->d->providers.value(Cell(m_sheet, 1, 1)), Region(QRect(1, 1, 1, 1), m_sheet));
m_storage->setFormula(1, 1, Formula()); // A1
QApplication::processEvents(); // handle Damages
QCOMPARE(m_storage->value(1, 1), Value());
QVERIFY(manager->d->consumers.value(m_sheet)->contains(QRect(1, 1, 1, 1)).count() == 0);
QVERIFY(manager->d->providers.count() == 0);
}
void TestDependencies::testCircles()
{
Formula formula(m_sheet);
formula.setExpression("=A3");
m_storage->setFormula(1, 1, formula); // A1
formula.setExpression("=A1");
m_storage->setFormula(1, 2, formula); // A2
formula.setExpression("=A2");
m_storage->setFormula(1, 3, formula); // A3
QApplication::processEvents(); // handle Damages
QCOMPARE(m_storage->value(1, 1), Value::errorCIRCLE());
QCOMPARE(m_storage->value(1, 2), Value::errorCIRCLE());
QCOMPARE(m_storage->value(1, 3), Value::errorCIRCLE());
}
void TestDependencies::testDepths()
{
Cell a1(m_sheet, 1, 1); a1.setUserInput("5");
Cell a2(m_sheet, 1, 2); a2.setUserInput("=A1");
Cell a3(m_sheet, 1, 3); a3.setUserInput("=A2");
Cell a4(m_sheet, 1, 4); a4.setUserInput("=A1 + A3");
QApplication::processEvents(); // handle Damages
QMap<Cell, int> depths = m_map->dependencyManager()->depths();
QCOMPARE(depths[a1], 0);
QCOMPARE(depths[a2], 1);
QCOMPARE(depths[a3], 2);
QCOMPARE(depths[a4], 3);
a2.setUserInput("");
QApplication::processEvents(); // handle Damages
depths = m_map->dependencyManager()->depths();
QCOMPARE(depths[a1], 0);
QCOMPARE(depths[a2], 0);
QCOMPARE(depths[a3], 1);
QCOMPARE(depths[a4], 2);
}
void TestDependencies::cleanupTestCase()
{
delete m_map;
}
QTEST_MAIN(TestDependencies)
|
