Created attachment 132262 [details] .xls file to reproduce the problem Steps to reproduce: - open the attached .xls file in Calc - open the same file in XL => the file does not open correctly in Calc
Seems it is not an xls file but an html with xls extension.
It opens correctly in XL.
Hello Frederic, Excel 2010 cautions before the opening: "File format of the file you try to open, 'export.xls', differs from the one specified by the extension file." and Calc opens it as a html text file. Jacques
Calc open the file as raw text on my side. It does not import the html structure of the table.
Thank you Frederic for reporting the bug. I can confirm that the bug (or undesired behavior) is present in Version: 5.3.1.2 (x64) Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; Locale: en-US (en_US); Calc: group I am aware that some websites rely in this MS Excel behavior. They generate html files (an html table or MS Excel 2003 XML format) with the .xls extension and rely in Excel's ability to open the file correctly, that is, as a spreadsheet. I think we should define the desired behavior of LO more clearly: * caution before opening the file (if the file format of the file differs from the specified by the extension of the file: e.g. an html file with .xls or .xlsx, or perhaps .ods extension) * open the Text Import dialogue. To let the user choose some import options (we need more options here, like letting the user choose the decimal separator and the thousands separator of the source. It is crucial for people that live in countries using the coma as the decimal separator.) Or maybe, an html Import dialogue. * importing the content correctly * caution when saving the file (if the original file will get overwritten). Mainly because of the internal file format, not the extension.
Frederic the file you uploaded seems to be some version of a format known as Microsoft Office Excel 2003 XML Format mixed with plain html. Please open the file in MS Excel and save it as a Microsoft Excel 2003 XML file with the .xml extension (not to be confused with Office Open XML with the extension .xlsx). Please attach the xml file, as this makes it easier for us to compare the two files and see how Excel 2003 XML look like in the wild. This could be used to improve the import filters and solve the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 132326 [details] The requested .xml file. I hope this is the correct format.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20171030
The info has been provided in comment 7. Setting to unconfirmed accordingly.
*** This bug has been marked as a duplicate of bug 88701 ***
*** This bug has been marked as a duplicate of bug 83601 ***