asked on May 5, 2023
Hi,
We're having a problem with LibreOffice. It can't open any xlsx files that are exported by Flexmonster.
I've attached an example file and screenshots from Excel and LibreOffice.
Steps to reproduce:
This usually works, but we are encountering issues. Can you suggest any workarounds until the next version is released?
Thanks in advance.
⋅ May 8, 2023
Hello Igor,
Thank you for reaching out to us and providing the details.
We suppose that LibreOffice does not open the XLXS files compressed using the "deflate-raw". Since version 2.9.44 of Flexmonster Excel files are now compressed if the client's browser supports the "deflate-raw" compression.
Our team will research possible solutions for this issue and provide you with results ETA May 29.
As a temporary workaround, you can use browsers that don't support compression to export the Flexmonster reports to Excel.
You are welcome to contact us in case other questions arise.
Kind regards,
Nadia
⋅ May 10, 2023
Hi Nadia,
Any workaround until there?
Thanks
⋅ May 11, 2023
Hi Igor,
Thank you for the response.
A temporary workaround is to use browsers that don't support compression to export the reports to Excel format. This should allow you to open the files in LibreOffice until our team finds a permanent solution.
If you have any further questions, please do not hesitate to contact us.
Kind regards,
Nadia
⋅ May 11, 2023
Hi Nadia,
I'm writing to you again because I noticed that all browsers are compatible with to `deflate-row` 🙁
https://caniuse.com/mdn-api_compressionstream_compressionstream_deflate-raw
For security reasons, we can't rollback the current browser version.
I look forward to hearing from you soon with a prompt resolution.
I really appreciate your help, thanks again.
Igor
⋅ May 12, 2023
Hi Igor,
Thank you for the clarifications.
We understand your concerns. There is one more temporary workaround:
You can add the following code to your project before initializing the Flexmonster component:
window["CompressionStream"] = undefined;
By setting the value of CompressionStream to undefined, you can disable the deflate-row feature in your application. Feel free to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/gk4y8sjp/
You are welcome to contact us in case other questions arise.
Kind regards,
Nadia
⋅ May 12, 2023
Awesome!
This works like a charm.
Thank you for your help and prompt attention in this matter.
Best,
Igor
⋅ May 30, 2023
Hello, Igor,
We are happy to let you know that the issue with opening exported Excel files in LibreOffice was fixed.
This is included in the 2.9.52 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-52/
You are welcome to update the component. Check out our updating tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the fix works fine for you.
Best regards,
Maksym
