Date::excelToDateTimeObject fatal errorstale

[LRemy-Gac]

Hello,

I'm in the same case as presented in this issue, which have been closed, without a possible fix.
I understand that a potential fix would add some complexity into the code, but by raising an exception that would prevent some fatal errors.

In my case I'm extracting data from xls/xlsx files from which I don't have any control on the data.

Some cells are marked as "Datetime" (\PhpOffice\PhpSpreadsheet\Shared\Date::isDateTime($cell) => return true) but when I use "excelToDateTimeObject" on the cell value after that control it trigger a fatal error because it return a boolean instead of a Datetime object.

it's a marginal case but it is here.

Any fix possible ?

[oleibman]

Can you supply some details? What code is triggering your problem? What's the value in the cell that is causing it? What's the NumberFormat style of the cell?

[LRemy-Gac]

Code which is triggering my problem

if (\PhpOffice\PhpSpreadsheet\Shared\Date::isDateTime($cell)) {
$dateTime = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($cell->getValue());
}

I don't set the numberFormat for the cells, I don't "know" in advance what is in the document.

The part which is triggering the fatal error is when I call "excelToDateTimeObject" function with the value "7000989091802000122" , which I know is not an appropriate value but that's not something I can "manage".

Maybe there is a "tips" to determine according to the value of the cell (length or something) to trigger or not the function excelToDateTimeObject ?