PageSetup2Test.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Reader\Xlsx;
  3. use PhpOffice\PhpSpreadsheet\IOFactory;
  4. use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
  5. use PHPUnit\Framework\TestCase;
  6. class PageSetup2Test extends TestCase
  7. {
  8. private const TESTBOOK = 'tests/data/Reader/XLSX/autofilter2.xlsx';
  9. public function testHeaderFooter(): void
  10. {
  11. $spreadsheet = IOFactory::load(self::TESTBOOK);
  12. $sheets = 0;
  13. foreach ($spreadsheet->getAllSheets() as $worksheet) {
  14. ++$sheets;
  15. $hf = $worksheet->getHeaderFooter();
  16. self::assertTrue($hf->getDifferentOddEven());
  17. self::assertTrue($hf->getDifferentFirst());
  18. }
  19. self::assertSame(4, $sheets);
  20. $spreadsheet->disconnectWorksheets();
  21. }
  22. public function testColumnBreak(): void
  23. {
  24. $spreadsheet = IOFactory::load(self::TESTBOOK);
  25. $sheet = $spreadsheet->getSheetByNameOrThrow('colbreak');
  26. $breaks = $sheet->getBreaks();
  27. self::assertCount(1, $breaks);
  28. $break = $breaks['D1'] ?? null;
  29. self::assertNotNull($break);
  30. self::assertSame($break, Worksheet::BREAK_COLUMN);
  31. $spreadsheet->disconnectWorksheets();
  32. }
  33. }