Method testSearchReplaceNumeric

tests/spreadsheet/SpreadsheetTest.cpp:2137–2198

! * replace a numeric value in int and double columns via "replace next" */

 * replace a numeric value in int and double columns via "replace next"
 */
void SpreadsheetTest::testSearchReplaceNumeric() {
#ifdef __FreeBSD__
	// ASSERT failure in QBoxLayout::insert: "index out of range"
	return;
#endif
	Project project;
	auto* sheet = createSearchReplaceSpreadsheet();
	project.addChild(sheet);

	// navigate to the (1,1) cell having the numeric value 2
	auto* view = static_cast<SpreadsheetView*>(sheet->view());
	view->goToCell(1, 1);

	// check the initial selection
	auto indexes = view->selectionModel()->selectedIndexes();
	QCOMPARE(indexes.count(), 1);
	auto curIndex = indexes.constFirst();
	QCOMPARE(curIndex.row(), 1);
	QCOMPARE(curIndex.column(), 1);

	// initialize the search&replace widget
	auto* searchReplaceWidget = new SearchReplaceWidget(sheet, view);
	searchReplaceWidget->setReplaceEnabled(true);
	searchReplaceWidget->setDataType(SearchReplaceWidget::DataType::Numeric);
	searchReplaceWidget->setOrder(SearchReplaceWidget::Order::ColumnMajor);
	searchReplaceWidget->setReplaceText(QLatin1String("5"));
	const auto& firstIndex = indexes.constFirst();
	const auto* column = sheet->column(firstIndex.column());
	const int row = firstIndex.row();
	searchReplaceWidget->setInitialPattern(column->columnMode(), column->asStringColumn()->textAt(row));

	// checks: the initial cell text is (1,1) with the value 2, we replace this value with 5 via replaceNext,
	// and proceed to other cells with further replaceNext calls.
	const auto& columns = sheet->children<Column>();

	// replace next - the value in the currently selected cell should be replaced first
	searchReplaceWidget->replaceNext();
	indexes = view->selectionModel()->selectedIndexes();
	QCOMPARE(indexes.count(), 1);
	curIndex = indexes.constFirst();
	QCOMPARE(curIndex.row(), 1);
	QCOMPARE(curIndex.column(), 1);
	QCOMPARE(columns.at(1)->integerAt(1), 5);

	// replace next
	searchReplaceWidget->replaceNext();
	indexes = view->selectionModel()->selectedIndexes();
	QCOMPARE(indexes.count(), 1);
	curIndex = indexes.constFirst();
	QCOMPARE(curIndex.row(), 3);
	QCOMPARE(curIndex.column(), 1);
	QCOMPARE(columns.at(1)->integerAt(1), 5);

	// replace next
	searchReplaceWidget->replaceNext();
	indexes = view->selectionModel()->selectedIndexes();
	QCOMPARE(indexes.count(), 1);
	curIndex = indexes.constFirst();