Bug 65070

Summary: FILEOPEN: background image not displayed in XLS or XLSX created with MSO
Product: LibreOffice Reporter: squeezechart
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: major CC: barta, ganibl, kelemeng, kenbiondi, kobzeci, libreoffice, serval2412, stephan.schutter, timur, wmarek98, yuki.bot
Priority: medium Keywords: filter:xls, filter:xlsx
Version: Inherited From OOo   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=83718
https://bugs.documentfoundation.org/show_bug.cgi?id=68359
https://bugs.documentfoundation.org/show_bug.cgi?id=136219
Whiteboard: BSA
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 105584, 139321    
Attachments: Sample XLSX from Excel
Sample XLS from Excel

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