Hello,
I can’t open the following XLS in libreoffice Calc (neither on Linux nor Windows), Google docs does it properly.
Any ideas what’s going on?
Tip1:
- Rename it to “export_DesglosePeajePorDefecto2.html”
- Open it in the Writer as a HTML document export_DesglosePeajePorDefecto2.odt (27.6 KB)
- Copy-Paste the content into a spreadsheet file
CopyPasted.ods (25.4 KB)
Tip2:
If the GSheet can open it, then you can download it in ODF file format after.
2 Likes
It’s a HTML file disguised as .xls and contains a <table> nested in a <table> without reason, apparently not handled by Calc. Edit the file and remove the first <table> after <body> and the last </table> towards the end of the file before the closing </body></html>. After that, Calc can load the file.
3 Likes
With sed the fastest way to fix it. Thanks.