Issue2450Test.php 959 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Reader\Xlsx;
  3. use PhpOffice\PhpSpreadsheet\IOFactory;
  4. use PHPUnit\Framework\TestCase;
  5. class Issue2450Test extends TestCase
  6. {
  7. public function testIssue2450(): void
  8. {
  9. // Style specified as GENERAL rather than General.
  10. $filename = 'tests/data/Reader/XLSX/issue.2450.xlsx';
  11. $reader = IOFactory::createReader('Xlsx');
  12. $spreadsheet = $reader->load($filename);
  13. $sheet = $spreadsheet->getActiveSheet();
  14. $birthYears = [
  15. 'C2' => $sheet->getCell('C2')->getFormattedValue(),
  16. 'C3' => $sheet->getCell('C3')->getFormattedValue(),
  17. 'C4' => $sheet->getCell('C4')->getFormattedValue(),
  18. ];
  19. self::assertSame(
  20. [
  21. 'C2' => '1932',
  22. 'C3' => '1964',
  23. 'C4' => '1988',
  24. ],
  25. $birthYears
  26. );
  27. $spreadsheet->disconnectWorksheets();
  28. }
  29. }