[HttpFoundation] Unable to get Numbers file mime type

[SteveEdson]

Mime Type Issue for Numbers File

Steps to reproduce

1. Open Numbers (an Excel-like app for Mac)
2. Create a file with any content
3. Export as Excel

Code to reproduce

<?php

use Symfony\Component\HttpFoundation\File\MimeType\MimeTypeGuesser;

require "vendor/autoload.php";

$guess = MimeTypeGuesser::getInstance();

$result = $guess->guess('test-numbers.xlsx');

var_dump($result); // Outputs as `string(24) "application/octet-stream"`

Expected result

$ exiftool test-numbers.xlsx 
ExifTool Version Number         : 10.11
File Name                       : test-numbers.xlsx
Directory                       : .
File Size                       : 481 kB
File Modification Date/Time     : 2016:04:05 09:45:17+01:00
File Access Date/Time           : 2016:04:05 09:48:55+01:00
File Inode Change Date/Time     : 2016:04:05 09:45:17+01:00
File Permissions                : rw-r--r--
File Type                       : XLSX
File Type Extension             : xlsx
MIME Type                       : application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Zip Required Version            : 20
Zip Bit Flag                    : 0
Zip Compression                 : Deflated
Zip Modify Date                 : 2016:04:05 09:45:08
Zip CRC                         : 0xe3a39e9d
Zip Compressed Size             : 228
Zip Uncompressed Size           : 587
Zip File Name                   : _rels/.rels

Expected the mime type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Currently affecting laravel/framework#12914

Thanks.

[javiereguiluz]

This is quite strange because the MimeTypeExtensionGuesser class includes xlsx in the MIME-to-extension map. See:

https://github.com/symfony/symfony/blob/master/src/Symfony/Component/HttpFoundation/File/MimeType/MimeTypeExtensionGuesser.php#L393

[xabbuh]

@javiereguiluz I guess that's related to the FileBinaryMimeTypeGuesser that is executed before the MimeTypeExtensionGuesser if available.

[xabbuh]

@SteveEdson Can you check what output file -b --mime produces with your sample file? To me it looks like this:

$ file -b --mime test.xlsx 
application/zip; charset=binary

[SteveEdson]

No problem:

$ file -b --mime test-numbers.xlsx 
application/zip; charset=binary

But also:

$ file -b --mime test-excel.xlsx  
application/zip; charset=binary

[xabbuh]

@SteveEdson I can reproduce your issue and this seems to be an issue when using the FileinfoMimeTypeGuesser. However, I don't see what we can do in Symfony about this as this guesser just acts as a wrapper around PHP's finfo functions.

Status: Reviewed

[javiereguiluz]

I'm afraid I must close this as "won't fix" or better, "can't fix". We're using here the file command and that's the one returning the wrong MIME type: