Inheritance diagram for DateTimeTest:

Collaboration diagram for DateTimeTest:

Public Member Functions
	setUp ()

	testDATE ()
	providerDATE More...

	providerDATE ()

	testDATEtoPHP ()

	testDATEtoPHPObject ()

	testDATEwith1904Calendar ()

	testDATEwith1904CalendarError ()

	testDATEVALUE ()
	providerDATEVALUE More...

	providerDATEVALUE ()

	testDATEVALUEtoPHP ()

	testDATEVALUEtoPHPObject ()

	testYEAR ()
	providerYEAR More...

	providerYEAR ()

	testMONTH ()
	providerMONTH More...

	providerMONTH ()

	testWEEKNUM ()
	providerWEEKNUM More...

	providerWEEKNUM ()

	testWEEKDAY ()
	providerWEEKDAY More...

	providerWEEKDAY ()

	testDAY ()
	providerDAY More...

	providerDAY ()

	testTIME ()
	providerTIME More...

	providerTIME ()

	testTIMEtoPHP ()

	testTIMEtoPHPObject ()

	testTIMEVALUE ()
	providerTIMEVALUE More...

	providerTIMEVALUE ()

	testTIMEVALUEtoPHP ()

	testTIMEVALUEtoPHPObject ()

	testHOUR ()
	providerHOUR More...

	providerHOUR ()

	testMINUTE ()
	providerMINUTE More...

	providerMINUTE ()

	testSECOND ()
	providerSECOND More...

	providerSECOND ()

	testNETWORKDAYS ()
	providerNETWORKDAYS More...

	providerNETWORKDAYS ()

	testWORKDAY ()
	providerWORKDAY More...

	providerWORKDAY ()

	testEDATE ()
	providerEDATE More...

	providerEDATE ()

	testEDATEtoPHP ()

	testEDATEtoPHPObject ()

	testEOMONTH ()
	providerEOMONTH More...

	providerEOMONTH ()

	testEOMONTHtoPHP ()

	testEOMONTHtoPHPObject ()

	testDATEDIF ()
	providerDATEDIF More...

	providerDATEDIF ()

	testDAYS360 ()
	providerDAYS360 More...

	providerDAYS360 ()

	testYEARFRAC ()
	providerYEARFRAC More...

	providerYEARFRAC ()

Detailed Description

Definition at line 6 of file DateTimeTest.php.

Member Function Documentation

◆ providerDATE()

DateTimeTest::providerDATE ( )

Definition at line 31 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/DATE.data');
         }

◆ providerDATEDIF()

DateTimeTest::providerDATEDIF ( )

Definition at line 429 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/DATEDIF.data');
         }

◆ providerDATEVALUE()

DateTimeTest::providerDATEVALUE ( )

Definition at line 84 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/DATEVALUE.data');
         }

◆ providerDAY()

DateTimeTest::providerDAY ( )

Definition at line 185 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/DAY.data');
         }

◆ providerDAYS360()

DateTimeTest::providerDAYS360 ( )

Definition at line 445 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/DAYS360.data');
         }

◆ providerEDATE()

DateTimeTest::providerEDATE ( )

Definition at line 355 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/EDATE.data');
         }

◆ providerEOMONTH()

DateTimeTest::providerEOMONTH ( )

Definition at line 392 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/EOMONTH.data');
         }

◆ providerHOUR()

DateTimeTest::providerHOUR ( )

Definition at line 275 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/HOUR.data');
         }

◆ providerMINUTE()

DateTimeTest::providerMINUTE ( )

Definition at line 291 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/MINUTE.data');
         }

◆ providerMONTH()

DateTimeTest::providerMONTH ( )

Definition at line 137 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/MONTH.data');
         }

◆ providerNETWORKDAYS()

DateTimeTest::providerNETWORKDAYS ( )

Definition at line 323 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/NETWORKDAYS.data');
         }

◆ providerSECOND()

DateTimeTest::providerSECOND ( )

Definition at line 307 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/SECOND.data');
         }

◆ providerTIME()

DateTimeTest::providerTIME ( )

Definition at line 201 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/TIME.data');
         }

◆ providerTIMEVALUE()

DateTimeTest::providerTIMEVALUE ( )

