Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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>