Bug 115487 - FILEOPEN XLS LibreOffice draws yellow grid, Excel2016 gray
Summary: FILEOPEN XLS LibreOffice draws yellow grid, Excel2016 gray
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
 
Reported: 2018-02-06 11:28 UTC by Clemens Eisserer
Modified: 2019-03-03 12:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screenshot excel2016 (4.40 KB, image/png)
2018-02-06 11:28 UTC, Clemens Eisserer
Details
screenshot libreoffice6 (5.99 KB, image/png)
2018-02-06 11:29 UTC, Clemens Eisserer
Details
reproducer (26.00 KB, application/vnd.ms-excel)
2018-02-06 11:29 UTC, Clemens Eisserer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Clemens Eisserer 2018-02-06 11:28:09 UTC
Description:
When opening the document attached, Libreoffice draws some part of the excel spreadsheet lines yellow, whereas they are gray when opened with Excel2016.

Worse, when saving the xsl file with LibreOffice, the yellow lines are stored - and appear yellow later when the file is opened in Excel2016.

Steps to Reproduce:
1.open the attached file with Excel2016 and LibreOffice6


Actual Results:  
lines are drawn gray with Excel2016 and yellow with LibreOffice

Expected Results:
constent


Reproducible: Always


User Profile Reset: No



Additional Info:
also reproduceable with LibreOffice 5.4


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0
Comment 1 Clemens Eisserer 2018-02-06 11:28:38 UTC
Created attachment 139628 [details]
screenshot excel2016
Comment 2 Clemens Eisserer 2018-02-06 11:29:03 UTC
Created attachment 139629 [details]
screenshot libreoffice6
Comment 3 Clemens Eisserer 2018-02-06 11:29:24 UTC
Created attachment 139630 [details]
reproducer
Comment 4 Xavier Van Wijmeersch 2018-02-06 14:20:41 UTC
can it be that the spreadsheet was not blank ????
removing the border lines, wish are yellow colored, then the spreadsheet shows everywhere gray grid lines
Comment 5 Clemens Eisserer 2018-02-06 16:17:21 UTC
The spreadsheet was a real-world spreadsheet I received from one of my co-workers.
When I noticed the differences between LO and MSOffice, I stripped it down to a minimal testcase which does not contain real data.

So yes, of course, the file attached is not simply a new, empty spreadsheet saved with Excel2016 - it was a real-world spreadsheet I encountered where LibreOffice's behaviour differs from the expected one.
Comment 6 Buovjaga 2018-03-02 16:54:32 UTC
Confirmed.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: 51291f2352976b2f875197de83486a74795e86a3
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 1st 2018

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 7 QA Administrators 2019-03-03 03:41:08 UTC Comment hidden (obsolete)
Comment 8 Clemens Eisserer 2019-03-03 08:40:23 UTC
sure, the bug still exists (like all the other bugs I've filed over the last 5-10 years).
Comment 9 Buovjaga 2019-03-03 08:51:14 UTC
(In reply to Clemens Eisserer from comment #8)
> sure, the bug still exists (like all the other bugs I've filed over the last
> 5-10 years).

Not very accurate. Your history has 24 closed reports.