Definition at line 238 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/TIMEVALUE.data');
         }

◆ providerWEEKDAY()

DateTimeTest::providerWEEKDAY ( )

Definition at line 169 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/WEEKDAY.data');
         }

◆ providerWEEKNUM()

DateTimeTest::providerWEEKNUM ( )

Definition at line 153 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/WEEKNUM.data');
         }

◆ providerWORKDAY()

DateTimeTest::providerWORKDAY ( )

Definition at line 339 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/WORKDAY.data');
         }

◆ providerYEAR()

DateTimeTest::providerYEAR ( )

Definition at line 121 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/YEAR.data');
         }

◆ providerYEARFRAC()

DateTimeTest::providerYEARFRAC ( )

Definition at line 461 of file DateTimeTest.php.

     {
         return new testDataFileIterator('rawTestData/Calculation/DateTime/YEARFRAC.data');
         }

◆ setUp()

DateTimeTest::setUp ( )

Definition at line 9 of file DateTimeTest.php.

References PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL, defined, and PHPExcel_Calculation_Functions\setCompatibilityMode().

     {
         if (!defined('PHPEXCEL_ROOT'))
         {
             define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
         }
         require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
 
         PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
         }

Here is the call graph for this function:

◆ testDATE()

DateTimeTest::testDATE ( )

providerDATE

Definition at line 23 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DATE'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testDATEDIF()

DateTimeTest::testDATEDIF ( )

providerDATEDIF

Definition at line 421 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DATEDIF'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testDATEtoPHP()

DateTimeTest::testDATEtoPHP ( )

Definition at line 36 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
                 $result = PHPExcel_Calculation_DateTime::DATE(2012,1,31);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
                 $this->assertEquals(1327968000, $result, NULL, 1E-8);
         }

Here is the call graph for this function:

◆ testDATEtoPHPObject()

DateTimeTest::testDATEtoPHPObject ( )

Definition at line 44 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
                 $result = PHPExcel_Calculation_DateTime::DATE(2012,1,31);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
         //    Must return an object...
         $this->assertTrue(is_object($result));
         //    ... of the correct type
         $this->assertTrue(is_a($result,'DateTime'));
         //    ... with the correct value
         $this->assertEquals($result->format('d-M-Y'),'31-Jan-2012');
         }

Here is the call graph for this function:

◆ testDATEVALUE()

DateTimeTest::testDATEVALUE ( )

providerDATEVALUE

Definition at line 76 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DATEVALUE'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testDATEVALUEtoPHP()

DateTimeTest::testDATEVALUEtoPHP ( )

Definition at line 89 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
                 $result = PHPExcel_Calculation_DateTime::DATEVALUE('2012-1-31');
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
                 $this->assertEquals(1327968000, $result, NULL, 1E-8);
         }

Here is the call graph for this function:

◆ testDATEVALUEtoPHPObject()

DateTimeTest::testDATEVALUEtoPHPObject ( )

Definition at line 97 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
                 $result = PHPExcel_Calculation_DateTime::DATEVALUE('2012-1-31');
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
         //    Must return an object...
         $this->assertTrue(is_object($result));
         //    ... of the correct type
         $this->assertTrue(is_a($result,'DateTime'));
         //    ... with the correct value
         $this->assertEquals($result->format('d-M-Y'),'31-Jan-2012');
         }

Here is the call graph for this function:

◆ testDATEwith1904Calendar()

DateTimeTest::testDATEwith1904Calendar ( )

Definition at line 57 of file DateTimeTest.php.

References $result, PHPExcel_Shared_Date\CALENDAR_MAC_1904, PHPExcel_Shared_Date\CALENDAR_WINDOWS_1900, PHPExcel_Calculation_DateTime\DATE(), and PHPExcel_Shared_Date\setExcelCalendar().

         {
                 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_MAC_1904);
                 $result = PHPExcel_Calculation_DateTime::DATE(1918,11,11);
                 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_WINDOWS_1900);
         $this->assertEquals($result,5428);
         }

Here is the call graph for this function:

◆ testDATEwith1904CalendarError()

DateTimeTest::testDATEwith1904CalendarError ( )

Definition at line 65 of file DateTimeTest.php.

