Method testLinkSpreadSheetImportBLF

tests/spreadsheet/SpreadsheetTest.cpp:3328–3449

}

void SpreadsheetTest::testLinkSpreadSheetImportBLF() {
	QTemporaryFile blfFileName(QStringLiteral("XXXXXX.blf"));
	QVERIFY(blfFileName.open());
	QVector<Vector::BLF::CanMessage2*> messages{
		createCANMessage(337, 5, {0, 4, 252, 19, 0, 0, 0, 0}),
		createCANMessage(541, 10, {7, 39, 118, 33, 250, 30, 76, 24}), // 99.91, 85.66, 79.3, 22.2
		createCANMessage(337, 15, {47, 4, 60, 29, 0, 0, 0, 0}),
		createCANMessage(337, 20, {57, 4, 250, 29, 0, 0, 0, 0}),
		createCANMessage(541, 25, {7, 39, 118, 33, 250, 30, 76, 24}), // 99.91, 85.66, 79.3, 22.2
	}; // time is in nanoseconds
	createBLFFile(blfFileName.fileName(), messages);

	QTemporaryFile dbcFile(QStringLiteral("XXXXXX.dbc"));
	QVERIFY(dbcFile.open());
	const auto dbcContent = R"(BO_ 337 STATUS: 8 Vector__XXX
 SG_ Value6 : 27|3@1+ (1,0) [0|7] ""  Vector__XXX
 SG_ Value5 : 16|11@1+ (0.1,-102) [-102|102] "%"  Vector__XXX
 SG_ Value2 : 8|2@1+ (1,0) [0|2] ""  Vector__XXX
 SG_ Value3 : 10|1@1+ (1,0) [0|1] ""  Vector__XXX
 SG_ Value7 : 30|2@1+ (1,0) [0|3] ""  Vector__XXX
 SG_ Value4 : 11|4@1+ (1,0) [0|3] ""  Vector__XXX
 SG_ Value1 : 0|8@1+ (1,0) [0|204] "Km/h"  Vector__XXX"
BO_ 541 MSG2: 8 Vector__XXX
 SG_ MSG2Value4 : 48|16@1+ (0.01,-40) [-40|125] "C"  Vector__XXX
 SG_ MSG2Value1 : 0|16@1+ (0.01,0) [0|100] "%"  Vector__XXX
 SG_ MSG2Value3 : 32|16@1+ (0.01,0) [0|100] "%"  Vector__XXX
 SG_ MSG2Value2 : 16|16@1+ (0.01,0) [0|100] "%"  Vector__XXX
)";
	createDBCFile(dbcFile.fileName(), dbcContent);

	//------------------------------------------------------------------------------------------
	Project project;
	const auto spreadsheetName = blfFileName.fileName().replace(QStringLiteral(".blf"), QStringLiteral(""));
	auto* sheetData = new Spreadsheet(spreadsheetName, false);
	project.addChild(sheetData);
	sheetData->setColumnCount(2);
	sheetData->setRowCount(10);
	auto* sheetDataColumn0 = sheetData->child<Column>(0);
	sheetDataColumn0->setName(QStringLiteral("Value6_"));
	sheetDataColumn0->replaceValues(0, {1, 2, 3, 4, 5, 6, 7, 8, 9, 10});
	QVERIFY(sheetDataColumn0);
	auto* sheetDataColumn1 = sheetData->child<Column>(1);
	sheetDataColumn1->setName(QStringLiteral("Value5_%"));
	QVERIFY(sheetDataColumn1);
	sheetDataColumn1->replaceValues(0, {1, 2, 1, 2, 1, 2, 1, 2, 1, 3});

	auto* sheetCalculations = new Spreadsheet(QStringLiteral("calculations"), false);
	project.addChild(sheetCalculations);
	sheetCalculations->setColumnCount(2);
	sheetCalculations->setRowCount(2);

	auto* sheetCalculationsColumn0 = sheetCalculations->child<Column>(0);
	QVERIFY(sheetCalculationsColumn0);
	sheetCalculationsColumn0->setFormula(QStringLiteral("2*x"), {QStringLiteral("x")}, {sheetDataColumn0}, true);
	sheetCalculationsColumn0->updateFormula();

	auto* sheetCalculationsColumn1 = sheetCalculations->child<Column>(1);
	QVERIFY(sheetCalculationsColumn1);