PhpOffice\PhpSpreadsheetTests\Writer\Xls\MicrosecondsTest

Complexity

Total Complexity

1

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	testIssue4476()	0	29	1

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Writer\Xls;

use DateTime;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;

class MicrosecondsTest extends AbstractFunctional
{
    /**
     * Test save and load XLSX file for round-trip DateTime.
     */
    public function testIssue4476(): void
    {
        $date = '2020-10-21';
        $time = '14:55:31';
        $originalDateTime = new DateTime("{$date}T{$time}");
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('A1', Date::dateTimeToExcel($originalDateTime));
        $sheet->getStyle('A1')
            ->getNumberFormat()
            ->setFormatCode('yyyy-mm-dd hh:mm:ss.000');
        $reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xls');
        $spreadsheet->disconnectWorksheets();

        $rsheet = $reloadedSpreadsheet->getActiveSheet();
        /** @var float */
        $reread = $rsheet->getCell('A1')->getValue();
        $temp = Date::excelToDateTimeObject($reread)
            ->format('Y-m-d H:i:s.u');
        self::assertSame("{$date} {$time}.000000", $temp, 'round trip works with float value');
        $formatted = $rsheet->getCell('A1')->getFormattedValue();
        self::assertSame("{$date} {$time}.000", $formatted, 'round trip works with formatted value');
        /** @var float */
        $temp = Date::stringToExcel($formatted);
        $temp = Date::excelToDateTimeObject($temp)
            ->format('Y-m-d H:i:s.u');
        self::assertSame("{$date} {$time}.000000", $temp, 'round trip works using stringToExcel on formatted value');

        $reloadedSpreadsheet->disconnectWorksheets();
    }
}