Inheritance diagram for CalculationTest:

Collaboration diagram for CalculationTest:

Public Member Functions
	setUp ()

	testBinaryComparisonOperation ($formula, $expectedResultExcel, $expectedResultOpenOffice)
	providerBinaryComparisonOperation More...

	providerBinaryComparisonOperation ()

Detailed Description

Definition at line 5 of file CalculationTest.php.

Member Function Documentation

◆ providerBinaryComparisonOperation()

CalculationTest::providerBinaryComparisonOperation ( )

Definition at line 32 of file CalculationTest.php.

     {
         return new testDataFileIterator('rawTestData/CalculationBinaryComparisonOperation.data');
     }

◆ setUp()

CalculationTest::setUp ( )

Definition at line 8 of file CalculationTest.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:

◆ testBinaryComparisonOperation()

CalculationTest::testBinaryComparisonOperation	(	$formula,
		$expectedResultExcel,
		$expectedResultOpenOffice
	)

providerBinaryComparisonOperation

Definition at line 21 of file CalculationTest.php.

References PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL, PHPExcel_Calculation_Functions\COMPATIBILITY_OPENOFFICE, PHPExcel_Calculation\getInstance(), and PHPExcel_Calculation_Functions\setCompatibilityMode().

     {
         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');
     }