import com.smartxls.RangeStyle;
import com.smartxls.WorkBook;

public class FormulaTestSample
{
    public static void main(String args[])
    {
        try
        {
            WorkBook m_view = new WorkBook();
            int rowIndex = 0;

            //set column width,units equal to 1/256th of the character 0's width in the default font
            m_view.setColWidth(0,10*256);
            m_view.setColWidth(1,25*256);
            m_view.setColWidth(2,25*256);
            m_view.setColWidth(4,14*256);
            m_view.setColWidth(5,14*256);

            m_view.setText(rowIndex, 1 , "result");
            m_view.setText(rowIndex, 2, "formula");
            String nextFunction = "ABS(-1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ACOS(.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ACOSH(1.2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ADDRESS(5,5,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "AND(TRUE(), FALSE())";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "AREAS(B2:C3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ASIN(1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ASINH(5.3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ATAN(3.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ATAN2(3, 6)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ATANH(.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "AVEDEV(1,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "AVERAGE(E2:E6)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "AVERAGEA(1,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BESSELI(3,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BESSELJ(2.5,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BESSELK(5,10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BESSELY(3,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BETADIST(0.5, 10, 1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BETAINV(0.5, 1, 1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BIN2DEC(10000000)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BIN2HEX(111111)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BIN2OCT(1110100)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "BINOMDIST(6,10,0.5,FALSE)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CEILING(1.23459, .05)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CELL(\"width\",C4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CHAR(70)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CHIDIST(9.6,10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CHIINV(0.05,5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CHOOSE(2,\"Q1\", \"Q2\", \"Q3\", \"Q4\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CLEAN(\"Payments \" & CHAR(8) & \"Due\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CODE(\"A\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COLUMN(B3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COLUMNS(A1:D5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CONCATENATE (\"Sale \", \"Price\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CONFIDENCE(0.05, 2.5, 50)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COMPLEX(2,3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CONVERT(1,\"m\",\"yd\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COS(5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COSH(2.10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUNT(5, 6, \"Q2\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUNTA(32, 45, \"Earnings\", \"\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUNTBLANK(A1:D2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUNTIF(C38:C40,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUPDAYBS(DATE(93,1,25),DATE(94,8,31),2,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUPDAYS(DATE(93,1,25),DATE(94,8,31),2,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUPDAYSNC(DATE(93,1,25),DATE(94,8,31),2,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUPNCD(DATE(93,1,25),DATE(94,8,31),2,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUPNUM(DATE(93,1,25),DATE(94,8,31),2,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COUPPCD(DATE(93,1,25),DATE(94,8,31),2,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "COVAR({1,2,3,4,5},{2,4,6,8,10})";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CRITBINOM(1000,0.5,0.3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CUMIPMT(0.009166667,60,17000,1,60,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "CUMPRINC(0.009166667,60,17000,1,34,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DATE(94, 6, 21)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DATEDIF(NOW(),DATE(2008,8,8),\"d\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DATEVALUE(\"3/6/05\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DAVERAGE(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DAY(34399)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DAYS360(\"1/11/06\", \"2/11/06\") ";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DB(10000, 1000, 7, 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DCOUNT(D1:F5,\"Salary\",E6:E7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DCOUNTA(D1:F5,\"Employee\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DDB(10000,1000, 7, 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DEC2BIN(256)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DEC2HEX(10,5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DEC2OCT(100)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DEGREES(6.283185307)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DELTA(6,7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DEVSQ(1, 2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DGET(D1:F5,\"Employee\",E6:E7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DISC(DATE(92,7,15),DATE(95,12,30),93,100)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DMAX(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DMIN(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DOLLAR(1023.789)";              //local currency
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DOLLARDE(25.3,4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DOLLARFR(25.25,4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DPRODUCT(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DSTDEV(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DSTDEVP(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "DSUM(D1:F5,\"Salary\",F6:F7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EDATE(DATE(2007,1,1),2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EFFECT(0.0675,12)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EOMONTH(DATE(2007,1,1),2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ERF(2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ERFC(1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ERROR.TYPE(B76)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EVEN(2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EXACT(\"Match\", \"Match\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EXP(2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "EXPONDIST(0.5,1,TRUE)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FACT(2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FACTDOUBLE(15)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FALSE()";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FDIST(2, 3, 4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FIND(\"time\", \"There¡¯s no time like the present\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FINV(0.05, 1, 4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FISHER (0.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FISHERINV(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FIXED(2000.5, 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FLOOR(1.23459, .05)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FORECAST(0.5, {1, 2, 4, 6, 7, 9}, {0, 2, 4, 5, 7, 8})";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FTEST({51,45,41,27},{91,37,89,82})";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FV(5%,8,-500)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "FVSCHEDULE(1000,{0.2,0.21,0.22})";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GAMMADIST (12, 3, 7, TRUE)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GAMMAINV (0.01, 8, 2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GAMMALN(5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GCD({1234567890,3000})";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GEOMEAN(24, 6)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GESTEP(6,7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "GROWTH({4,6,8,9},,3.5,TRUE)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);

            nextFunction = "HARMEAN(5,4,25,60,14,26)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "HEX2BIN(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "HEX2DEC(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "HEX2OCT(100)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "HLOOKUP(\"Northeast\",B1:E5,3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "HOUR(34259.4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "HYPERLINK(\"http://www.smartxls.com\",\"java spreadsheet component\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IF(A1>10, \"Greater\", \"Less\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMABS(\"3+4i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMAGINARY(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMARGUMENT(\"1+1i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMCONJUGATE(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMCOS(\"2+i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMDIV(\"-10+10i\",\"1+2i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMEXP(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMLN(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMLOG10(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMLOG2(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMPOWER(\"1+2i\",2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMPRODUCT(\"1+2i\",30)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMREAL(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMSIN(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMSQRT(\"2+3i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMSUB(\"2+3i\",\"3+4i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IMSUM(\"2+3i\",\"3+4i\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "INDEX(A2:B6,3,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "INDIRECT(B5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "INFO(\"release\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "INT(10.99)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IPMT(8%/12, 2, 48, 18000)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "IRR(E2:E5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISBLANK(A1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISERR(A1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISERROR(1/0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISEVEN(9.8)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISLOGICAL(ISBLANK(A1))";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISNA(A1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISNONTEXT(A3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISNUMBER(123.45)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISODD(9.8)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISREF(A3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ISTEXT(\"2nd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LCM(15,20)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LEFT(\"2nd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LEN(\"3rd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LN(12.18)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LOG(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LOG10(260)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LOGINV(0.223218,18,20)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LOGNORMDIST(16,18,20)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LOOKUP(\"Mike\", D2:D5, E2:E5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "LOWER(\"3rd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MATCH(7600, B2:B7,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MAX(50, 100, 150, 500, 200)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MAXA(50,100,150,\"500\",200)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MEDIAN(1,2,3,4,5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MID(\"Travel Expenses\", 8, 8)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MIN(50, 100, 150, 500, 200)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MINA(50,100,150,\"500\",200)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MINUTE(34506.4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MIRR(E2:E5, 12%, 8%)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MOD(-23,3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MODE(1,2,3,3,4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MONTH(34626)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "MROUND(13,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "N(A4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "NA()";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "NETWORKDAYS(1,365)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "NOT(TRUE())";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "NOW()";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "NPER(12%/12,-350,-300,16000,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "NPV(8%,-12000,3000,3000,3000,7000)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "OCT2BIN(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "OCT2DEC(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "OCT2HEX(10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ODD(3.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "OFFSET(B1, 3, 2, 1, 1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "OR(1 + 1 = 1, 5 + 5 = 10)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PEARSON({2,5,8},{3,6,7})";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PERCENTILE({1,2,3,4,5}, .25)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PERCENTRANK ({1, 2, 3, 4, 5}, 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PERMUT(4,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PI()";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PMT(8%/12, 48, 18000)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "POISSON(15,15,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "POWER(3,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PRICE(DATE(97,4,19),DATE(2001,11,25),0.05,0.075,100,4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PROPER(\"3rd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "PV(8%/12, 48, 439.43)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "QUOTIENT(9,7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "RADIANS(-180)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "RAND()*10";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "RANDBETWEEN(15,47)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "RATE(48,-439.43,18000)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "RECEIVED(DATE(94,1,1),DATE(97,10,1),50,0.0575)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "REPLACE(\"For the year: 1993\",18,1,\"4\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "REPT(\"error-\", 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "RIGHT(\"2nd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ROMAN(499)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ROUND(123.456, 2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ROUNDDOWN(3.14159, 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ROUNDUP(76.9,0)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ROW(B3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ROWS(A1:D5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SEARCH(\"?5\", \"Bin b45\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SECOND(.259)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SIGN(-123)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SIN(45)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SINH(1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SLN(10000, 1000, 7)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SQRT(9)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SQRTPI(2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "STANDARDIZE (95, 50, 4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "STDEV(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "STDEVA(4.0, 3.0, 3.0, 3.5, 2.5, \"4.0\", 3.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "STDEVP(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "STDEVPA(4.0, 3.0, 3.0, 3.5, 2.5, \"4.0\", 3.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SUBTOTAL(1,E2:E5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SUM(1000, 2000, 3000)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SUMIF(A1:B2,\"=0\",A4:B5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SUMPRODUCT(E2:E3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SUMSQ(9, 10, 11)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "SYD(10000, 1000, 7, 3)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "T(\"Report\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TAN(0.645)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TANH(-2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TDIST(1.75,3,1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TEXT(123.62, \"0.000\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TIME(12, 26, 24)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TIMEVALUE(\"1:43:43 am\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TINV (0.01, 2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TODAY()";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TRIM(\" Level 3, Gate 45 \")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TRUE()";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TRUNC(123.456, 2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "TYPE(A1)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "UPPER(\"3rd Quarter\")";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "USDOLLAR(1023.789)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VALUE(9800)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VAR(4.0, 3.0, 3.5, 2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VARA(4.0, 3.0, \"3.5\", 2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VARP(4.0, 3.0, 3.5, 2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VARPA(4.0, 3.0, \"3.5\", 2.5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VDB(10000, 1000, 7, 3, 4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "VLOOKUP(\"Jone\",D2:E5,2)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "WEEKDAY(34399.92)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "WEIBULL(100,3,120,TRUE)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "WORKDAY(DATEVALUE(\"2007/01/03\"),5)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "YEAR(34328)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "YEARFRAC(DATE(97,1,11),DATE(97,5,15))";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "YIELD(DATE(97,5,6),DATE(99,12,31),0.06,0.92,100,4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "YIELDDISC(DATE(94,10,23),DATE(95,7,7),98.31,100)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);
            nextFunction = "ZTEST ({1,2,3}, 4)";
            m_view.setFormula(++rowIndex, 1 , nextFunction);
            m_view.setText(rowIndex, 2, nextFunction);

            // Sample data
            m_view.setText(0, 3, "Employee");
            m_view.setText(0, 4, "Income");
            m_view.setText(0, 5, "Salary");
            m_view.setText(1, 3, "Mike");
            m_view.setText(2, 3, "Jone");
            m_view.setText(3, 3, "Peter");
            m_view.setText(4, 3, "Johanson");
            m_view.setNumber(1, 4, 15000);
            m_view.setNumber(2, 4, 25000);
            m_view.setNumber(3, 4, -65000);
            m_view.setNumber(4, 4, 28000);
            m_view.setNumber(1, 5, 15000);
            m_view.setNumber(2, 5, 25000);
            m_view.setNumber(3, 5, 30000);
            m_view.setNumber(4, 5, 27000);
            m_view.setText(5, 4, "Income");
            m_view.setText(6, 4, "<0");
            m_view.setText(5, 5, "Income");
            m_view.setText(6, 5, ">0");
            m_view.setSelection(0, 4, 4, 5);
            RangeStyle cfm = m_view.getRangeStyle();
            cfm.setCustomFormat("$#,##0.00;[Red]$#,##0.00");
            m_view.setRangeStyle(cfm);

            m_view.recalc();

            //m_view.write(".\\formulatest.xls");
            m_view.writeXLSX(".\\formulatest.xlsx");

        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}