Inheritance diagram for AdvancedValueBinderTest:

Collaboration diagram for AdvancedValueBinderTest:

Public Member Functions
	setUp ()

	provider ()

	testCurrency ($value, $valueBinded, $format, $thousandsSeparator, $decimalSeparator, $currencyCode)
	provider More...

Detailed Description

Definition at line 3 of file AdvancedValueBinderTest.php.

Member Function Documentation

◆ provider()

AdvancedValueBinderTest::provider ( )

Definition at line 13 of file AdvancedValueBinderTest.php.

References array, PHPExcel_Style_NumberFormat\FORMAT_CURRENCY_USD_SIMPLE, PHPExcel_Style_NumberFormat\FORMAT_PERCENTAGE_00, and setUp().

     {
         if (!class_exists('PHPExcel_Style_NumberFormat')) {
           $this->setUp();
         }
         $currencyUSD = PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE;
         $currencyEURO = str_replace('$', '€', PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE);
 
         return array(
           array('10%', 0.1, PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00, ',', '.', '$'),
           array('$10.11', 10.11, $currencyUSD, ',', '.', '$'),
           array('$1,010.12', 1010.12, $currencyUSD, ',', '.', '$'),
           array('$20,20', 20.2, $currencyUSD, '.', ',', '$'),
           array('$2.020,20', 2020.2, $currencyUSD, '.', ',', '$'),
           array('€2.020,20', 2020.2, $currencyEURO, '.', ',', '€'),
           array('€ 2.020,20', 2020.2, $currencyEURO, '.', ',', '€'),
           array('€2,020.22', 2020.22, $currencyEURO, ',', '.', '€'),
         );
     }

Here is the call graph for this function:

◆ setUp()

AdvancedValueBinderTest::setUp ( )

Definition at line 5 of file AdvancedValueBinderTest.php.

References defined.

Referenced by provider().

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

Here is the caller graph for this function:

◆ testCurrency()

AdvancedValueBinderTest::testCurrency	(	$value,
		$valueBinded,
		$format,
		$thousandsSeparator,
		$decimalSeparator,
		$currencyCode
	)

provider

Definition at line 36 of file AdvancedValueBinderTest.php.

References array, PHPExcel_Shared_String\setCurrencyCode(), PHPExcel_Shared_String\setDecimalSeparator(), PHPExcel_Shared_String\setThousandsSeparator(), and PHPExcel_Cell_DataType\TYPE_STRING.

     {
         $sheet = $this->getMock(
                         'PHPExcel_Worksheet', 
                         array('getStyle', 'getNumberFormat', 'setFormatCode','getCellCacheController')
                 );
         $cache = $this->getMockBuilder('PHPExcel_CachedObjectStorage_Memory')
                 ->disableOriginalConstructor()
                 ->getMock();
         $cache->expects($this->any())
                  ->method('getParent')
                  ->will($this->returnValue($sheet));
 
         $sheet->expects($this->once())
                  ->method('getStyle')
                  ->will($this->returnSelf());
         $sheet->expects($this->once())
                  ->method('getNumberFormat')
                  ->will($this->returnSelf());
         $sheet->expects($this->once())
                  ->method('setFormatCode')
                  ->with($format)
                  ->will($this->returnSelf());
         $sheet->expects($this->any())
                  ->method('getCellCacheController')
                  ->will($this->returnValue($cache));
 
         PHPExcel_Shared_String::setCurrencyCode($currencyCode);
         PHPExcel_Shared_String::setDecimalSeparator($decimalSeparator);
         PHPExcel_Shared_String::setThousandsSeparator($thousandsSeparator);
 
         $cell = new PHPExcel_Cell(NULL, PHPExcel_Cell_DataType::TYPE_STRING, $sheet);
 
         $binder = new PHPExcel_Cell_AdvancedValueBinder();
         $binder->bindValue($cell, $value);
         $this->assertEquals($valueBinded, $cell->getValue());
     }