You are here

public function AdvancedValueBinderTest::testCurrency in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Cell/AdvancedValueBinderTest.php \AdvancedValueBinderTest::testCurrency()

@dataProvider provider

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Cell/AdvancedValueBinderTest.php, line 36

Class

AdvancedValueBinderTest

Code

public function testCurrency($value, $valueBinded, $format, $thousandsSeparator, $decimalSeparator, $currencyCode) {
  $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());
}