Method importFileSheetWithHeader

tests/import_export/Ods/OdsFilterTest.cpp:310–347

}

void OdsFilterTest::importFileSheetWithHeader() {
	const QString& fileName = QFINDTESTDATA(QLatin1String("data/header.ods"));

	Spreadsheet spreadsheet(QStringLiteral("test"), false);
	OdsFilter filter;

	// check sheet
	filter.setSelectedSheetNames(QStringList() << QStringLiteral("Sheet3"));
	filter.setFirstRowAsColumnNames(true);
	filter.readDataFromFile(fileName, &spreadsheet);

	QCOMPARE(spreadsheet.columnCount(), 3);
	QCOMPARE(spreadsheet.rowCount(), 4);

	// check header type
	QCOMPARE(spreadsheet.column(0)->columnMode(), AbstractColumn::ColumnMode::Text);
	QCOMPARE(spreadsheet.column(1)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(2)->columnMode(), AbstractColumn::ColumnMode::Double);

	// check header name
	QCOMPARE(spreadsheet.column(0)->name(), QLatin1String("Name"));
	QCOMPARE(spreadsheet.column(1)->name(), QLatin1String("time"));
	QCOMPARE(spreadsheet.column(2)->name(), QLatin1String("COUNT"));

	// check data
	QCOMPARE(spreadsheet.column(0)->textAt(0), QLatin1String("A"));
	QCOMPARE(spreadsheet.column(0)->textAt(1), QLatin1String("B"));
	QCOMPARE(spreadsheet.column(0)->textAt(2), QLatin1String("C"));
	QCOMPARE(spreadsheet.column(0)->textAt(3), QLatin1String("0")); // formula
	QCOMPARE(spreadsheet.column(1)->valueAt(0), 2.2);
	QCOMPARE(spreadsheet.column(1)->valueAt(1), 1.1);
	QCOMPARE(spreadsheet.column(1)->valueAt(2), 3.3);
	QCOMPARE(spreadsheet.column(1)->valueAt(3), 6.6); // formula
	QCOMPARE(spreadsheet.column(2)->valueAt(0), 42);
	QCOMPARE(spreadsheet.column(2)->valueAt(1), 23);
	QCOMPARE(spreadsheet.column(2)->valueAt(2), 5);
	QCOMPARE(spreadsheet.column(2)->valueAt(3), 70); // formula
}

QTEST_MAIN(OdsFilterTest)