mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-09-07 16:46:57 +00:00
oleibman
fe79f7b02c
* Fix Unintential Deprecated Calls in Tests - INFORMATION I think it's best to install these before PR #3166. There are no changes to source code, only to doc-blocks and to test members which continue to inadvertently use calls to deprecated functions. * Missed Some Deprecated Calls Fix them now.
52 lines
2.8 KiB
PHP
52 lines
2.8 KiB
PHP
<?php
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Information;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Functions;
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
// Sanity tests for functions which have been moved out of Functions
|
|
// to their own classes. A deprecated version remains in Functions;
|
|
// this class contains cursory tests to ensure that those work properly.
|
|
// If Scrutinizer fails the PR because of these deprecations, I will
|
|
// remove this class from the PR.
|
|
|
|
class DeprecatedFunctionsTest extends TestCase
|
|
{
|
|
public function testDeprecated(): void
|
|
{
|
|
self::assertSame('#DIV/0!', /** @scrutinizer ignore-deprecated */ Functions::DIV0());
|
|
self::assertSame('#N/A', /** @scrutinizer ignore-deprecated */ Functions::errorType());
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isBlank());
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isErr('#DIV/0!'));
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isError('#DIV/0!'));
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isEven(2));
|
|
// isFormula needs more complicated test - see next method
|
|
self::assertFalse(/** @scrutinizer ignore-deprecated */ Functions::isNa());
|
|
self::assertFalse(/** @scrutinizer ignore-deprecated */ Functions::isLogical());
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isNonText(2));
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isNumber(2));
|
|
self::assertFalse(/** @scrutinizer ignore-deprecated */ Functions::isOdd(2));
|
|
self::assertFalse(/** @scrutinizer ignore-deprecated */ Functions::isText(2));
|
|
self::assertSame('#N/A', /** @scrutinizer ignore-deprecated */ Functions::NA());
|
|
self::assertSame('#NAME?', /** @scrutinizer ignore-deprecated */ Functions::NAME());
|
|
self::assertSame('#NUM!', /** @scrutinizer ignore-deprecated */ Functions::NAN());
|
|
self::assertSame(1, /** @scrutinizer ignore-deprecated */ Functions::n(true));
|
|
self::assertSame('#NULL!', /** @scrutinizer ignore-deprecated */ Functions::null());
|
|
self::assertSame('#REF!', /** @scrutinizer ignore-deprecated */ Functions::REF());
|
|
self::assertSame(1, /** @scrutinizer ignore-deprecated */ Functions::type(7));
|
|
self::assertSame('#VALUE!', /** @scrutinizer ignore-deprecated */ Functions::VALUE());
|
|
}
|
|
|
|
public function testIsFormula(): void
|
|
{
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
$cell = $sheet->getCell('A1');
|
|
$cell->setValue('=1');
|
|
self::assertTrue(/** @scrutinizer ignore-deprecated */ Functions::isFormula('A1', $cell));
|
|
$spreadsheet->disconnectWorksheets();
|
|
}
|
|
}
|