[Skip to main content](#vessel-content)

#   Mass actions Excel file format error

##

- **[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")**
- [![tbroderick's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36185-tbroderick "View tbroderick's Profile") Topic Author
- [ Offline](/forum/user/36185-tbroderick)

Less More

- Posts: 112
- Thank you received: 3
-
-

11 years 2 months ago [\#211810](#211810) by [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")  *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#211810 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")* was created by *[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")*

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
-- PHP version -- : 5.5.11
-- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)

The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:

1. [ www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0](https://www.dropbox.com/s/mg0yshn4etestmt/Screenshot%202015-08-17%2008.51.59.jpg?dl=0)

2. [ www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0](https://www.dropbox.com/s/50es65czttxm7ol/Screenshot%202015-08-17%2008.52.37.jpg?dl=0)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 2 months ago [\#211815](#211815) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#211815 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")*

Hi,

Could it be possible to get that XLS file and a screenshot of your mass action so that we could get a better picture of the problem ?

The following user(s) said Thank You: [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")**
- [![tbroderick's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36185-tbroderick "View tbroderick's Profile") Topic Author
- [ Offline](/forum/user/36185-tbroderick)

Less More

- Posts: 112
- Thank you received: 3
-
-

11 years 2 months ago [\#211951](#211951) by [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")  Replied by *[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")* on topic *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#211951 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")*

Attached are the XLS file and the screenshot of the Mass action setup page. There has been some work performed by Xavier on a different Mass action setup. I am not sure if that influences this action.

- [ ![Screenshot&#95;-&#95;Mass&#95;Action.png](/forum/attachment/26061) ](/forum/attachment/26061 "...ass&#95;Action.png") [ ](/forum/attachment/26061?download=1 "...ass&#95;Action.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

11 years 2 months ago [\#211965](#211965) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#211965 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")*

Hi,

We were able to reproduce the issue on our end, and we found that our version of the xls file generated is under the format BIFF5. This format is no more supported in the recent versions of Excel, so we will see to update that version to BIFF8 in order to be compatible with the recent versions.

What can be done, is to try to open the current xls file with another reader like libreoffice, or openoffice.

We will see too to add a support for the latest xlsx format, which is using xml and no more BIFF format.

The following user(s) said Thank You: [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")**
- [![tbroderick's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36185-tbroderick "View tbroderick's Profile") Topic Author
- [ Offline](/forum/user/36185-tbroderick)

Less More

- Posts: 112
- Thank you received: 3
-
-

11 years 2 months ago -  11 years 2 months ago [\#212004](#212004) by [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")  Replied by *[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")* on topic *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#212004 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")*

Typical Microsoft.

Is there a timeline on the update? If it was just me, I would use OO. But this involves a client. I would hate to ask them to install an Office alternative just to be able to open these files. They will want to use Office/Excel.

Last edit: 11 years 2 months ago by [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile"). Reason: Error in grammar

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

11 years 2 months ago [\#212013](#212013) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#212013 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")*

Hi,

We can't give a date for the moment, but isn't the "csv" format a good alternative ?
This can too be opened in Office/Excel.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")**
- [![tbroderick's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36185-tbroderick "View tbroderick's Profile") Topic Author
- [ Offline](/forum/user/36185-tbroderick)

Less More

- Posts: 112
- Thank you received: 3
-
-

11 years 2 months ago [\#212063](#212063) by [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")  Replied by *[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")* on topic *[Mass actions Excel file format error](/forum/3-bug-report/878818-mass-actions-excel-file-format-error#212063 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.5.11 -- Browser(s) name and version -- : Safari 8.0.8 (10600.8.9)  The XLS file that is output in the Mass actions section appears to be corrupt. The CSV files are fine. But, I get an error when I try to open the XLS files. The error message says the file is corrupt. There are two error messages:  1.   www.dropbox.com/s/mg0yshn4etestmt/Screen...%2008.51.59.jpg?dl=0  2.   www.dropbox.com/s/50es65czttxm7ol/Screen...%2008.52.37.jpg?dl=0")*

Yes, the CSV file works perfectly. It will not do what I wanted with the XLS file. But, I have figured out a workaround. So, I am OK for the moment.

Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Nzg4MTgtbWFzcy1hY3Rpb25zLWV4Y2VsLWZpbGUtZm9ybWF0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.067 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
