?
avatar Rollmodl
Rollmodl
7 Apr 2018

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"

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
5.00

avatar Rollmodl Rollmodl - open - 7 Apr 2018
avatar joomla-cms-bot joomla-cms-bot - labeled - 7 Apr 2018
avatar tonypartridge
tonypartridge - comment - 7 Apr 2018

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

avatar tonypartridge
tonypartridge - comment - 7 Apr 2018

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

avatar franz-wohlkoenig franz-wohlkoenig - change - 7 Apr 2018
Status New Information Required
avatar Quy
Quy - comment - 7 Apr 2018

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.

avatar Rollmodl
Rollmodl - comment - 7 Apr 2018

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

avatar Quy Quy - change - 7 Apr 2018
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2018-04-07 21:43:50
Closed_By Quy
avatar joomla-cms-bot joomla-cms-bot - change - 7 Apr 2018
Closed_By Quy joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 7 Apr 2018
avatar joomla-cms-bot
joomla-cms-bot - comment - 7 Apr 2018

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

avatar Quy
Quy - comment - 7 Apr 2018

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.

avatar suniljaswaniit
suniljaswaniit - comment - 9 Oct 2018

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.

avatar mimfa
mimfa - comment - 15 Apr 2019

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

avatar acvmultimedia
acvmultimedia - comment - 25 Aug 2020

Thanks!! For the solution :)


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

Add a Comment

Login with GitHub to post a comment