Bug 125938 - Paste cell with cell-anchored images does not put anchor in target cell.
Summary: Paste cell with cell-anchored images does not put anchor in target cell.
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Regina Henschel
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency treegraph
 
Reported: 2019-06-15 12:59 UTC by Olivier Hallot
Modified: 2023-05-08 05:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with images to copy and paste, shows pasted cells have anchors are misplaced (314.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-15 12:59 UTC, Olivier Hallot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2019-06-15 12:59:05 UTC
Created attachment 152210 [details]
Spreadsheet with images to copy and paste, shows pasted cells have anchors are misplaced

Attached document helps to see the bug.

Steps to reproduce

All images in Planilha1 are cell-anchored (with resizing)

1) copy cells in Planilha1.A1:E1
2) paste cells in Planilha2.b10.f10

Actual results: 
- Images are placed in right position planilha2.b10:f10
- However, pasted images are anchored in Planilha2.A1:E1, select a pasted image to see anchor in 1st row.

So the anchor is not brought to the target cell.
Comment 1 m_a_riosv 2019-06-16 09:24:30 UTC
Hi Olivier,
as I see pasted image is anchored to To Cell (resize with cell)-

Doing auto resize on source cells, it reduce the cells size to the size of their format text, and this is what happens at pasting, cell is auto-resized and the image is adapted in accordance.

The best way that I have used it's to set up a large size font, so when the cells are copied they carry the font size and resized properly.
Comment 2 Olivier Hallot 2019-06-17 06:35:46 UTC
(In reply to m.a.riosv from comment #1)
> Hi Olivier,
> as I see pasted image is anchored to To Cell (resize with cell)-
> 
> Doing auto resize on source cells, it reduce the cells size to the size of
> their format text, and this is what happens at pasting, cell is auto-resized
> and the image is adapted in accordance.
> 
> The best way that I have used it's to set up a large size font, so when the
> cells are copied they carry the font size and resized properly.

Please note I am referring to the place of the anchor. The anchor location is not in the target cell.

My understanding is that if an image is anchored in a cell, when I copy and paste the cell, the anchor should be in the target cell.
Comment 3 Buovjaga 2019-06-17 10:42:27 UTC
Repro

Version: 6.4.0.0.alpha0+ (x64)
Build ID: b61a1ca837223ba9d7da1aa8936f228d89bde60a
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-16_01:14:55
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded
Comment 4 QA Administrators 2021-08-14 04:05:20 UTC Comment hidden (obsolete)
Comment 5 Regina Henschel 2023-04-09 23:32:14 UTC
The anchor is still wrong in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 23bd3bd10e74b0c23c2654d02d7d830e7693adac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL threaded
Comment 6 Regina Henschel 2023-05-05 14:15:14 UTC
I'm working in that area for bug 139083, see https://gerrit.libreoffice.org/c/core/+/150161
The patch contains a larger change in the way objects which are included in a cell range are pasted. It should fix this problem here too.
Comment 7 BogdanB 2023-05-07 18:32:54 UTC
Regina you can mark as Assign, Resolved.
I will verify later.
The anchor is where it should be now.

It's fixed in
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4f93995f2262cde0b16bacc83f4ba3c6161ada7f
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

Is bad in
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 8 BogdanB 2023-05-08 05:18:12 UTC
Verified with
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4f93995f2262cde0b16bacc83f4ba3c6161ada7f
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded