Bug 119537 - xls file with entire color-filled row opens+data opens as empty
Summary: xls file with entire color-filled row opens+data opens as empty
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.7.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-27 15:02 UTC by Eyal Einhorn
Modified: 2018-08-28 10:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
the problematic file (187.12 KB, application/vnd.ms-excel)
2018-08-27 15:04 UTC, Eyal Einhorn
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Einhorn 2018-08-27 15:02:49 UTC
Description:
I am using Libreoffice versions 6.0.6.2 and 5.4.7.2, both of them got a problem when opening a specific xls file(that generated from a “template”).
When opening the file an “import options” dialog pop-up and doesn’t matter what I will choose the file will open as empty file.

We discover that the blue filled row + bold(that continue to infinity)in the top of the file makes the problem.

when i copy only the other data everything works good.

Microsoft office open it well.

Steps to Reproduce:
1.create file with Microsoft excel with entire row filled with color and bold(up to infinity)
2.save it as xls and open it in libreoffice calc
3.

Actual Results:
open as empty file

Expected Results:
open the file with the data 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Eyal Einhorn 2018-08-27 15:04:24 UTC
Created attachment 144481 [details]
the problematic file
Comment 2 Xisco Faulí 2018-08-28 10:23:38 UTC
The attached file is not a .XLS but a webpage file. You can open it if you change the extension to .HTML.
Then you can open it correctly with LibreOffice Writer.
Closing as RESOLVED INVALID