| 163 | } |
| 164 | |
| 165 | void ReadStatFilterTest::testPORImport() { |
| 166 | Spreadsheet spreadsheet(QStringLiteral("test"), false); |
| 167 | ReadStatFilter filter; |
| 168 | |
| 169 | const QString& fileName = QFINDTESTDATA(QLatin1String("data/sample.por")); |
| 170 | const auto mode = AbstractFileFilter::ImportMode::Replace; |
| 171 | filter.readDataFromFile(fileName, &spreadsheet, mode); |
| 172 | |
| 173 | QCOMPARE(spreadsheet.columnCount(), 7); |
| 174 | QCOMPARE(spreadsheet.rowCount(), 5); |
| 175 | QCOMPARE(spreadsheet.column(0)->columnMode(), AbstractColumn::ColumnMode::Text); |
| 176 | QCOMPARE(spreadsheet.column(1)->columnMode(), AbstractColumn::ColumnMode::Double); |
| 177 | QCOMPARE(spreadsheet.column(2)->columnMode(), AbstractColumn::ColumnMode::Double); |
| 178 | QCOMPARE(spreadsheet.column(3)->columnMode(), AbstractColumn::ColumnMode::Double); |
| 179 | QCOMPARE(spreadsheet.column(4)->columnMode(), AbstractColumn::ColumnMode::Double); |
| 180 | QCOMPARE(spreadsheet.column(5)->columnMode(), AbstractColumn::ColumnMode::Double); |
| 181 | QCOMPARE(spreadsheet.column(6)->columnMode(), AbstractColumn::ColumnMode::Double); |
| 182 | |
| 183 | QCOMPARE(spreadsheet.column(0)->plotDesignation(), AbstractColumn::PlotDesignation::X); |
| 184 | QCOMPARE(spreadsheet.column(1)->plotDesignation(), AbstractColumn::PlotDesignation::Y); |
| 185 | QCOMPARE(spreadsheet.column(2)->plotDesignation(), AbstractColumn::PlotDesignation::Y); |
| 186 | QCOMPARE(spreadsheet.column(3)->plotDesignation(), AbstractColumn::PlotDesignation::Y); |
| 187 | QCOMPARE(spreadsheet.column(4)->plotDesignation(), AbstractColumn::PlotDesignation::Y); |
| 188 | QCOMPARE(spreadsheet.column(5)->plotDesignation(), AbstractColumn::PlotDesignation::Y); |
| 189 | QCOMPARE(spreadsheet.column(6)->plotDesignation(), AbstractColumn::PlotDesignation::Y); |
| 190 | |
| 191 | QCOMPARE(spreadsheet.column(0)->name(), QLatin1String("MYCHAR")); |
| 192 | QCOMPARE(spreadsheet.column(1)->name(), QLatin1String("MYNUM")); |
| 193 | QCOMPARE(spreadsheet.column(2)->name(), QLatin1String("MYDATE")); |
| 194 | QCOMPARE(spreadsheet.column(3)->name(), QLatin1String("DTIME")); |
| 195 | QCOMPARE(spreadsheet.column(4)->name(), QLatin1String("MYLABL : labels0")); |
| 196 | QCOMPARE(spreadsheet.column(5)->name(), QLatin1String("MYORD : labels1")); |
| 197 | QCOMPARE(spreadsheet.column(6)->name(), QLatin1String("MYTIME")); |
| 198 | |
| 199 | QCOMPARE(spreadsheet.column(0)->textAt(0), QLatin1String("a")); |
| 200 | QCOMPARE(spreadsheet.column(0)->textAt(1), QLatin1String("b")); |
| 201 | QCOMPARE(spreadsheet.column(0)->textAt(2), QLatin1String("c")); |
| 202 | QCOMPARE(spreadsheet.column(0)->textAt(3), QLatin1String("d")); |
| 203 | QCOMPARE(spreadsheet.column(0)->textAt(4), QLatin1String("e")); |
| 204 | |
| 205 | QCOMPARE(spreadsheet.column(1)->valueAt(0), 1.1); |
| 206 | QCOMPARE(spreadsheet.column(1)->valueAt(1), 1.2); |
| 207 | QCOMPARE(spreadsheet.column(1)->valueAt(2), -1000.3); |
| 208 | QCOMPARE(spreadsheet.column(1)->valueAt(3), -1.4); |
| 209 | QCOMPARE(spreadsheet.column(1)->valueAt(4), 1000.3); |
| 210 | |
| 211 | QCOMPARE(spreadsheet.column(2)->valueAt(0), 1.3744944e10); |
| 212 | QCOMPARE(spreadsheet.column(2)->valueAt(1), 9.3901248e9); |
| 213 | QCOMPARE(spreadsheet.column(2)->valueAt(2), 1.190376e10); |
| 214 | QCOMPARE(spreadsheet.column(2)->valueAt(3), 6.8256e6); |
| 215 | QCOMPARE(spreadsheet.column(2)->valueAt(4), NAN); |
| 216 | |
| 217 | QCOMPARE(spreadsheet.column(3)->valueAt(0), 1.374498061e10); |
| 218 | QCOMPARE(spreadsheet.column(3)->valueAt(1), 9.39016141e9); |
| 219 | QCOMPARE(spreadsheet.column(3)->valueAt(2), 1.190376e10); |
| 220 | QCOMPARE(spreadsheet.column(3)->valueAt(3), 6.8256e6); |
| 221 | QCOMPARE(spreadsheet.column(3)->valueAt(4), NAN); |
| 222 |
nothing calls this directly
no test coverage detected