Bug 153166

Summary:	Ods saved from xls has issue with images in cells
Product:	LibreOffice	Reporter:	MB <myrbourfake>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	miguelangelrv, robert, stephane.guillou
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	.ods file imported from .xls file with 2 images

Description MB 2023-01-23 17:08:41 UTC

Description:
Get and .xls file with images in cells. Save it as .ods and reopen it. Then try to move any of the images in the cells (every image anchored in every cell).
Image instead of moving jumps to the top of the screen and there can only move horizontally, as if the x axis is locked.

Steps to Reproduce:
1. Create an .xls file (not .xlsx) in microsoft office with 1 image in the 3rd row 3rd column, anchored in this cell.
2. Open it in libreoffice. Save it as .ods, and close it.
3. Open it again and try to move the image in the cell.
4. Image jumps to the first row and cannot move to Y axis only to the X axis (left-right). It is like Y axis is locked to the top of spreadsheet.

Actual Results:
Image jumps to the first row and cannot move to Y axis, only to the X axis (left-right). It is like Y axis is locked to the top of spreadsheet.

Expected Results:
The image should be freely moved right left top or bottom with mouse or arrows or ALT + arrows.


Reproducible: Always


User Profile Reset: No

Additional Info:
I have created a sample file. I'll try to upload it in the next step.

Comment 1 MB 2023-01-23 17:10:35 UTC

Created attachment 184853 [details]
.ods file imported from .xls file with 2 images

Comment 2 m_a_riosv 2023-01-24 00:54:31 UTC

Works for me on Win10
Versión: 6.4.7.2 (x64)
Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5
Subprocs. CPU: 4; SO: Windows 10.0 Build 19045; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: CL
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: fc441f3886330c4ae2abeb67c0758b935ba23f47
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo

Please test with a clean profile, Menu/Help/Restart in Safe Mode

Or try updating your version, it is EOL.

Comment 3 Robert Großkopf 2023-01-24 06:41:58 UTC

Couldn't confirm the buggy behavior here. Could move the images wherever I want.
Tested on OpenSUSE 15.3 64bit rpm Linux.
Version: 7.5.0.2 (X86_64) / LibreOffice Community
Build ID: c0dd1bc3f1a385d110b88e26ece634da94921f58
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Might be a special problem of gtk3? 
Please describe the used version.
Try to start also with SAL_USE_VCLPLUGIN=gen

Comment 4 Stéphane Guillou (stragu) 2023-01-24 10:21:57 UTC

I could reproduce with both GTK and GEN VCLs in version 6.4:

Version: 6.4.7.2
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

As well as:

Version: 7.3.7.2 / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

And even OOo:

OpenOffice.org 3.3.0
OOO330m20 (Build:9567)

But it is resolved in currently supported versions:

Version: 7.4.4.2 / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: cd20a17ab703e97191b4e3421527267ef82a704f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Resolving as "works for me" as there won't be further releases for 6.4. Please install a currently supported version like LO 7.4.

Thank you all!

Comment 5 MB 2023-01-25 07:44:47 UTC

Thank you all for giving feedback on this so fast!
I'll try with the 7.x versions

Comment 6 MB 2023-01-25 09:25:16 UTC

I have tried in 7.3.7.2 which is native in ubuntu 22.04 / Linux Mint 21 and the problem still exists.

I guess I have to install a newer version through PPA to resolve it.

Comment 7 Robert Großkopf 2023-01-25 10:31:04 UTC

(In reply to MB from comment #6)
> I have tried in 7.3.7.2 which is native in ubuntu 22.04 / Linux Mint 21 and
> the problem still exists.
> 
> I guess I have to install a newer version through PPA to resolve it.

Have tried it with 7.3.7.2 - fails. 
Then installed through ppa
Version: 7.4.4.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.4.4-0ubuntu0.22.04.1~lo1
Calc: threaded

→ will work. Images could be moved to where you want.