mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 01:35:12 +00:00
oleibman
5d1ab39def
Replace mock tests with real ones when possible. The original tests are all still present; they just take place in a more representative scenario. After this, there will be 4 remaining uses of mocking. Of these, 3 are needed for scenarios which are otherwise hard to test - WebServiceTest, CellsTest, and SampleCoverageTest. For the other one, AutoFilterTest, I just can't figure out what it's trying to accomplish, so have left it alone. This change is almost entirely restricted to tests. There is a one-line change in src. When the first argument passed to OFFSET is null or nullstring, the returned value is currently 0. However, according to the documentation for Excel, it should be `#VALUE!`. The code is changed accordingly.
40 lines
1.3 KiB
PHP
40 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\LookupRef;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\LookupRef;
|
|
|
|
class RowTest extends AllSetupTeardown
|
|
{
|
|
/**
|
|
* @dataProvider providerROW
|
|
*
|
|
* @param mixed $expectedResult
|
|
* @param null|array|string $cellReference
|
|
*/
|
|
public function testROW($expectedResult, $cellReference = null): void
|
|
{
|
|
$result = LookupRef\RowColumnInformation::ROW($cellReference);
|
|
self::assertSame($expectedResult, $result);
|
|
}
|
|
|
|
public function providerROW(): array
|
|
{
|
|
return require 'tests/data/Calculation/LookupRef/ROW.php';
|
|
}
|
|
|
|
public function testROWwithNull(): void
|
|
{
|
|
$sheet = $this->getSheet();
|
|
$sheet->getCell('C4')->setValue('=ROW()');
|
|
self::assertSame(4, $sheet->getCell('C4')->getCalculatedValue());
|
|
$sheet->getCell('D2')->setValue('=ROW(C13)');
|
|
self::assertSame(13, $sheet->getCell('D2')->getCalculatedValue());
|
|
// Sheetnames don't have to exist
|
|
$sheet->getCell('D3')->setValue('=ROW(Sheet17!E15)');
|
|
self::assertSame(15, $sheet->getCell('D3')->getCalculatedValue());
|
|
$sheet->getCell('D4')->setValue("=ROW('Worksheet #5'!X500)");
|
|
self::assertSame(500, $sheet->getCell('D4')->getCalculatedValue());
|
|
}
|
|
}
|