Bug 160058 - LibreOffice Calc failed to load themes from a sample spreadsheet
Summary: LibreOffice Calc failed to load themes from a sample spreadsheet
Status: RESOLVED DUPLICATE of bug 66377
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-06 09:49 UTC by Volga
Modified: 2024-03-06 18:35 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample XLSX file (109.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-03-06 18:35 UTC, Rafael Lima
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Volga 2024-03-06 09:49:14 UTC
Description:
I discovered a sample spreadsheet from https://handsontable.com/spreadsheet-viewer/, but LibreOffice does not load documentation theme properly from there.

Steps to Reproduce:
1. Download https://handsontable.com/static/resources/ModSV/sample-file.xlsx
2. Open with LibreOffice


Actual Results:
In "Supply chain", "HR" and "Financial" sheets, most cells in white

Expected Results:
All tables should load respective background, see:
https://view.officeapps.live.com/op/view.aspx?src=https://handsontable.com/static/resources/ModSV/sample-file.xlsx


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: CL threaded
Comment 1 Rafael Lima 2024-03-06 18:34:39 UTC
The problem here is not with "themes" per se. But rather, the tables you mentioned (f.i. the HR sheet) is formatted using the "Format as Table" excel feature, which is not supported in LO. This is why no background colors are imported.

*** This bug has been marked as a duplicate of bug 66377 ***
Comment 2 Rafael Lima 2024-03-06 18:35:57 UTC
Created attachment 193003 [details]
Sample XLSX file

BTW I'll attach the XLSX file here for future reference, as well as to make it easier for others to test.