Invalid mime type detected: xlsx

[Rollmodl]

Cannot upload Excel spreadsheets

Steps to reproduce the issue

1. Added xlsx and XLSX to Legal Extensions.
2. Checked MIME type using http://mime.ritey.com/.
3. Added application/vnd.openxmlformats-officedocument.spreadsheetml.sheet to Legal MIME Types

Expected result

Actual result

Receiving Error: Invalid mime type detected.

System information (as much as possible)

Additional comments

Also tried disabling "Check MIME Types"

[tonypartridge]

Did you add it to the allowed media manager list? Within the media manager options?

[tonypartridge]

Skip that just reread your post 🙈. Will also run a test!

[Quy]

In \libraries\src\Helper\MediaHelper.php, above line 254 // Get the mime type this is not an image file, add the following:

var_dump($this->getMimeType($file['tmp_name']));
exit;

Please advise the value of the output.

[Rollmodl]

After upload I'm getting the page/message: bool(false)

[joomla-cms-bot]

Set to "closed" on behalf of @Quy by The JTracker Application at issues.joomla.org/joomla-cms/20108

[Quy]

Please read issue #16238. It has to do with PDF but the information should still be applicable in your case.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/20108.}

[suniljaswaniit]

You can add (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet) this in Legal MIME types in the list and add xlsx in the Legal Extensions(File Types).
You can find this setting in Joomla administrator > Global > Media Settings.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/20108.}

[mimfa]

add "xlsx" and "XLSX" to your Legal File Types then add "application/vnd.openxmlformats-officedocument.presentationml.presentation" to your Legal MIME Types;

[acvmultimedia]

Thanks!! For the solution :)

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/20108.}