Apache OpenOffice (AOO) Bugzilla – Issue 11827
Sort does not touch cells with embedded graphics files
Last modified: 2017-05-20 11:13:32 UTC
I've got a spreadsheet with embedded graphics files contained in column B. They are anchored to the cell and thus should move along with the row or column. Now if I sort the sheet, using some other column to sort by, the graphics column is not affected and stays as it is. slarti
I would love to add a stripped version of that file (currently ~900kB) but most obviously there's another bug: deleting rows containing these graphics does not delete the graphics (file size doesn't decrease as expected). I'll have to check that...
Created attachment 4900 [details] Test file with embedded graphics
Ok, silly me, deleting of course works if 'objects' in the Delete dialog box is marked as well. To check: sort on any column (C,D,E) and see how the graphics stay put. slarti
Hi Niklas, one for you I think. Frank
*** Issue 19336 has been marked as a duplicate of this issue. ***
This should have target "later".
According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later.
*** Issue 20977 has been marked as a duplicate of this issue. ***
*** Issue 25485 has been marked as a duplicate of this issue. ***
This bug is still a problem in 1.9.104.
This deficient is still a problem in OpenOffice 3.0 I konw this is not bug. Thi is deficient. we need this use function. Now I want to explain this problem again. I got spreadsheed file like this . 333 (img1) 222 (img2) 111 (img3) Sort this table by first column. And have next table: Open office sorh like this 111 (img1) 222 (img2) 333 (img3) But we need ask open office "There are another colums, Do you want to sort it?" if i say yes it may be like this 111 (img3) 222 (img2) 333 (img1) thanks
Niklas, if autofiltering is used, graphics anchored at cell are not hidden. Same issue or should I file a new one? Tested with 320m8 on WinXP.
*** Issue 3031 has been marked as a duplicate of this issue. ***
*** Issue 87265 has been marked as a duplicate of this issue. ***
*** Issue 112535 has been marked as a duplicate of this issue. ***
I have the same problem in OpenOffice Calc 3.3.0 in Linux (Fedora 14). This is a very annoying bug in Calc and very counter-intuitive. In Excel this works.
I really wish that this problem would get addressed.
Up, very annoying bug, impossible to resize the cells or sort them, the images shrink or don't sort...
Please, Free software is one thing, but maintaining features which are abjectly broken is an inviting distraction to waste copious quantities of valuable time. Both attached images and attached hyperlinks fail to follow rows containing cells attachments are anchored to when those rows are sorted. The 'feature' to anchor an attachment to a cell should be elided completely if it shows no signs of functionality.
I am having this problem too. At least this forum is good for confirming that I'm not crazy and it's a legitimate bug. The "anchor to cell" function does not actually anchor the graphic to anything. All graphics are in permanent, un-sortable positions in the file...in other words, it's no longer a spreadsheet. Being unable to sort graphics is so last century! Apparently this forum is useless for having the bug addressed, in nine years! Continually changing the login and login procedures guarantees a low vote, which is a good trick! The response to this bug shows the OOO attitude is "you got what you paid for." Or "freeware = crapware." No news there I guess. Sigh.
Reset assigne to the default "issues@openoffice.apache.org".