sheets/tests/TestUtil.cpp

0001 /* This file is part of the KDE project
0002    Copyright 2004,2007 Ariya Hidayat <ariya@kde.org>
0003
0004    This library is free software; you can redistribute it and/or
0005    modify it under the terms of the GNU Library General Public
0006    License as published by the Free Software Foundation; only
0007    version 2 of the License.
0008
0009    This library is distributed in the hope that it will be useful,
0010    but WITHOUT ANY WARRANTY; without even the implied warranty of
0011    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
0012    Library General Public License for more details.
0013
0014    You should have received a copy of the GNU Library General Public License
0015    along with this library; see the file COPYING.LIB.  If not, write to
0016    the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
0017    Boston, MA 02110-1301, USA.
0018 */
0019 #include "TestUtil.h"
0020
0021 #include "TestKspreadCommon.h"
0022 #include <Util.h>
0023
0024 using namespace Calligra::Sheets;
0025
0026 void TestUtil::testDecodeFormula_data()
0027 {
0028     QTest::addColumn<QString>("string");
0029     QTest::addColumn<QString>("result");
0030
0031     QTest::newRow("exponent") << "=(   (PI()/16)  *   ([.N102]*POWER([.J102];2))  *  (POWER(1.6E-019;2))   * (  1/ (1.6E-019*[.E102]*1000*9.1E-031) )     )"
0032                               << "=(   (PI()/16)  *   (N102*POWER(J102;2))  *  (POWER(1.6E-019;2))   * (  1/ (1.6E-019*E102*1000*9.1E-031) )     )";
0033     QTest::newRow("strange range") << "=['file:///Users/twacks/Library/Mail Downloads/Town Council/07-08 budgetFlat2%2525ColaSemiFinal-PropC.xls'#$'TH  3_7_2 proposed no p_s  _2_'.F21]"
0034                                    << "='file:///Users/twacks/Library/Mail Downloads/Town Council/07-08 budgetFlat2%2525ColaSemiFinal-PropC.xls'#$'TH  3_7_2 proposed no p_s  _2_'!F21";
0035     QTest::newRow("handle !") << "=#ref!#ref!"
0036                               << "=#ref!#ref!";
0037 }
0038
0039 void TestUtil::testDecodeFormula()
0040 {
0041     QFETCH(QString, string);
0042     QFETCH(QString, result);
0043
0044     QCOMPARE(Odf::decodeFormula(string), result);
0045 }
0046
0047 QTEST_MAIN(TestUtil)