Bug 158923 - Dragging, Copy and Pasting, or inserting callouts and Drawing objects get misplaced, and hyperlinks creation not working
Summary: Dragging, Copy and Pasting, or inserting callouts and Drawing objects get mis...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-29 18:01 UTC by Jeffry
Modified: 2024-01-25 05:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Wilderness, M'Chek, Mikona, Canopies, Elysian Maps misplaced drawing object/ hyperlink creation issue (24.61 MB, application/vnd.oasis.opendocument.spreadsheet)
2023-12-29 18:10 UTC, Jeffry
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jeffry 2023-12-29 18:01:07 UTC
Description:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

My large map that I made will misplace some Callouts or drawing objects like arrows when I try to high-lite drag, copy or insert the entire map from the original file to a new separate Libre Office Calc window. If I tried to click on the misplaced drawing objects and used the scroll wheel they would disappear and get placed where they should have originally been in the first place.

I haven't been able to determine what has been causing it. The reason I'm trying to move the files over to a new fresh file is that Libre Calc stopped creating new hyperlinks, and recreating the sheets was fixing that issue. 

This maybe unrelated but I was trying to figure the hyperlink problem on ask.libreoffice.org and the file would get stuck and not upload at 18%. 

Here is a link to that page which has some pictures of what was going on.

https://ask.libreoffice.org/t/navigator-in-calc-has-stopped-making-hyperlinks-from-named-pictures/99813


Steps to Reproduce:
1. Highlight all the files of the map by dragging mouse over all pictures and drawing objects
2.Right Click mouse.
3.Select copy
4.Select a spot on new separateLibre Calc window
5.Use Copy and Paste function. 

or
1. Drag sheet from orignal Calc window
2. to anywhere in the new separate Calc window. 

Then doing the Restart in Safe Mode instructions 

Actual Results:
The pictures usually get placed in the proper locations but some of the callouts, arrows (drawing objects, get misplaced in 100+ cells to the down, and hundreds of cells to the right of where they should be located. 

Restarting in Safe Mode would result in the drawing objects being placed in the upper left corner instead of where they were placed (to the left and down) by doing the drag and drop of the sheet, or high-light copy and paste to new Libre Calc.



Expected Results:
The drawing objects keep their original position. 

Hyperlink creation keeps working


Reproducible: Always


User Profile Reset: Yes

Additional Info:
The files have another issue where it won't make any hyperlinks anymore and it has an error where it won't upload past 18% on Ask.libreoffice.org.

I noticed that after Resetting to safe mode it had changed all of the "anchor to page, drawing objects to "anchor to Cell and those are the ones that got bunched up in the upper left corner. Anything that was already set to "Anchor to Page" didn't seem to get moved from where they should be. Someone told me in the Ask.Libreoffice.orge help site that anchoring to cell prevented drawing objects from getting misplaced but I've found the exact opposite that anchoring to page seems to work much better.
Comment 1 Jeffry 2023-12-29 18:10:14 UTC
Created attachment 191639 [details]
Wilderness, M'Chek, Mikona, Canopies, Elysian Maps misplaced drawing object/ hyperlink creation issue

This file stopped creating hyperlinks, and when I would copy and paste or drag and drop the contents or sheet itself into a new fresh Libre Calc, some callouts would get misplaced down and to the left. Doing a Restart to Safemode would convert them from the previously misplaced as well as some not previously misplaced drawing objects from Anchor to Page, to Anchor to Cell, and bunch them up in the upper left corner. I have had issues with Wilderness, M'Chek, Mikona, Cannopies and Elysia Map sheets.
Comment 2 Jeffry 2023-12-29 23:19:05 UTC
I got a tip and just converted everything to anchor to page and I was able to drag a tab from one separate Calc Window to an entirely separate Calc Window without anything getting misplaced. 

I'm not sure if this fixed the Restart to Safe Mode grouping the Anchored to Cell ones up in the upper left corner.

I was dragging each map over to the new project to see if I could get Calc to make more hyperlinks, but it seems once I get to 3rd or 4th map sheet Calc removes earlier hyperlinks like there is some sort of limit on how many you can have. Is this the case?
Comment 3 Buovjaga 2024-01-24 15:32:37 UTC
(In reply to Jeffry from comment #0)
> Steps to Reproduce:
> 1. Highlight all the files of the map by dragging mouse over all pictures
> and drawing objects
> 2.Right Click mouse.
> 3.Select copy
> 4.Select a spot on new separateLibre Calc window
> 5.Use Copy and Paste function. 

No problem for me with attachment 191639 [details]

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 861e83d1e74a718462ba524695cfa6ccb13bf7db
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 4 Jeffry 2024-01-25 05:15:54 UTC
I found out that if you don't set the anchor on the drawing objects to "anchor to page" things get screwed up when copying and pasting or just dragging a Calc tab over to a different Calc window. I found that Calc seems to default to "Anchor to Cell" and that is what is screwing shit up for me.
Comment 5 Jeffry 2024-01-25 05:18:44 UTC
I also decided to give up on putting so many hyperlinks into one Calc project because it just wouldn't make anymore with how many I was using, despite them being 5 different tab pages.