Method update

src/backend/spreadsheet/StatisticsSpreadsheet.cpp:150–289

! * updates the content of the statistics spreadsheet. * called when the data in the parent spreadsheet was modified. */

 * called when the data in the parent spreadsheet was modified.
 */
void StatisticsSpreadsheet::update() {
	// determine the number of activated metrics and properly resize the spreadsheet
	int colCount = 1; // first column for "column name"
	for (const auto& metric : m_metricValues) {
		if (m_metrics.testFlag(metric))
			++colCount;
	}

	setUndoAware(false);
	setRowCount(m_spreadsheet->columnCount());
	setColumnCount(colCount);
	setUndoAware(true);

	// make all columns in this statistics spreadsheet undo unaware
	const auto& statisticsColumns = children<Column>();
	for (auto* col : statisticsColumns) {
		col->setUndoAware(false);
		col->setFixed(true);
	}

	// show the column names in the first column of the statistics spreadsheet
	auto* statisticsColumn = statisticsColumns.at(0);
	statisticsColumn->setName(i18n("Column"));
	statisticsColumn->setColumnMode(AbstractColumn::ColumnMode::Text);
	const auto& columns = m_spreadsheet->children<Column>();
	for (int i = 0; i < columns.count(); ++i)
		statisticsColumn->setTextAt(i, columns.at(i)->name());

	// show other statistics metrics that were activated
	int colIndex = 1;
	int metricIndex = 0;
	for (const auto& metric : m_metricValues) {
		if (m_metrics.testFlag(metric)) {
			// rename the statistics column
			auto* statisticsColumn = statisticsColumns.at(colIndex);
			statisticsColumn->setName(m_metricNames.at(metricIndex));

			// set the column mode
			if (m_metricValues.at(metricIndex) == StatisticsSpreadsheet::Metric::Count)
				statisticsColumn->setColumnMode(AbstractColumn::ColumnMode::Integer);
			else
				statisticsColumn->setColumnMode(AbstractColumn::ColumnMode::Double);

			// set the cell values
			for (int i = 0; i < columns.count(); ++i) {
				const auto* column = columns.at(i);
				const auto& statistics = column->statistics();

				switch (metric) {
				case Metric::Count:
					statisticsColumn->setIntegerAt(i, statistics.size);
					break;
				case Metric::Minimum:
					statisticsColumn->setValueAt(i, statistics.minimum);
					break;
				case Metric::Maximum:
					statisticsColumn->setValueAt(i, statistics.maximum);
					break;