for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Statistical;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PHPUnit\Framework\TestCase;
class ModeTest extends TestCase
{
/**
* @dataProvider providerMODE
*
* @param mixed $expectedResult
* @param string $str
*/
public function testMODE($expectedResult, string $str): void
$workbook = new Spreadsheet();
$sheet = $workbook->getActiveSheet();
$row = 1;
$sheet->setCellValue("B$row", "=MODE($str)");
$sheet->setCellValue("C$row", "=MODE.SNGL($str)");
self::assertEquals($expectedResult, $sheet->getCell("B$row")->getCalculatedValue());
self::assertEquals($expectedResult, $sheet->getCell("C$row")->getCalculatedValue());
}
public function providerMODE(): array
return require 'tests/data/Calculation/Statistical/MODE.php';
public function testMODENoArgs(): void
$this->expectException(\PhpOffice\PhpSpreadsheet\Calculation\Exception::class);
$sheet->setCellValue('B1', '=MODE()');
self::assertEquals('#N/A', $sheet->getCell('B1')->getCalculatedValue());
PHPOffice /
PhpSpreadsheet
