Method initSearchReplaceWidget

src/frontend/spreadsheet/SearchReplaceWidget.cpp:202–342

}

void SearchReplaceWidget::initSearchReplaceWidget() {
	// init UI
	m_searchReplaceWidget = new QWidget(this);
	uiSearchReplace.setupUi(m_searchReplaceWidget);
	static_cast<QVBoxLayout*>(layout())->insertWidget(1, m_searchReplaceWidget);

	uiSearchReplace.cbDataType->addItem(i18n("Text"), int(DataType::Text));
	uiSearchReplace.cbDataType->addItem(i18n("Numeric"), int(DataType::Numeric));
	uiSearchReplace.cbDataType->addItem(i18n("Date & Time"), int(DataType::DateTime));

	uiSearchReplace.cbOperatorText->addItem(i18n("Equal To"), int(OperatorText::EqualTo));
	uiSearchReplace.cbOperatorText->addItem(i18n("Not Equal To"), int(OperatorText::NotEqualTo));
	uiSearchReplace.cbOperatorText->addItem(i18n("Starts With"), int(OperatorText::StartsWith));
	uiSearchReplace.cbOperatorText->addItem(i18n("Ends With"), int(OperatorText::EndsWith));
	uiSearchReplace.cbOperatorText->addItem(i18n("Contains"), int(OperatorText::Contain));
	uiSearchReplace.cbOperatorText->addItem(i18n("Does Not Contain"), int(OperatorText::NotContain));
	uiSearchReplace.cbOperatorText->insertSeparator(6);
	uiSearchReplace.cbOperatorText->addItem(i18n("Regular Expression"), int(OperatorText::RegEx));

	uiSearchReplace.cbOperator->addItem(i18n("Equal to"), int(Operator::EqualTo));
	uiSearchReplace.cbOperator->addItem(i18n("Not Equal to"), int(Operator::NotEqualTo));
	uiSearchReplace.cbOperator->addItem(i18n("Between (Incl. End Points)"), int(Operator::BetweenIncl));
	uiSearchReplace.cbOperator->addItem(i18n("Between (Excl. End Points)"), int(Operator::BetweenExcl));
	uiSearchReplace.cbOperator->addItem(i18n("Greater than"), int(Operator::GreaterThan));
	uiSearchReplace.cbOperator->addItem(i18n("Greater than or Equal to"), int(Operator::GreaterThanEqualTo));
	uiSearchReplace.cbOperator->addItem(i18n("Less than"), int(Operator::LessThan));
	uiSearchReplace.cbOperator->addItem(i18n("Less than or Equal to"), int(Operator::LessThanEqualTo));

	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Equal to"), int(Operator::EqualTo));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Not Equal to"), int(Operator::NotEqualTo));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Between (Incl. End Points)"), int(Operator::BetweenIncl));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Between (Excl. End Points)"), int(Operator::BetweenExcl));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Greater than"), int(Operator::GreaterThan));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Greater than or Equal to"), int(Operator::GreaterThanEqualTo));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Less than"), int(Operator::LessThan));
	uiSearchReplace.cbOperatorDateTime->addItem(i18n("Less than or Equal to"), int(Operator::LessThanEqualTo));

	uiSearchReplace.cbValueText->lineEdit()->setClearButtonEnabled(true);
	uiSearchReplace.cbValue1->lineEdit()->setClearButtonEnabled(true);
	uiSearchReplace.cbValue2->lineEdit()->setClearButtonEnabled(true);

	uiSearchReplace.cbValue1->lineEdit()->setValidator(new QDoubleValidator(uiSearchReplace.cbValue1->lineEdit()));
	uiSearchReplace.cbValue2->lineEdit()->setValidator(new QDoubleValidator(uiSearchReplace.cbValue2->lineEdit()));

	uiSearchReplace.cbOrder->addItem(i18n("Column Major"), int(Order::ColumnMajor));
	uiSearchReplace.cbOrder->addItem(i18n("Row Major"), int(Order::RowMajor));

	// set meaninungful non-empty initial value for DateTime so the user doesn't need to type
	// everything from scratch when switching to DateTime type
	auto now = QDateTime::currentDateTime();
	uiSearchReplace.dteValue1->setDateTime(now);
	uiSearchReplace.dteValue2->setDateTime(now);

	uiSearchReplace.dteValue1->setDisplayFormat(defaultDateTimeFormat);
	uiSearchReplace.dteValue2->setDisplayFormat(defaultDateTimeFormat);
	uiSearchReplace.dteReplace->setDisplayFormat(defaultDateTimeFormat);

	// restore saved settings if available