Issue 11827 - Sort does not touch cells with embedded graphics files
Summary: Sort does not touch cells with embedded graphics files
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.2
Hardware: PC Windows ME
: P3 Trivial with 19 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 3031 19336 20977 25485 87265 112535 (view as issue list)
Depends on:
Reported: 2003-02-25 18:07 UTC by slarti
Modified: 2017-05-20 11:13 UTC (History)
8 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Test file with embedded graphics (34.67 KB, application/octet-stream)
2003-02-25 18:59 UTC, slarti
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description slarti 2003-02-25 18:07: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.

Comment 1 slarti 2003-02-25 18:18:14 UTC
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...
Comment 2 slarti 2003-02-25 18:59:20 UTC
Created attachment 4900 [details]
Test file with embedded graphics
Comment 3 slarti 2003-02-25 19:03:09 UTC
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.

Comment 4 frank 2003-08-26 14:04:18 UTC
Hi Niklas,

one for you I think.

Comment 5 frank 2003-09-10 09:13:09 UTC
*** Issue 19336 has been marked as a duplicate of this issue. ***
Comment 6 niklas.nebel 2003-09-11 15:29:24 UTC
This should have target "later".
Comment 7 oc 2003-09-22 11:30:18 UTC
According to the roadmap
( this issue was retargeted to
OOo Later.
Comment 8 frank 2003-10-10 12:01:21 UTC
*** Issue 20977 has been marked as a duplicate of this issue. ***
Comment 9 frank 2004-02-16 11:42:38 UTC
*** Issue 25485 has been marked as a duplicate of this issue. ***
Comment 10 davisnw 2005-05-26 08:18:06 UTC
This bug is still a problem in 1.9.104.
Comment 11 ahmetnurideniz 2008-10-19 19:49:30 UTC
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)

Comment 12 eberlein 2010-01-15 07:47:58 UTC
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.
Comment 13 Regina Henschel 2010-06-22 17:05:11 UTC
*** Issue 3031 has been marked as a duplicate of this issue. ***
Comment 14 Regina Henschel 2010-06-22 17:08:15 UTC
*** Issue 87265 has been marked as a duplicate of this issue. ***
Comment 15 Regina Henschel 2010-06-22 17:09:33 UTC
*** Issue 112535 has been marked as a duplicate of this issue. ***
Comment 16 juhanijaakola 2011-01-24 16:23:57 UTC
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.
Comment 17 ldog16 2011-01-25 14:18:56 UTC
I really wish that this problem would get addressed.
Comment 18 chrlucas 2012-01-05 15:34:21 UTC
Up, very annoying bug, impossible to resize the cells or sort them, the images shrink or don't sort...
Comment 19 BlipBertMon 2012-01-30 21:31:36 UTC
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.
Comment 20 lkgoo 2012-07-16 02:05:40 UTC
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 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.
Comment 21 Marcus 2017-05-20 11:13:32 UTC
Reset assigne to the default "".