Bug 136219 - Pictures in background (Libre Calc) not saved when saving XLSX
Summary: Pictures in background (Libre Calc) not saved when saving XLSX
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0 all versions
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 142710 (view as bug list)
Depends on:
Blocks: XLSX-Limitations
  Show dependency tree / graph
 
Reported: 2020-08-28 09:45 UTC by Patrick
Modified: 2021-06-08 11:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file (211.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-08-29 07:56 UTC, Telesto 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick 2020-08-28 09:45:14 UTC 
Description:
I created several background images in my worksheets.  When I save my spreadsheet and later re-open it, all my images are in the foreground again.

Steps to Reproduce:
1. Create a worksheet with an image in the background
2. Save it
3. Open your file again

Actual Results:
The image that should be in the background is in the foreground again

Expected Results:
The image created in the background should stay in the background


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU-threads: 8; Besturingssysteem: Windows 10.0 Build 18362; UI-render: Skia/Rooster; VCL: win
Locale: nl-BE (nl_BE); GI: nl-NL
Calc: CL
Comment 1 Patrick 2020-08-28 10:09:46 UTC 
This only happens when you save in XLSX format.  When you save in ODS format, the problem does not exist
Comment 2 Telesto 2020-08-29 07:56:17 UTC 
Created attachment 164849 [details]
Example file

1. Open the attached file
2. Save as XLSX
3. File reload -> Image 'send to background' setting is gone
Comment 3 Telesto 2020-08-29 07:59:31 UTC 
Confirming with
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 6640d7f405d2970ba2825a9455926cc803284d01
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL

and in
6.0.5

and in
4.4.7.2

and in
4.0
Comment 4 Paul W. 2020-09-22 13:02:32 UTC 
Confirming with
Version: 7.1.0.0.alpha0+ (x64)

also on: 5.4.7.2
Comment 5 NISZ LibreOffice Team 2020-10-06 12:29:25 UTC 
In Excel I see only buttons for bringing the image to front/back and these are enabled only when there are at least two images inserted.

I doubt there is a "To background" function for images in Excel.
Comment 6 Timur 2020-10-07 09:33:44 UTC 
I also looked in MSO, guess we may mark this as NotOutBug.
Comment 7 Timur 2021-06-08 11:25:19 UTC 
*** Bug 142710 has been marked as a duplicate of this bug. ***