Regression in 4.3.0: `Date::stringToExcel` requires precision

[pcf0]

With the PR #4479, the regex for a valid date/time value was adjusted.
Now it seems to be necessary to specify miliseconds, as the added match group ([.]\d+) is not optional.

Example:

var_dump(\PhpOffice\PhpSpreadsheet\Shared\Date::stringToExcel('26.05.2025 14:28:00'));
var_dump(\PhpOffice\PhpSpreadsheet\Shared\Date::stringToExcel('26.05.2025 14:28:00.00'));

Output 4.2.0:

float(45803.60277777778)
bool(false)

Output 4.3.0:

bool(false)
float(45803.60277777778)

I would expect the following:

float(45803.60277777778)
float(45803.60277777778)

[oleibman]

Thank you for the report. I will try to fix and issue a point release soon.

[oleibman]

4.3.1 is now available, correcting this problem. My apologies for the inconvenience.

[pcf0]

Thanks for your quick response, I can confirm that it works as expected again with version 4.3.1 👍