Export field as date not recognized on Windows

[alextoader]

Hi,
I am exporting to an xcel file with the setColumnFormat([ 'A' => 'Y-m-d']) but the column is not recognized in windows.
It shows as a date format in Linux but not on Windows.
Also, the date filters are not working in Windows for this column. I think it is viewed as text date type in Windows.
Do I need to set anything else to the column to make it of type date?

Using the 2.1 version, unfortunately.

Thanks, Alex

[patrickbrouwers]

Columnformatting is handled by PhpExcel in v2.1. Both 2.1 of this package and PhpExcel are nog longer supported.

[alextoader]

I know thanks, wondering if this is a known issue and if it is fixed in newer versions?
So the only solution for this would be an update?

[patrickbrouwers]

I don't know. I've never heard of this issue. It would for sure be better to upgrade, because if it is still a bug it would be fixable in the new version. PHPExcel will never be updated again, PhpSpreadsheet will.