Issue 115870 - Images anchored to a cell aren't sorted along with other cells.
Summary: Images anchored to a cell aren't sorted along with other cells.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.2
Hardware: All All
: P3 Normal with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-01 16:46 UTC by guraknugen
Modified: 2013-09-24 06:34 UTC (History)
2 users (show)

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


Attachments
spreadsheet with picture sort bug (19.50 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-09-24 06:34 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description guraknugen 2010-12-01 16:46:56 UTC
Let column A and B (for example) contain some text, such as Item number and 
description, and let column C contain images (one per cell) that illustrates 
the 
text in columns A and B.

Now you want to sort columns A-C for column B in ascending order, but when you 
do that you notice that the images didn't sort; they seems to work like some 
kind of decoration only, or in other words: they are meaningless, at least in 
this case.

If no one will fix this I have a suggestion for a feature that would be an 
acceptable workaround:

When you right click a cell and click [Format cells… → Background], you can 
change the background colour of that cell. If we have a column of different 
colours and we sort a few columns, among those the coloured one, the colours 
will follow the sort, at least if ”Include formats” are checked in the sort 
dialogue.

So my suggestion is to add the feature to use an image as background of a cell. 
Just add a button for searching after images (and maybe other kinds of 
objects). There could be some settings to do, like if the image should fill the 
cell completely in one way or the other or what should happen when the user 
resize the cell.

Or if you find a better way to solve this problem. I know that I'm not the only 
one who have this problem and after what I've heard Excel can do this… (for me, 
Excel is not an option though, since I'm on Linux).

Here's a link to a thread that I found about this problem:
http://www.oooforum.org/forum/viewtopic.phtml?t=82549
Comment 1 Edwin Sharp 2013-09-24 06:33:29 UTC
Confirmed with Rev. 1525015 Win 7.
Comment 2 Edwin Sharp 2013-09-24 06:34:15 UTC
Created attachment 81610 [details]
spreadsheet with picture sort bug