Bug 42705 - Graphics Anchored to Cell Do Not Move With Data When Sorted, 'Protect Position' Set or Not, 'Link' or Not
Summary: Graphics Anchored to Cell Do Not Move With Data When Sorted, 'Protect Positio...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Libreoffice (show other bugs)
Version: 3.6.6.2 release
Hardware: x86-64 (AMD64) All
: high critical
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-08 06:36 UTC by u2nBz
Modified: 2014-06-19 14:43 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:

Attachments

Description u2nBz 2011-11-08 06:36:42 UTC 
After inserting a graphic into a cell and setting 'Anchor to Cell', behavior is normal with cut/paste.

However, when a range containing the graphic is sorted manually (Data | Sort) and the rest of the row moves, the graphic remains fixed at the same location.

This holds true whether Protect Position is set or not, and whether the graphic is inserted as a link or not.

This behavior was noted with v. 3.4.3, OOO340m1 (Build:302) running under Ubuntu 64-bit (amd), but would seem to be non-platform-specific.

Bug possibly related to this one: https://bugs.freedesktop.org/show_bug.cgi?id=41342
Comment 1 Jeff D. Hanson 2012-10-01 22:23:37 UTC 
LibreOffice 3.5.4.2 
Build ID: 350m1(Build:2)
Ubuntu 12.04 (Precise Pangolin)/Linux Mint 13 (maya)

I'm encountering this also.  The "Position and Size" dialog for a graphic image anchored to a cell references the absolute page position of the anchor, not relative to the cell position.  Changing the X/Y position to 0,0 causes the image to move to the upper-left corner of the page, not the upper-left corner of the cell.  This isn't going to function properly with most types cell manipulation (like sorting).  Calc tries to hide the defect with copy/paste by adjusting the absolute position but if the target cell is a different size then the image is obviously positioned incorrectly.
Comment 2 Jeff D. Hanson 2012-10-01 23:05:52 UTC 
I just updated to:
LibreOffice 3.5.6.2 
Build ID: 350m1(Build:2)

from the Ubuntu PPA.  Same behavior.  Tables in Writer support images properly.
Comment 3 Michel Rudelle 2014-01-09 11:43:49 UTC 
The problem is the same with pictures or objects (tables, formulas) and always in the latest versions
Version: 4.1.4.2 Vista-32b
Version: 4.2.0.1 Vista-32b
Best regards
Comment 4 Olivier Cousinou 2014-01-21 11:07:02 UTC 
Hi,
I am working as a curator in a modern art museum in Marseilles, France, and everybody here is using "Libre Office" in the administration/scientific team.
We often have to deal with spreadsheets and many of them do contain little images.
When spreadsheets contain images, we are unable to sort them, and it is a huge issue for us.
Please could you fix this bug so we can work easily with this stuff ?
Many thanks and best regards,
Olivier Cousinou
Marseille, France
Comment 5 Michel Rudelle 2014-01-21 18:44:14 UTC 
Hi Olivier,
Please, don't change the version, it must be the version where the bug was found. This is very helpfull for developpers.
Regards
Comment 6 elcico2001 2014-06-16 11:16:06 UTC 
Seen on LibO 4.2.3.3 too (under Kubuntu).
In LibO 3.5-3.6 there was no problem.
Thanks
Comment 7 Felix55 2014-06-19 06:38:50 UTC 
The release 3.6.6.2 is the latest in which the position of the images is working properly, all subsequent showed that by varying the height of the cells (for example, increase or decrease the text contained in them), the image moves from original position and the greater is the displacement as is the number of pages that make up the spreadsheet.
In practice, I had to go back to the 3.6.6.2 release and fix (by hand) to the new location of all the images.
Comment 8 Felix55 2014-06-19 11:02:51 UTC 
(In reply to comment #7)
> The release 3.6.6.2 is the latest in which the position of the images is
> working properly, all subsequent showed that by varying the height of the
> cells (for example, increase or decrease the text contained in them), the
> image moves from original position and the greater is the displacement as is
> the number of pages that make up the spreadsheet.
> In practice, I had to go back to the 3.6.6.2 release and fix (by hand) to
> the new location of all the images.
My systems:
Ubuntu 14.04 64bit
Windows Seven 64 e 32 bit
Comment 9 Felix55 2014-06-19 11:03:47 UTC 
The release 3.6.6.2 is the latest in which the position of the images is
working properly, all subsequent showed that by varying the height of the
cells (for example, increase or decrease the text contained in them), the
image moves from original position and the greater is the displacement as is
the number of pages that make up the spreadsheet.
In practice, I had to go back to the 3.6.6.2 release and fix (by hand) to
the new location of all the images.

My systems:
Ubuntu 14.04 64bit
Windows Seven 64 e 32 bit
Comment 10 u2nBz 2014-06-19 14:43:56 UTC 
Got excited that there might be a version with a fix. Added the repo and upgraded, but found bug still present in 3.6.6.2 also.

There may be some confusion. This bug is not for shifting of existing row order (though that may be a separate bug), but for sorting, altering the row order: The data moves but the images don't.

Still looking forward to a fix.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.