Bug 101967 - Calc do not import HTML under .xls
Summary: Calc do not import HTML under .xls
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.1.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-09-07 15:10 UTC by CTAC
Modified: 2016-12-01 21:20 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
html file imported incorrectly (1.33 KB, text/html)
2016-09-07 15:10 UTC, CTAC 		Details
html file imported incorrectly as XLS (1.33 KB, text/html)
2016-09-07 15:10 UTC, CTAC 		Details
html file imported correctly as XLS (1.92 KB, text/html)
2016-09-07 15:11 UTC, CTAC 		Details
html file imported correctly in XLS form (1.92 KB, text/html)
2016-09-07 15:11 UTC, CTAC 		Details
Example files (3.76 KB, application/zip)
2016-12-01 21:11 UTC, Telesto 		Details
Screenshot Imported MTX2 HTM (32.31 KB, image/png)
2016-12-01 21:19 UTC, Telesto 		Details
Show Obsolete (4) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description CTAC 2016-09-07 15:10:07 UTC 
Created attachment 127198 [details]
html file imported incorrectly

Libreoffice Calc imports html with saved with .XLS extension with strange behavior:

1. MTXC1.htm - just for demonstration
2. MTXC1.xls - works fine
3. MTXC2.html - little table
4. MTXC2.xls - all data goes somewhere
Comment 1 CTAC 2016-09-07 15:10:38 UTC 
Created attachment 127199 [details]
html file imported incorrectly as XLS
Comment 2 CTAC 2016-09-07 15:11:07 UTC 
Created attachment 127200 [details]
html file imported correctly as XLS
Comment 3 CTAC 2016-09-07 15:11:48 UTC 
Created attachment 127201 [details]
html file imported correctly in XLS form
Comment 4 Alex Thurgood 2016-09-21 14:15:51 UTC 
@CTAC : please explain precisely what it is you are trying to do. I don't understand whether the problem is with importing an XLS file that contains HTML or whether it is with importing HTML into Calc, or whether it is with saving imported HTML in Calc to XLS.
Comment 5 Telesto 2016-12-01 21:11:57 UTC 
Created attachment 129200 [details]
Example files
Comment 6 Telesto 2016-12-01 21:18:27 UTC 
If understand it correctly CTAC is changing the file extension of htm files to xls, and importing them into Calc.

However, it's working fine with:
Version: 5.4.0.0.alpha0+
Build ID: 4130c8def811d1dcc87eacaa8ae48ba02738a790
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-11-29_01:03:18
Locale: nl-NL (nl_NL); Calc: CL
Comment 7 Telesto 2016-12-01 21:19:15 UTC 
Created attachment 129201 [details]
Screenshot Imported MTX2 HTM