Libre Office 6.4 unable to open xlsx file.

asked 2020-05-27 17:28:26 +0100

DeonLubbe gravatar image

Hi All. I have Libre Office 6.4 installed. We get an xlsx file as a report and when we open it with Excel and save it we are able to open it with Libre Office Calc. However, when we try to open it directly with Calc it says that the file is corrupted and then tries to run a repair and then fails. Any Ideas?

edit retag flag offensive close merge delete


We get an xlsx file as a report

That sounds like it is an automatically generated .xlsx file from some software not being Excel. If so, I don't see any chance without a copy of your file and the provider of the file willing to fix issues, which may be found (or to file a bug report, if LibreOffice .xlsx import is incompatible). I don't see any other option (from the distance).

Opaque gravatar imageOpaque ( 2020-05-27 17:46:34 +0100 )edit

I’d say (based on multiple real cases), that sounds like a fake XLSX file from some third-party shitware. Very often, such files are so-called HTML output files. Unless you share a sample file, no other guess can be produced.

gabix gravatar imagegabix ( 2020-05-27 17:56:57 +0100 )edit

I have seen a few of those files which Excel will happily open, but other software fails. Usually they are flat xml files. This may correspond to the "html output" that gabix mentioned.

If you get something that looks like program code when you open the file in Notepad, it's probably XML. If you get jumbled, seemingly random characters, it is something else...

keme gravatar imagekeme ( 2020-05-28 09:41:25 +0100 )edit