Method showColumnStatistics

src/frontend/spreadsheet/SpreadsheetView.cpp:3233–3305

}

void SpreadsheetView::showColumnStatistics(bool forAll) {
	QString dlgTitle(i18n("%1: column statistics", m_spreadsheet->name()));
	QVector<Column*> columns;

	// Column statistics can be shown for:
	// * all columns in the spreadsheet - called via the action_statistics_all_columns or when one single cell is selected (=no selection)
	// * all selected columns in the speadsheet - called via the context menu of the header
	// * selected column cells - called via the context menu in the spreadsheet with multiple selected cells
	const auto& indexes = m_tableView->selectionModel()->selectedIndexes();
	if (forAll || indexes.size() <= 1) {
		for (int col = 0; col < m_spreadsheet->columnCount(); ++col) {
			auto* column = m_spreadsheet->column(col);
			if (column->hasValues())
				columns << column;
		}
	} else {
		columns = selectedColumns(true);

		// if no columns are fully selected, copy the selected cells into new Columns which will be processes in the statistics dialog
		if (columns.isEmpty()) {
			const auto& children = m_spreadsheet->children<Column>();
			Column* targetColumn{nullptr};
			QMap<int, int> columnMappings; // key = child column index in the spreadsheet, value = column index in the vector of new colums
			QMap<int, int> rowMappings; // key = child column index in the spreadsheet, value = last row index
			for (const auto& index : indexes) {
				int col = index.column();
				int row = index.row();
				const auto* sourceColumn = children.at(col);

				if (columnMappings.contains(col))
					targetColumn = columns.at(columnMappings[col]);
				else {
					targetColumn = new Column(i18n("Selection in %1", sourceColumn->name()), sourceColumn->columnMode());
					columns << targetColumn;
					columnMappings[col] = columns.count() - 1;
					rowMappings[col] = 0;
				}

				int targetRow = rowMappings[col];

				switch (targetColumn->columnMode()) {
				case AbstractColumn::ColumnMode::Double:
					targetColumn->setValueAt(targetRow, sourceColumn->valueAt(row));
					break;
				case AbstractColumn::ColumnMode::Integer:
					targetColumn->setIntegerAt(targetRow, sourceColumn->integerAt(row));
					break;
				case AbstractColumn::ColumnMode::BigInt:
					targetColumn->setBigIntAt(targetRow, sourceColumn->bigIntAt(row));
					break;
				case AbstractColumn::ColumnMode::Text:
					targetColumn->setTextAt(targetRow, sourceColumn->textAt(row));
					break;
				case AbstractColumn::ColumnMode::DateTime:
				case AbstractColumn::ColumnMode::Month:
				case AbstractColumn::ColumnMode::Day:
					targetColumn->setDateTimeAt(targetRow, sourceColumn->dateTimeAt(row));
					break;