cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Mime type xlsm excel macro is not right convert

0 Likes
2,544

My setting in local.properties for the mime type excel and excel' macro:

 media.customextension.application.vnd.ms-excel=xls
 mediatype.by.fileextension.xls=application/vnd.ms-excel
 media.customextension.application.vnd.ms-excel=xlt
 mediatype.by.fileextension.xlt=application/vnd.ms-excel
 media.customextension.application.vnd.ms-excel=xla
 mediatype.by.fileextension.xla=application/vnd.ms-excel
 
 media.customextension.application.vnd.openxmlformats-officedocument.spreadsheetml.sheet=xlsx
 mediatype.by.fileextension.xlsx=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
 media.customextension.application.vnd.openxmlformats-officedocument.spreadsheetml.template=xltx
 mediatype.by.fileextension.xltx=application/vnd.openxmlformats-officedocument.spreadsheetml.template
 media.customextension.application.vnd.ms-excel.sheet.macroEnabled.12=xlsm
 mediatype.by.fileextension.xlsm=application/vnd.ms-excel.sheet.macroEnabled.12
 media.customextension.application.vnd.ms-excel.template.macroEnabled.12=xltm
 mediatype.by.fileextension.xltm=application/vnd.ms-excel.template.macroEnabled.12
 media.customextension.application.vnd.ms-excel.addin.macroEnabled.12=xlam
 mediatype.by.fileextension.xlam=application/vnd.ms-excel.addin.macroEnabled.12
 media.customextension.application.vnd.ms-excel.sheet.binary.macroEnabled.12=xlsb
 mediatype.by.fileextension.xlsb=application/vnd.ms-excel.sheet.binary.macroEnabled.12

In the productcockpit, when I add an excel-document (file extension is xlsx) as a media for a product, it works well. But when I add an excel's macro (file extension is xlsm), the file is converted with an extension "bin", which I can't directly open it any more! After saving it and renaming it to the original file extension I can open it! What is wrong hier? Thanks!

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Likes

Hi, the bug is fixed on our project. The problem is on the case-sensitiv word "macroEnabled". You need to have "macroenabled" on Window. This issue occurs just on Windows, the above configurations with "macroEnabled" work well on Linux!