LO cannot properly open xml spreadsheet .xls downloaded from power company

asked 2018-01-23 23:27:07 +0100

dwb gravatar image

I downloaded my electric usage from the power company as a spreadsheet. It came as a .xls file which opens correctly using MS office 2016 but when I open it with LO 5.3 it is treated as text and I see a bunch of xml. How do I tell LO Calc to import it as an xml based spreadsheet?

Why on God's green earth do I need 3 points to upload the file to help get an answer to my problem? How do I get more points? here is some of the contents of the file after the import text screen of calc:


<workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" <br=""> xmlns:o='urn:schemas-microsoft-com:office:office'
xmlns:x='urn:schemas-microsoft-com:office:excel'
xmlns:ss='urn:schemas-microsoft-com:office:spreadsheet'
xmlns:html='http://www.w3.org/TR/REC-html40'>
<styles>

edit retag flag offensive close merge delete

Comments

Do not try to open the document by double-click. First start LibreOffice and open the document from File > Open. Select the document. Then on the right side of the dialog choose the correct filter from the drop-down list. "Web Page Query (Calc)" or "Microsoft Excel 2003 XML" might work. To test it, I would need the document.

Regina gravatar imageRegina ( 2018-01-24 02:44:00 +0100 )edit

Try changing the file name extension to xlsx and open it.

gabix gravatar imagegabix ( 2018-01-24 05:49:10 +0100 )edit

Karma points are needed to upload files to protect against spam. You can always place your file on your own or some external file hosting service and give the link here.

erAck gravatar imageerAck ( 2018-01-24 18:55:17 +0100 )edit

the document downloaded with a .xls extension; I had to change the extension to let LO find it with the other filters. changing to .xml, html or .xlsx did not help; it loaded as all text or in one case gave an error.

I see I still only have 1 karma point....not sure how to accumulate more. I uploaded the file in question - see:

http://www.filehosting.org/file/detai...

dwb gravatar imagedwb ( 2018-01-26 22:30:00 +0100 )edit

filehosting has inacceptable privacy conditions for me. But next try: Open the file in an editor and make sure, that there are no empty lines in the beginning, that there are no spaces before the lines with <?and that urn:schemas-microsoft-com:office:spreadsheet has all lower case characters. For details see bugs tdf#115246 and https://bugs.documentfoundation.org/s.... In case that does not help, please send me the file: rb.henschel@t-online.de

Regina gravatar imageRegina ( 2018-01-27 14:58:40 +0100 )edit