Bug 94921 - Picture at wrong position after sheet copy [Comment 17]
Summary: Picture at wrong position after sheet copy [Comment 17]
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
: 154288 (view as bug list)
Depends on:
Blocks: Calc-Images Cut-Copy Sheet
  Show dependency tree / graph
 
Reported: 2015-10-09 20:10 UTC by OfficeUser
Modified: 2024-08-22 00:06 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Attachments
issue.ods (175.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-10-09 20:11 UTC, OfficeUser 		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 OfficeUser 2015-10-09 20:10:56 UTC 
- Open the attached spreadsheet

- Right-click "Sheet2" and copy it into a new document


Note that the picture is missing in the copy.
Comment 1 OfficeUser 2015-10-09 20:11:24 UTC 
Created attachment 119467 [details]
issue.ods
Comment 2 OfficeUser 2015-10-09 20:16:11 UTC 
(Bug 94922 describes another problem with the same document.)
Comment 3 m_a_riosv 2015-10-09 21:59:03 UTC 
Hi @OfficeUser, thanks for reporting.

Works for me with your sample file.
Win10x64
Version: 5.0.3.1 (x64) Build ID: fd8cfc22f7f58033351fcb8a83b92acbadb0749e

Right-Click - Move/Copy sheet - Copy - To document - New document.
Comment 4 Julien Nabet 2015-10-10 06:24:17 UTC 
On pc Debian x86-64 with LO Debian package 5.0.2.2, I don't reproduce this.
In fact, I thought first I reproduced this but in fact the image in the copied sheet is more at right (columns J, K, L and M) than in original sheet (column G).
Comment 5 raal 2015-10-10 06:34:33 UTC 
(In reply to Julien Nabet from comment #4)
> On pc Debian x86-64 with LO Debian package 5.0.2.2, I don't reproduce this.
> In fact, I thought first I reproduced this but in fact the image in the
> copied sheet is more at right (columns J, K, L and M) than in original sheet
> (column G).

I can confirm with Version: 5.1.0.0.alpha1+
Build ID: 8273350ff48f198efc9dc9c5de5519b8cbdc0cb3
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-10-07_05:54:26

works OK in LibreOffice 3.5.0, Build ID: d6cde02 -> regression

@Reporter -  check again if picture is really lost. If picture is only in another position, change status to NEW and change bug's title. If picture is really lost, set again to Unconfirmed. Thanks
Comment 6 Jean-Baptiste Faure 2015-10-10 15:19:27 UTC 
Idem for me as Julien.
It works as expected if the picture is anchored to the page instead of anchored to the cell.

Best regards. JBF
Comment 7 OfficeUser 2015-10-10 15:46:08 UTC 
@raal:

Thanks for investigating in this. I can confirm that the picture is moved more right (not missing).

=> Status = new
=> Summary changed
Comment 8 raal 2015-10-30 06:19:39 UTC 
bibisect-win32-5.0, oldest version contains bug too.
git checkout oldest: Version: 4.5.0.0.alpha0+
Build ID: 57d6b92b69a31260dea0d84fcd1fc5866ada7adb
Comment 9 raal 2015-11-30 17:42:07 UTC 
bibisect-43max, oldest version contains bug too.
git checkout oldest: Version:Version: 4.2.0.0.alpha1+
Comment 10 steve 2016-08-17 07:43:33 UTC 
Persisting

Version: 5.3.0.0.alpha0+
Build ID: 989e8bc0d792f0dc5778746fac45de129a22d7ac
CPU Threads: 4; OS Version: Mac OS X 10.11.6; UI Render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2016-08-16_01:29:50
Locale: de-DE (de.UTF-8); Calc: group
Comment 11 Xisco Faulí 2016-09-12 12:45:50 UTC 
Adding keyword 'bibisectRequest'.
Comment 12 Xisco Faulí 2016-10-05 21:34:16 UTC 
Regression introduced by

author	Noel Power <noel.power@suse.com>	2013-01-23 15:25:41 (GMT)
committer	Noel Power <noel.power@suse.com>	2013-01-23 15:54:37 (GMT)
commit bdb66834887ec58cd9c602841c185a6629b13d6b (patch)
tree c881604cacae0e917299f2b141588de20b4a248d
parent e2ed38cbfdc75a49155444643d7123dead00170f (diff)

don't use ScDrawLayer::GetObjDataTab to get Anchor fix for fdo#59325

Seems ScDrawLayer::GetObjDataTab was used mistakenly thinking that only an anchor
for that tab would be returned ( but actually whatever anchor is returned gets the tab set )

Adding Cc: to Noel Power
Comment 13 QA Administrators 2018-07-10 02:37:10 UTC Comment hidden (obsolete)
Comment 14 OfficeUser 2018-07-10 13:36:27 UTC 
Still reproducible with:

Version: 6.0.3.2
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 8; OS: Linux 4.4; UI render: default; VCL: gtk2; 
Locale: de-DE (de_DE.UTF-8); Calc: group
Comment 15 Xavier Van Wijmeersch 2018-07-10 17:45:21 UTC 
Cannot reproduce with

Version: 6.2.0.0.alpha0+
Build ID: 35bc6242f8ec22779144b4b1f3e876da239ddd85
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Comment 16 OfficeUser 2018-07-12 14:05:27 UTC 
Still reproducible with:

Version: 6.2.0.0.alpha0+
Build ID: 8e9d43546c8e46ea635472ddf07f5c183dc13360
CPU threads: 8; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-07-12_01:06:03
Locale: de-DE (de_DE.UTF-8); Calc: group threaded
Comment 17 OfficeUser 2018-07-12 14:08:40 UTC 
@Xavier here are the steps:

- Open the attached spreadsheet

- Right-click "Sheet2"

- Click "Move or Copy Sheet..."

- Set Location to "- news document -"

- Click OK


Note that the picture is missing in the news sheet copy.
Comment 18 QA Administrators 2019-07-13 02:47:53 UTC Comment hidden (obsolete)
Comment 19 michel.lopez 2020-11-07 19:20:46 UTC 
Bug not seen in Version : 6.4.6.2
Build ID : 1:6.4.6~rc2-0ubuntu0.18.04.1
Threads CPU : 4; OS : Linux 5.4; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

However, another misbehaviour is observed : the position of the image is moved in the copied sheet.

Steps to reproduce :
- open a blank sheet.
- insert an image in the Sheet1 anchored to cell K8
- add a new sheet Sheet2
- insert another image in Sheet2 anchored to cell C9
- right click on Sheet2 tab and and ask for Move/Copy the sheet, then select Copy in new document
- in the new spreadsheet, the image is anchored to C9 but with an offset that position the image left top angle in cell E17.

Should I open a new bug report ?
Comment 20 michel.lopez 2020-11-07 19:27:23 UTC 
Note that the same behaviour is not observed if I copy Sheet1 (that contains another image) in a new document : the image of Sheet1 looks "normal" in the new document.
Comment 21 QA Administrators 2022-11-08 03:48:33 UTC Comment hidden (obsolete)
Comment 22 Steve271 2024-08-22 00:04:27 UTC 
*** Bug 154288 has been marked as a duplicate of this bug. ***