insertDate with standard format value changes the dates to show as numbers

[DAdq26]

Hi
The issue (#527) seems to be still active with php 8.3 and xlswriter 1.5.8 release..
On my own

Code to reproduce

<?php

use Vtiful\Kernel\Excel;

require_once "../External/autoload.php";

$excel = new Excel(['path' => dirname(__DIR__) . '/Cache']);

$dateFile = $excel->fileName("free.xlsx")
    ->header(['date']);
$dateFile->insertDate(1, 0, time(), 'yyyy-mm-dd hh:mm:ss');
$dateFile->output();

Expected result

date
2024-09-19 xx:xx:xx

Actual Result

date
45638.655

if i try your example here https://xlswriter-docs.viest.me/en/dan-yuan-ge/cha-ru-date

<?php
$excel = new \Vtiful\Kernel\Excel($config);

$dateFile = $excel->fileName("free.xlsx")
     ->header(['date']);

$dateFile->insertDate(1, 0, time(), 'mmm d yyyy hh:mm AM/PM');

$textFile->output();

The result is the same...

Any fix on your side?

Best

Originally posted by @DAdq26 in #527 (comment)

[DAdq26]

up ?

[DAdq26]

up ?

[DAdq26]

For now we are forced to go back to v1.5.5
All versions up are broken with this issue.

Date are correctly displayed in excel as date with this previous version

Best