Bug 65070 - FILEOPEN: background image not displayed in XLS or XLSX created with MSO
Summary: FILEOPEN: background image not displayed in XLS or XLSX created with MSO
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: filter:xls, filter:xlsx
: 65073 83718 91302 130636 (view as bug list)
Depends on:
Blocks: Calc-Images XLSX-Images
  Show dependency treegraph
 
Reported: 2013-05-28 09:57 UTC by squeezechart
Modified: 2023-12-29 13:23 UTC (History)
11 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample XLSX from Excel (19.30 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-10-07 09:41 UTC, Timur
Details
Sample XLS from Excel (117.00 KB, application/vnd.ms-excel)
2020-10-07 09:41 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description squeezechart 2013-05-28 09:57:49 UTC
Problem description: 

spreadsheet background doesn't get displayed/imported

Steps to reproduce:

Spreadsheet can be downloaded here:

http://www.squeezechart.com/SqueezeChart2013-preview.xlsx

screenshot from Excel:

http://www.squeezechart.com/spreadsheet-in-Excel-15.0.4420.png

screenshot from LibreOffice:

http://www.squeezechart.com/spreadsheet-in-LibreOffice-4.0.0.1.png

Current behavior:

spreadsheet background doesn't get displayed/imported

Expected behavior:

that background image of every tab is displayed              
Operating System: Windows 8
Version: 4.0.3.3 release
Comment 1 ign_christian 2013-05-28 15:05:26 UTC
*** Bug 65073 has been marked as a duplicate of this bug. ***
Comment 2 Ken Biondi 2013-06-17 04:59:14 UTC
I have confirmed this bug and changed the status to NEW.

I tested using:

WIN 8

Version: 4.0.3.3
Comment 3 squeezechart 2014-01-26 21:14:15 UTC
the background graphic won't be displayed with 4.2.0.3 as well,
but when you click on 'format' and then 'page' and click on the tab 'background'
you can preview the background image in that window.
Comment 4 ign_christian 2014-09-09 16:14:14 UTC
After unzipping the file, it's shown that file created with Excel 2013 (15.0300) and the background image, which seems to be repeated/tiled, is PNG format. Please correct me if I'm wrong.

Reproduced since LO 3.3.0.4, also with AOO 4.1.1 under Ubuntu 12.04 x86. Seems inherited from OOO.

*) Unfortunately, my guess, xlsx import bug not qualified for MAB
Comment 5 tommy27 2014-10-06 18:35:37 UTC
bug still reproducibile under Win7x64 using LibO 4.3.2.2 and 4.4.0.0.alpha0+
Build ID: 268b9c10c9ff27c74678ace99762f28d58d33012
TinderBox: Win-x86@42, Branch:master, Time: 2014-10-02_23:35:24
Comment 6 squeezechart 2015-06-10 10:39:38 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2016-09-20 10:02:03 UTC Comment hidden (obsolete)
Comment 8 squeezechart 2016-09-20 12:44:12 UTC Comment hidden (obsolete)
Comment 9 squeezechart 2017-12-18 10:52:16 UTC Comment hidden (obsolete)
Comment 10 eisa01 2018-03-17 12:27:58 UTC
*** Bug 83718 has been marked as a duplicate of this bug. ***
Comment 11 eisa01 2018-03-17 12:28:39 UTC
*** Bug 91302 has been marked as a duplicate of this bug. ***
Comment 12 squeezechart 2019-09-27 06:17:09 UTC
Confirm that this bug is still present in LibreOffice 6.3.2.1 and 6.4.0.0
Comment 13 Julien Nabet 2020-07-07 20:16:06 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

I also noticed this when unzipping the file:
 extracting: xl/media/image2.png      bad CRC 8a2bba4c  (should be 7041beb1)
file #32:  bad zipfile offset (local header sig):  521732
Comment 14 Timur 2020-10-07 09:41:08 UTC
Created attachment 166147 [details]
Sample XLSX from Excel

Any background image (Background button in Page Setup group under Page Layout tab in MSO Excel) doesn't open, regardless if PNG or JPEG.
Comment 15 Timur 2020-10-07 09:41:35 UTC
Created attachment 166148 [details]
Sample XLS from Excel

Also for XLS.
Comment 16 squeezechart 2020-11-23 09:15:14 UTC
still present in LibreOffice 7.1.0 alpha 1
Comment 17 NISZ LibreOffice Team 2021-04-26 07:52:01 UTC
*** Bug 130636 has been marked as a duplicate of this bug. ***
Comment 18 QA Administrators 2023-04-27 03:24:22 UTC Comment hidden (obsolete)
Comment 19 eisa01 2023-12-29 13:23:24 UTC
Still present

Version: 24.2.0.0.beta1 (AARCH64) / LibreOffice Community
Build ID: 5f390384195b7264c6e52add9e90a39790285249
CPU threads: 10; OS: macOS 14.2; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded