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
117
118
|
// Copyright (C) 2016 The Qt Company Ltd.
// SPDX-License-Identifier: LicenseRef-Qt-Commercial OR BSD-3-Clause
#include "spreadsheetitem.h"
QTableWidgetItem *SpreadSheetItem::clone() const
{
SpreadSheetItem *item = new SpreadSheetItem;
*item = *this;
return item;
}
QVariant SpreadSheetItem::data(int role) const
{
if (role == Qt::EditRole || role == Qt::StatusTipRole)
return formula();
if (role == Qt::DisplayRole)
return display();
const QString t = display().toString();
if (role == Qt::ForegroundRole) {
bool isNumber = false;
const int number = t.toInt(&isNumber);
QColor color = Qt::black;
if (isNumber)
color = (number < 0) ? Qt::red : Qt::blue;
return QVariant::fromValue(color);
}
if (role == Qt::TextAlignmentRole)
if (!t.isEmpty() && (t.at(0).isNumber() || t.at(0) == '-'))
return int(Qt::AlignRight | Qt::AlignVCenter);
return QTableWidgetItem::data(role);
}
void SpreadSheetItem::setData(int role, const QVariant &value)
{
QTableWidgetItem::setData(role, value);
if (tableWidget())
tableWidget()->viewport()->update();
}
QVariant SpreadSheetItem::display() const
{
// avoid circular dependencies
if (isResolving)
return QVariant();
isResolving = true;
QVariant result = computeFormula(formula(), tableWidget(), this);
isResolving = false;
return result;
}
QVariant SpreadSheetItem::computeFormula(const QString &formula,
const QTableWidget *widget,
const QTableWidgetItem *self)
{
// check if the string is actually a formula or not
QStringList list = formula.split(' ');
if (list.isEmpty() || !widget)
return formula; // it is a normal string
QString op = list.value(0).toLower();
int firstRow = -1;
int firstCol = -1;
int secondRow = -1;
int secondCol = -1;
if (list.count() > 1)
decode_pos(list.value(1), &firstRow, &firstCol);
if (list.count() > 2)
decode_pos(list.value(2), &secondRow, &secondCol);
const QTableWidgetItem *start = widget->item(firstRow, firstCol);
const QTableWidgetItem *end = widget->item(secondRow, secondCol);
int firstVal = start ? start->text().toInt() : 0;
int secondVal = end ? end->text().toInt() : 0;
QVariant result;
if (op == "sum") {
int sum = 0;
for (int r = firstRow; r <= secondRow; ++r) {
for (int c = firstCol; c <= secondCol; ++c) {
const QTableWidgetItem *tableItem = widget->item(r, c);
if (tableItem && tableItem != self)
sum += tableItem->text().toInt();
}
}
result = sum;
} else if (op == "+") {
result = (firstVal + secondVal);
} else if (op == "-") {
result = (firstVal - secondVal);
} else if (op == "*") {
result = (firstVal * secondVal);
} else if (op == "/") {
if (secondVal == 0)
result = QString("nan");
else
result = (firstVal / secondVal);
} else if (op == "=") {
if (start)
result = start->text();
} else {
result = formula;
}
return result;
}
|