Bug 150996 - [XLSX] Cell colors and number formats are not imported by LibreOffice
Summary: [XLSX] Cell colors and number formats are not imported by LibreOffice
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: target:7.6.0 target:7.4.6 target:7.5.1
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Limitations XLSX-External-Generators
  Show dependency treegraph
Reported: 2022-09-16 14:48 UTC by simonm3
Modified: 2023-05-06 04:09 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

file that fails to show formatting in libreoffice (10.54 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-09-16 14:50 UTC, simonm3
Screenshot showing the problem (267.38 KB, image/png)
2022-09-16 20:39 UTC, Rafael Lima

Note You need to log in before you can comment on or make changes to this bug.
Description simonm3 2022-09-16 14:48:57 UTC
I opened and saved a file using openpyxl without making any changes. The output file looks identical in excel. However in libreoffice the number formatting and fill color is missing for some cells.

Steps to Reproduce:
1.Open test2.xlsx in excel and in libreoffice


Actual Results:
Libreoffice is not showing number formats and color fill for some cells

Expected Results:
Same appearance in excel and libreoffice

Reproducible: Always

User Profile Reset: Yes

Additional Info:
shown the same as excel
Comment 1 simonm3 2022-09-16 14:50:05 UTC
Created attachment 182496 [details]
file that fails to show formatting in libreoffice
Comment 2 Rafael Lima 2022-09-16 20:38:50 UTC
Repro with

Version: / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.22.04.1~lo1
Calc: threaded

Colors in columns "F" to "I" as well as in the first row in columns "J" to "O" were not imported.
Comment 3 Rafael Lima 2022-09-16 20:39:39 UTC
Created attachment 182510 [details]
Screenshot showing the problem

Here's a screenshot showing the differences between LO and MSO.
Comment 4 Czeber László Ádám (NISZ) 2023-05-05 08:39:43 UTC
Bibisected LO-win64-7.6 to first good commit:

commit 909a25d30b09ebd3a023105a9c3cc4d20add094a	[log]
author	Eike Rathke <erack@redhat.com>	Mon Feb 06 22:59:44 2023 +0100
committer	Eike Rathke <erack@redhat.com>	Tue Feb 07 13:18:03 2023 +0000
tree ca3a8052f8372d2e34897cd915d0925ac2ce9bcb
parent fba2d6a1026020164c80d65037ec3aae33a3f774 [diff]

Thanks Eike!
Comment 5 Eike Rathke 2023-05-05 19:48:06 UTC
So that commit fixes this one as well, nice :)
Comment 6 BogdanB 2023-05-06 04:09:34 UTC
The same as Excel

Verified with
Version: (X86_64) / LibreOffice Community
Build ID: 0f2581204a70038ed7ca78089a9bd96d158e02c0
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded