To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=115870
                 Issue #|115870
                 Summary|Images anchored to a cell aren't sorted along with oth
                        |er cells.
               Component|Spreadsheet
                 Version|OOo 3.2
                Platform|All
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|ui
             Assigned to|spreadsheet
             Reported by|guraknugen





------- Additional comments from guraknu...@openoffice.org Wed Dec  1 16:46:56 
+0000 2010 -------
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

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to