Bug 153166 - Ods saved from xls has issue with images in cells
Summary: Ods saved from xls has issue with images in cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-23 17:08 UTC by MB
Modified: 2023-01-25 10:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
.ods file imported from .xls file with 2 images (1.06 MB, application/vnd.oasis.opendocument.spreadsheet)
2023-01-23 17:10 UTC, MB
Details

Note You need to log in before you can comment on or make changes to this bug.
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.