Bug 49639

Summary:	FILEOPEN html content .xls files shows text.csv with html tags instead of Spreadsheet contents
Product:	LibreOffice	Reporter:	David Clayton <dcclayton>
Component:	Calc	Assignee:	Eike Rathke <erack>
Status:	RESOLVED FIXED
Severity:	normal	CC:	kohei, LibreOffice
Priority:	medium	Keywords:	regression
Version:	3.5.3 release
Hardware:	All
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=88701
Whiteboard:	target:3.6.0 target:3.5.4
Crash report or crash signature:		Regression By:
Attachments:	Example file 1 Example file 2

Description David Clayton 2012-05-08 07:17:40 UTC

Created attachment 61231 [details]
Example file 1

When you open the sample files in calc you get an import dialogue, and the data is brought in with all the html formatting. If you delete the .xls file exension
and open using sweb.exe, the table and data seem as expected.

Tested on Win 7 32bit and Win Vista, it has only just started happening on
3.5.3 after we upgraded these machines last week. 

I can confirm that opening these documents worked on 3.5.2

Please see reference to bug 37972.

Comment 1 David Clayton 2012-05-08 07:18:13 UTC

Created attachment 61232 [details]
Example file 2

Comment 2 Rainer Bielefeld Retired 2012-05-08 07:47:19 UTC

I was able to reproduce the problem in Bug 37972#c17

Was still ok with parallel Server installation of "LOdev 3.5.1rc0+   [Build ID: e80d2ea-73cb0b8-f269e46] Win-x86@6-fast  pull time 2012-02-24 11:11:48  – WIN7 Home Premium (64bit) and
ok in 3.5.0, so regression.

@Kohei:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf.

Comment 3 Eike Rathke 2012-05-10 08:05:08 UTC


*** This bug has been marked as a duplicate of bug 46233 ***

Comment 4 Eike Rathke 2012-05-10 08:46:55 UTC

Damn, this is yet something different. Regression introduced with the fix for bug 40021.

Comment 5 Not Assigned 2012-05-10 10:10:37 UTC

Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=aeb1451dff06ad00b1719f9bc45a2c8bdfa904f8

resolved fdo#49639 import .xls with HTML as such, not CSV

Comment 6 Not Assigned 2012-05-11 09:01:37 UTC

Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=c4f1c3053a4d892b0bbc8842044133b64eee00ae&g=libreoffice-3-5

resolved fdo#49639 import .xls with HTML as such, not CSV


It will be available in LibreOffice 3.5.4.