Class VbaTest


  • public class VbaTest
    extends TestCase
    Unit tests for implementations of Visual Basic for Applications (VBA) functions.

    Every function defined in Vba must have a test here. In addition, there should be MDX tests (usually in FunctionTest) if handling of argument types, result types, operator overloading, exception handling or null handling are non-trivial.

    Since:
    Dec 31, 2007
    Author:
    jhyde
    • Constructor Detail

      • VbaTest

        public VbaTest()
    • Method Detail

      • testCBool

        public void testCBool()
      • testCInt

        public void testCInt()
      • testInt

        public void testInt()
      • testFix

        public void testFix()
      • testCDbl

        public void testCDbl()
      • testHex

        public void testHex()
      • testOct

        public void testOct()
      • testStr

        public void testStr()
      • testVal

        public void testVal()
      • testDateAdd

        public void testDateAdd()
      • testAddDate_Days_NextYear

        public void testAddDate_Days_NextYear()
                                       throws Exception
        Throws:
        Exception
      • testAddDate_Days_PreviousMonth

        public void testAddDate_Days_PreviousMonth()
                                            throws Exception
        Throws:
        Exception
      • testAddDate_Days_NextMonth

        public void testAddDate_Days_NextMonth()
                                        throws Exception
        Throws:
        Exception
      • testAddDate_Days_PreviousYear

        public void testAddDate_Days_PreviousYear()
                                           throws Exception
        Throws:
        Exception
      • testAddDate_Days_LeapYear

        public void testAddDate_Days_LeapYear()
                                       throws Exception
        Throws:
        Exception
      • testDateDiff

        public void testDateDiff()
      • testDateDiff_Days_SameDay

        public void testDateDiff_Days_SameDay()
                                       throws Exception
        Throws:
        Exception
      • testDateDiff_Days_LessThanOneDaySameYear

        public void testDateDiff_Days_LessThanOneDaySameYear()
                                                      throws Exception
        Throws:
        Exception
      • testDateDiff_Days_LessThanOneDaySpanYear

        public void testDateDiff_Days_LessThanOneDaySpanYear()
                                                      throws Exception
        Throws:
        Exception
      • testDateDiff_Days_24hours

        public void testDateDiff_Days_24hours()
                                       throws Exception
        Throws:
        Exception
      • testDateDiff_Days_DST

        public void testDateDiff_Days_DST()
                                   throws Exception
        Throws:
        Exception
      • testDateDiff_Days_NextDay

        public void testDateDiff_Days_NextDay()
                                       throws Exception
        Throws:
        Exception
      • testDateDiff_Days_NextMonth

        public void testDateDiff_Days_NextMonth()
                                         throws Exception
        Throws:
        Exception
      • testDateDiff_Days_NextYear

        public void testDateDiff_Days_NextYear()
                                        throws Exception
        Throws:
        Exception
      • testDateDiff_Days_FromDecToJan

        public void testDateDiff_Days_FromDecToJan()
                                            throws Exception
        Throws:
        Exception
      • testDatePart2

        public void testDatePart2()
      • testDatePart3

        public void testDatePart3()
      • testDatePart4

        public void testDatePart4()
      • testDatePart_Y_vs_D

        public void testDatePart_Y_vs_D()
                                 throws Exception
        Throws:
        Exception
      • testDate

        public void testDate()
      • testDateSerial

        public void testDateSerial()
      • testFormatDateTime

        public void testFormatDateTime()
      • testDateValue

        public void testDateValue()
      • testDay

        public void testDay()
      • testHour

        public void testHour()
      • testMinute

        public void testMinute()
      • testMonth

        public void testMonth()
      • testNow

        public void testNow()
      • testSecond

        public void testSecond()
      • testTimeSerial

        public void testTimeSerial()
      • testTimeValue

        public void testTimeValue()
      • testTimer

        public void testTimer()
      • testWeekday1

        public void testWeekday1()
      • testWeekday2

        public void testWeekday2()
      • testYear

        public void testYear()
      • testFormatNumber

        public void testFormatNumber()
      • testFormatPercent

        public void testFormatPercent()
      • testFormatCurrency

        public void testFormatCurrency()
      • testTypeName

        public void testTypeName()
      • testFv

        public void testFv()
      • testNpv

        public void testNpv()
      • testPmt

        public void testPmt()
      • testPv

        public void testPv()
      • testDdb

        public void testDdb()
      • testRate

        public void testRate()
      • testIRR

        public void testIRR()
      • testMIRR

        public void testMIRR()
      • testIPmt

        public void testIPmt()
      • testPPmt

        public void testPPmt()
      • testSLN

        public void testSLN()
      • testSYD

        public void testSYD()
      • testInStr

        public void testInStr()
      • testInStrRev

        public void testInStrRev()
      • testStrComp

        public void testStrComp()
      • testNper

        public void testNper()
      • testAsc

        public void testAsc()
      • testAscB

        public void testAscB()
      • testAscW

        public void testAscW()
      • testChr

        public void testChr()
      • testChrB

        public void testChrB()
      • testChrW

        public void testChrW()
      • testLCase

        public void testLCase()
      • testLeft

        public void testLeft()
      • testLTrim

        public void testLTrim()
      • testMid

        public void testMid()
      • testMonthName

        public void testMonthName()
      • testReplace3

        public void testReplace3()
      • testReplace4

        public void testReplace4()
      • testReplace5

        public void testReplace5()
      • testReplace6

        public void testReplace6()
      • testRight

        public void testRight()
      • testRTrim

        public void testRTrim()
      • testSpace

        public void testSpace()
      • testString

        public void testString()
      • testStrReverse

        public void testStrReverse()
      • testTrim

        public void testTrim()
      • testWeekdayName

        public void testWeekdayName()
      • testAbs

        public void testAbs()
      • testAtn

        public void testAtn()
      • testCos

        public void testCos()
      • testExp

        public void testExp()
      • testRound

        public void testRound()
      • testRound2

        public void testRound2()
      • testSgn

        public void testSgn()
      • testSin

        public void testSin()
      • testSqr

        public void testSqr()
      • testTan

        public void testTan()