References $result, PHPExcel_Shared_Date\CALENDAR_MAC_1904, PHPExcel_Shared_Date\CALENDAR_WINDOWS_1900, PHPExcel_Calculation_DateTime\DATE(), and PHPExcel_Shared_Date\setExcelCalendar().

         {
                 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_MAC_1904);
                 $result = PHPExcel_Calculation_DateTime::DATE(1901,1,31);
                 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_WINDOWS_1900);
         $this->assertEquals($result,'#NUM!');
         }

Here is the call graph for this function:

◆ testDAY()

DateTimeTest::testDAY ( )

providerDAY

Definition at line 177 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DAYOFMONTH'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testDAYS360()

DateTimeTest::testDAYS360 ( )

providerDAYS360

Definition at line 437 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DAYS360'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testEDATE()

DateTimeTest::testEDATE ( )

providerEDATE

Definition at line 347 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','EDATE'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testEDATEtoPHP()

DateTimeTest::testEDATEtoPHP ( )

Definition at line 360 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
                 $result = PHPExcel_Calculation_DateTime::EDATE('2012-1-26',-1);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
                 $this->assertEquals(1324857600, $result, NULL, 1E-8);
         }

Here is the call graph for this function:

◆ testEDATEtoPHPObject()

DateTimeTest::testEDATEtoPHPObject ( )

Definition at line 368 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
                 $result = PHPExcel_Calculation_DateTime::EDATE('2012-1-26',-1);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
         //    Must return an object...
         $this->assertTrue(is_object($result));
         //    ... of the correct type
         $this->assertTrue(is_a($result,'DateTime'));
         //    ... with the correct value
         $this->assertEquals($result->format('d-M-Y'),'26-Dec-2011');
         }

Here is the call graph for this function:

◆ testEOMONTH()

DateTimeTest::testEOMONTH ( )

providerEOMONTH

Definition at line 384 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','EOMONTH'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testEOMONTHtoPHP()

DateTimeTest::testEOMONTHtoPHP ( )

Definition at line 397 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\EOMONTH(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
                 $result = PHPExcel_Calculation_DateTime::EOMONTH('2012-1-26',-1);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
                 $this->assertEquals(1325289600, $result, NULL, 1E-8);
         }

Here is the call graph for this function:

◆ testEOMONTHtoPHPObject()

DateTimeTest::testEOMONTHtoPHPObject ( )

Definition at line 405 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_DateTime\EOMONTH(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
                 $result = PHPExcel_Calculation_DateTime::EOMONTH('2012-1-26',-1);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
         //    Must return an object...
         $this->assertTrue(is_object($result));
         //    ... of the correct type
         $this->assertTrue(is_a($result,'DateTime'));
         //    ... with the correct value
         $this->assertEquals($result->format('d-M-Y'),'31-Dec-2011');
         }

Here is the call graph for this function:

◆ testHOUR()

DateTimeTest::testHOUR ( )

providerHOUR

Definition at line 267 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','HOUROFDAY'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testMINUTE()

DateTimeTest::testMINUTE ( )

providerMINUTE

Definition at line 283 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','MINUTEOFHOUR'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testMONTH()

DateTimeTest::testMONTH ( )

providerMONTH

Definition at line 129 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','MONTHOFYEAR'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testNETWORKDAYS()

DateTimeTest::testNETWORKDAYS ( )

providerNETWORKDAYS

Definition at line 315 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','NETWORKDAYS'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testSECOND()

DateTimeTest::testSECOND ( )

providerSECOND

Definition at line 299 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','SECONDOFMINUTE'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testTIME()

DateTimeTest::testTIME ( )

providerTIME

Definition at line 193 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','TIME'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testTIMEtoPHP()

DateTimeTest::testTIMEtoPHP ( )

Definition at line 206 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIME().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
                 $result = PHPExcel_Calculation_DateTime::TIME(7,30,20);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
                 $this->assertEquals(27020, $result, NULL, 1E-8);
         }

Here is the call graph for this function:

◆ testTIMEtoPHPObject()

DateTimeTest::testTIMEtoPHPObject ( )

