mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-24 20:48:21 +00:00
oleibman
d7ac7021c6
See issue #2239. Problem is dealt with at the source, by making sure that Reader Xls checks for use of 'GENERAL' rather than 'General'. There doesn't seem to be a reason to test in other places, or to test for other casing variants.
35 lines
1.3 KiB
PHP
35 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Reader\Xls;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Reader\Xls;
|
|
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;
|
|
|
|
class NumberFormatGeneralTest extends AbstractFunctional
|
|
{
|
|
public function testGeneral(): void
|
|
{
|
|
$filename = 'tests/data/Reader/XLS/issue2239.xls';
|
|
$contents = file_get_contents($filename) ?: '';
|
|
self::assertStringContainsString('GENERAL', $contents);
|
|
|
|
$reader = new Xls();
|
|
$spreadsheet = $reader->load($filename);
|
|
$sheet = $spreadsheet->getSheetByName('Blad1');
|
|
if ($sheet === null) {
|
|
self::fail('Expected to find sheet Blad1');
|
|
} else {
|
|
$array = $sheet->toArray();
|
|
self::assertSame('€ 2.95', $array[1][3]);
|
|
self::assertSame(2.95, $sheet->getCell('D2')->getValue());
|
|
self::assertSame(2.95, $sheet->getCell('D2')->getCalculatedValue());
|
|
self::assertSame('€ 2.95', $sheet->getCell('D2')->getFormattedValue());
|
|
self::assertSame(21, $array[1][4]);
|
|
self::assertSame(21, $sheet->getCell('E2')->getValue());
|
|
self::assertSame(21, $sheet->getCell('E2')->getCalculatedValue());
|
|
self::assertSame('21', $sheet->getCell('E2')->getFormattedValue());
|
|
}
|
|
$spreadsheet->disconnectWorksheets();
|
|
}
|
|
}
|