|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
declare(strict_types=1); |
|
4
|
|
|
|
|
5
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Reader\Xlsx; |
|
6
|
|
|
|
|
7
|
|
|
use PhpOffice\PhpSpreadsheet\IOFactory; |
|
8
|
|
|
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional; |
|
9
|
|
|
|
|
10
|
|
|
class ConditionalPriority2Test extends AbstractFunctional |
|
11
|
|
|
{ |
|
12
|
|
|
public function testConditionalPriority(): void |
|
13
|
|
|
{ |
|
14
|
|
|
$filename = 'tests/data/Reader/XLSX/issue.4318.xlsx'; |
|
15
|
|
|
$reader = IOFactory::createReader('Xlsx'); |
|
16
|
|
|
$spreadsheet = $reader->load($filename); |
|
17
|
|
|
$reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx'); |
|
18
|
|
|
$spreadsheet->disconnectWorksheets(); |
|
19
|
|
|
$sheet = $reloadedSpreadsheet->getActiveSheet(); |
|
20
|
|
|
$rules = $sheet->getConditionalStyles('E5', false); |
|
21
|
|
|
self::assertCount(4, $rules); |
|
22
|
|
|
self::assertSame(2, $rules[0]->getPriority()); |
|
23
|
|
|
self::assertSame(['$B$2<2'], $rules[0]->getConditions()); |
|
24
|
|
|
self::assertSame(3, $rules[1]->getPriority()); |
|
25
|
|
|
self::assertSame(['$B$2=""'], $rules[1]->getConditions()); |
|
26
|
|
|
self::assertSame(4, $rules[2]->getPriority()); |
|
27
|
|
|
self::assertSame(['$B$2=3'], $rules[2]->getConditions()); |
|
28
|
|
|
self::assertSame(5, $rules[3]->getPriority()); |
|
29
|
|
|
self::assertSame(['$B$2=2'], $rules[3]->getConditions()); |
|
30
|
|
|
$reloadedSpreadsheet->disconnectWorksheets(); |
|
31
|
|
|
} |
|
32
|
|
|
} |
|
33
|
|
|
|
PHPOffice /
PhpSpreadsheet
