vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Cell/AdvancedValueBinderTest.php

（开头部分） 2KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

<?php

class AdvancedValueBinderTest extends PHPUnit_Framework_TestCase
{
    public function setUp()
    {
        if (!defined('PHPEXCEL_ROOT')) {
            define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
        }
        require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
    }

    public function provider()
    {
        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, ',', '.', '€'),
        );
    }

    /**
     * @dataProvider provider
     */
    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')

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。