[Issue] OpenOffice.org Calc sorting with graphics contents

Discuss the spreadsheet application

[Issue] OpenOffice.org Calc sorting with graphics contents

Postby silvermine92 » Wed Jun 09, 2010 4:45 pm

We are able to put graphics information into a spreadsheet cell, but even if the image is anchored to a cell, it is not sorting with it. For example, instead of putting down an airline name in a spreadsheet, I use the airline logo. However after sorting the spreadsheet, the logos will stay as were but not in their new position. I am comparing the action with Excel, and in the Mircrosoft environment things are working out fine. Is there a way attaching graphics data to a cell such that it will always stay with it?

CSLam
Last edited by Hagar Delest on Wed Jun 23, 2010 2:31 pm, edited 1 time in total.
Reason: tagged the thread as Issue (link to a bug report).
OpenOffice 3.3.0 (Chinese Edition)
Windows Vista
User avatar
silvermine92
 
Posts: 30
Joined: Tue Jun 08, 2010 5:41 am

Re: OpenOffice Calc sorting with graphics contents

Postby Zizi64 » Wed Jun 09, 2010 5:44 pm

In my opinion, the sort option sorts only the contents of the cells. But It not sorts the cells (the 'containers').
An image, anchored to a cell (to a 'container'), not becomes a cell content.
Example1:
The various background colors of cells will be sorted, because the background color is inside of cell.
Example2:
The picture is anchored to the 'A1'. If you sort the range A1:A9; after sorting the name of first cell not will be 'A9' or the name of last cell not will be 'A1'. The names of the cells remain unchanged: the picture remain anchored to the 'A1'
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8771
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: OpenOffice.org Calc sorting with graphics contents

Postby silvermine92 » Thu Jun 10, 2010 3:34 am

Understand the point, but the most important thing is, we need to make Calc work. Calc offers anchoring graphics in two options, either to the page or to the cell, and therefore if it is specified to go with the cell, it should move with it as well. In another perspective, if Calc is going to be compatible with Microsoft Excel (which I think is a priority goal otherwise it will be difficult to persuade people switching to OpenOffice), it must sort with the graphics as well otherwise there will be occasions that Excel worksheet will not work propely in the OpenOffice environment. This perhaps is more critical and worth some thoughts.

CSLam
OpenOffice 3.3.0 (Chinese Edition)
Windows Vista
User avatar
silvermine92
 
Posts: 30
Joined: Tue Jun 08, 2010 5:41 am

Re: OpenOffice.org Calc sorting with graphics contents

Postby silvermine92 » Wed Jun 23, 2010 5:54 am

Issue already reported and tracked under issue 11827.

CSLam
OpenOffice 3.3.0 (Chinese Edition)
Windows Vista
User avatar
silvermine92
 
Posts: 30
Joined: Tue Jun 08, 2010 5:41 am

Re: [Issue] OpenOffice.org Calc sorting with graphics conten

Postby gold16 » Tue Jul 20, 2010 7:02 am

Thanks for the post. I was having the exact same problem and was getting upset that I couldn't figure out why graphics were staying put when sorting associated data. Hope this gets fixed.
OOo 3.1.1 Build 9420
Windows 7
gold16
 
Posts: 1
Joined: Tue Jul 20, 2010 6:57 am

Re: [Issue] OpenOffice.org Calc sorting with graphics conten

Postby acknak » Tue Jul 20, 2010 2:34 pm

A link to the issue: Issue 11827.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 6 guests