Bug 150523 - Microsoft excel XLSX and XLS files open with columns and rows black in libreoffice
Summary: Microsoft excel XLSX and XLS files open with columns and rows black in libreo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2022-08-20 17:53 UTC by Andre
Modified: 2024-05-10 12:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
XLSX file (8.12 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-08-20 17:54 UTC, Andre
Details
LibreOffice 7.5 master vs MSO Excel (92.15 KB, image/png)
2022-08-22 09:36 UTC, Xisco Faulí
Details
Microsoft Office Online vs LibreOffice 24.2.3.2 (140.47 KB, image/jpeg)
2024-05-10 12:08 UTC, Andre
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Andre 2022-08-20 17:53:33 UTC
Description:
A microsoft excel XLSX and XLS files open with columns and rows black in libreoffice .

Steps to Reproduce:
1.Open file in libreoffice 7.4.0.3


Actual Results:
Document isn't showing correctly.

Expected Results:
Document should show correctly.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.4.0.3 / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 16; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: pt-PT (pt_PT.UTF-8); UI: pt-PT
Flatpak
Calc: threaded
Comment 1 Andre 2022-08-20 17:54:19 UTC
Created attachment 181915 [details]
XLSX file
Comment 2 Julien Nabet 2022-08-20 18:59:37 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

I noticed this on console:
warn:xmloff:31163:31163:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:xmloff:31163:31163:sax/source/fastparser/fastparser.cxx:1248: unknown attribute defaultSlicerStyle=SlicerStyleLight1

I suppose Excel slicer formatting hasn't been implemented yet in Calc.
Comment 3 Xisco Faulí 2022-08-22 09:36:54 UTC
Created attachment 181946 [details]
LibreOffice 7.5 master vs MSO Excel
Comment 4 Xisco Faulí 2022-08-22 09:37:34 UTC
LibreOffice and Excel display the document in the same way.
Could you please explain how the document was generated and attach a screenshot on how the document should look ?
Comment 5 Andre 2022-11-07 18:05:09 UTC
I don't know where the file was originally generated but I've edited it using Onlyoffice to remove some personal data from it and that's the last time the file was saved.

Both Onlyoffice and Google docs show the file without the black on columns and rows, I've not tested Microsoft Office.
Comment 6 Buovjaga 2023-02-27 14:00:41 UTC
office.com does not show it with a black background, though.

Already seen in LibreOffice 3.5.
Comment 7 Andre 2024-05-10 12:08:35 UTC
Created attachment 194070 [details]
Microsoft Office Online vs LibreOffice 24.2.3.2

Microsoft office online, Google sheets and Onlyoffice all render the document without black bars.