class CalculationTest in Loft Data Grids 6.2

Hierarchy

• class \CalculationTest extends \PHPUnit_Framework_TestCase

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/CalculationTest.php, line 5

class CalculationTest extends PHPUnit_Framework_TestCase {
  public function setUp() {
    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);
  }

  /**
   * @dataProvider providerBinaryComparisonOperation
   */
  public function testBinaryComparisonOperation($formula, $expectedResultExcel, $expectedResultOpenOffice) {
    PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
    $resultExcel = \PHPExcel_Calculation::getInstance()
      ->_calculateFormulaValue($formula);
    $this
      ->assertEquals($expectedResultExcel, $resultExcel, 'should be Excel compatible');
    PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE);
    $resultOpenOffice = \PHPExcel_Calculation::getInstance()
      ->_calculateFormulaValue($formula);
    $this
      ->assertEquals($expectedResultOpenOffice, $resultOpenOffice, 'should be OpenOffice compatible');
  }
  public function providerBinaryComparisonOperation() {
    return new testDataFileIterator('rawTestData/CalculationBinaryComparisonOperation.data');
  }

}

Members

Name	Modifiers	Type	Description	Overrides
CalculationTest::providerBinaryComparisonOperation	public	function
CalculationTest::setUp	public	function
CalculationTest::testBinaryComparisonOperation	public	function	@dataProvider providerBinaryComparisonOperation