Definition at line 214 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIME().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
                 $result = PHPExcel_Calculation_DateTime::TIME(7,30,20);
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
         //    Must return an object...
         $this->assertTrue(is_object($result));
         //    ... of the correct type
         $this->assertTrue(is_a($result,'DateTime'));
         //    ... with the correct value
         $this->assertEquals($result->format('H:i:s'),'07:30:20');
         }

Here is the call graph for this function:

◆ testTIMEVALUE()

DateTimeTest::testTIMEVALUE ( )

providerTIMEVALUE

Definition at line 230 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','TIMEVALUE'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testTIMEVALUEtoPHP()

DateTimeTest::testTIMEVALUEtoPHP ( )

Definition at line 243 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIMEVALUE().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
                 $result = PHPExcel_Calculation_DateTime::TIMEVALUE('7:30:20');
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
                 $this->assertEquals(23420, $result, NULL, 1E-8);
         }

Here is the call graph for this function:

◆ testTIMEVALUEtoPHPObject()

DateTimeTest::testTIMEVALUEtoPHPObject ( )

Definition at line 251 of file DateTimeTest.php.

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIMEVALUE().

         {
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
                 $result = PHPExcel_Calculation_DateTime::TIMEVALUE('7:30:20');
                 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
         //    Must return an object...
         $this->assertTrue(is_object($result));
         //    ... of the correct type
         $this->assertTrue(is_a($result,'DateTime'));
         //    ... with the correct value
         $this->assertEquals($result->format('H:i:s'),'07:30:20');
         }

Here is the call graph for this function:

◆ testWEEKDAY()

DateTimeTest::testWEEKDAY ( )

providerWEEKDAY

Definition at line 161 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DAYOFWEEK'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testWEEKNUM()

DateTimeTest::testWEEKNUM ( )

providerWEEKNUM

Definition at line 145 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','WEEKOFYEAR'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testWORKDAY()

DateTimeTest::testWORKDAY ( )

providerWORKDAY

Definition at line 331 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','WORKDAY'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testYEAR()

DateTimeTest::testYEAR ( )

providerYEAR

Definition at line 113 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','YEAR'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

◆ testYEARFRAC()

DateTimeTest::testYEARFRAC ( )

providerYEARFRAC

Definition at line 453 of file DateTimeTest.php.

References $result, and array.

         {
                 $args = func_get_args();
                 $expectedResult = array_pop($args);
                 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','YEARFRAC'),$args);
                 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
         }

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/DateTimeTest.php

Public Member Functions

Detailed Description

Member Function Documentation

◆ providerDATE()

◆ providerDATEDIF()

◆ providerDATEVALUE()

◆ providerDAY()

◆ providerDAYS360()

◆ providerEDATE()

◆ providerEOMONTH()

◆ providerHOUR()

◆ providerMINUTE()

◆ providerMONTH()

◆ providerNETWORKDAYS()

◆ providerSECOND()

◆ providerTIME()

◆ providerTIMEVALUE()

◆ providerWEEKDAY()

◆ providerWEEKNUM()

◆ providerWORKDAY()

◆ providerYEAR()

◆ providerYEARFRAC()

◆ setUp()

◆ testDATE()

◆ testDATEDIF()

◆ testDATEtoPHP()

◆ testDATEtoPHPObject()

◆ testDATEVALUE()

◆ testDATEVALUEtoPHP()

◆ testDATEVALUEtoPHPObject()

◆ testDATEwith1904Calendar()

◆ testDATEwith1904CalendarError()

◆ testDAY()

◆ testDAYS360()

◆ testEDATE()

◆ testEDATEtoPHP()

◆ testEDATEtoPHPObject()

◆ testEOMONTH()

◆ testEOMONTHtoPHP()

◆ testEOMONTHtoPHPObject()

◆ testHOUR()

◆ testMINUTE()

◆ testMONTH()

◆ testNETWORKDAYS()

◆ testSECOND()

◆ testTIME()

◆ testTIMEtoPHP()

◆ testTIMEtoPHPObject()

◆ testTIMEVALUE()

◆ testTIMEVALUEtoPHP()

◆ testTIMEVALUEtoPHPObject()

◆ testWEEKDAY()

◆ testWEEKNUM()

◆ testWORKDAY()

◆ testYEAR()

◆ testYEARFRAC()