mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-09-12 11:06:28 +00:00
40 lines
1008 B
PHP
40 lines
1008 B
PHP
<?php
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Logical;
|
|
|
|
class XorTest extends AllSetupTeardown
|
|
{
|
|
/**
|
|
* @dataProvider providerXOR
|
|
*
|
|
* @param mixed $expectedResult
|
|
*/
|
|
public function testXOR($expectedResult, ...$args): void
|
|
{
|
|
$this->runTestCase('XOR', $expectedResult, ...$args);
|
|
}
|
|
|
|
public static function providerXOR(): array
|
|
{
|
|
return require 'tests/data/Calculation/Logical/XOR.php';
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerXORLiteral
|
|
*
|
|
* @param mixed $expectedResult
|
|
* @param string $formula
|
|
*/
|
|
public function testXORLiteral($expectedResult, $formula): void
|
|
{
|
|
$sheet = $this->getSheet();
|
|
$sheet->getCell('A1')->setValue("=XOR($formula)");
|
|
self::assertSame($expectedResult, $sheet->getCell('A1')->getCalculatedValue());
|
|
}
|
|
|
|
public static function providerXORLiteral(): array
|
|
{
|
|
return require 'tests/data/Calculation/Logical/XORLiteral.php';
|
|
}
|
|
}
|