mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-25 12:58:22 +00:00
oleibman
5cfe66e18f
I check from time to time. There are a number of problems now, mostly due to the elimination of Php 7.4 and replacement of doc-block typing with explicit Php typing. - Bitwise functions were particularly affected by PR #3718 and PR #3793. - Chart/Axis and Writer/Xlsx were amusingly affected by PR #3836, which added a scaling option which included an array indexed by the known allowable factors, one of which is 1 trillion, which cannot be represented as an integer on a 32-bit system. Issue3833Test, introduced by the same PR (and not suffering any errors) was expanded to test this value. - Some minor changes to Reader/Xls and Shared/OLE/PPS to accommodate hex values which are negative in 32-bit but which Php-32 may wind up casting to large floating point numbers; it is not clear to me why these hadn't shown up as problems previously. Possibly this is the result of changes in the most recent Php versions. - BitAndTest, BitOrTest, BitXorTest and Shared/DateTest were adversely affected by PR #3859 when arguments and/or expected results too large for a 32-bit integer were supplied. - ImExpTest required a slightly reduced precision for 32-bit. No idea why this hadn't shown up earlier.
120 lines
3.6 KiB
PHP
120 lines
3.6 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Engineering;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Engineering\BitWise;
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Exception as CalculationException;
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
use PhpOffice\PhpSpreadsheetTests\Calculation\Functions\FormulaArguments;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
class BitAndTest extends TestCase
|
|
{
|
|
/**
|
|
* @dataProvider providerBITAND
|
|
*/
|
|
public function testDirectCallToBITAND(float|int|string $expectedResult, null|bool|int|float|string $arg1, null|bool|int|float|string $arg2): void
|
|
{
|
|
$result = BitWise::BITAND($arg1, $arg2);
|
|
self::assertSame($expectedResult, $result);
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerBITAND
|
|
*/
|
|
public function testBITANDAsFormula(float|int|string $expectedResult, mixed ...$args): void
|
|
{
|
|
$arguments = new FormulaArguments(...$args);
|
|
|
|
$calculation = Calculation::getInstance();
|
|
$formula = "=BITAND({$arguments})";
|
|
|
|
$result = $calculation->_calculateFormulaValue($formula);
|
|
self::assertSame($expectedResult, $result);
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerBITAND
|
|
*/
|
|
public function testBITANDInWorksheet(float|int|string $expectedResult, mixed ...$args): void
|
|
{
|
|
$arguments = new FormulaArguments(...$args);
|
|
|
|
$spreadsheet = new Spreadsheet();
|
|
$worksheet = $spreadsheet->getActiveSheet();
|
|
$argumentCells = $arguments->populateWorksheet($worksheet);
|
|
$formula = "=BITAND({$argumentCells})";
|
|
|
|
$result = $worksheet->setCellValue('A1', $formula)
|
|
->getCell('A1')
|
|
->getCalculatedValue();
|
|
self::assertSame($expectedResult, $result);
|
|
|
|
$spreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
public static function providerBITAND(): array
|
|
{
|
|
return require 'tests/data/Calculation/Engineering/BITAND.php';
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerUnhappyBITAND
|
|
*/
|
|
public function testBITANDUnhappyPath(string $expectedException, mixed ...$args): void
|
|
{
|
|
$arguments = new FormulaArguments(...$args);
|
|
|
|
$spreadsheet = new Spreadsheet();
|
|
$worksheet = $spreadsheet->getActiveSheet();
|
|
$argumentCells = $arguments->populateWorksheet($worksheet);
|
|
$formula = "=BITAND({$argumentCells})";
|
|
|
|
$this->expectException(CalculationException::class);
|
|
$this->expectExceptionMessage($expectedException);
|
|
$worksheet->setCellValue('A1', $formula)
|
|
->getCell('A1')
|
|
->getCalculatedValue();
|
|
|
|
$spreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
public static function providerUnhappyBITAND(): array
|
|
{
|
|
return [
|
|
['Formula Error: Wrong number of arguments for BITAND() function'],
|
|
['Formula Error: Wrong number of arguments for BITAND() function', 1234],
|
|
];
|
|
}
|
|
|
|
/**
|
|
* @dataProvider providerBitAndArray
|
|
*/
|
|
public function testBitAndArray(array $expectedResult, string $number1, string $number2): void
|
|
{
|
|
$calculation = Calculation::getInstance();
|
|
|
|
$formula = "=BITAND({$number1}, {$number2})";
|
|
$result = $calculation->_calculateFormulaValue($formula);
|
|
self::assertEquals($expectedResult, $result);
|
|
}
|
|
|
|
public static function providerBitAndArray(): array
|
|
{
|
|
return [
|
|
'row/column vector' => [
|
|
[
|
|
[3, 0, 1],
|
|
[4, 0, 0],
|
|
[5, 0, 1],
|
|
],
|
|
'{7, 8, 9}',
|
|
'{3; 4; 5}',
|
|
],
|
|
];
|
|
}
|
|
}
|