mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-09-09 09:36:25 +00:00
37 lines
949 B
PHP
37 lines
949 B
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Logical;
|
|
|
|
class XorTest extends AllSetupTeardown
|
|
{
|
|
/**
|
|
* @dataProvider providerXOR
|
|
*/
|
|
public function testXOR(mixed $expectedResult, mixed ...$args): void
|
|
{
|
|
$this->runTestCase('XOR', $expectedResult, ...$args);
|
|
}
|
|
|
|
public static function providerXOR(): array
|
|
{
|
|
return require 'tests/data/Calculation/Logical/XOR.php';
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerXORLiteral
|
|
*/
|
|
public function testXORLiteral(mixed $expectedResult, float|string $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';
|
|
}
|
|
}
|