On 19 Mar 2008 at 12:17, Stephan G wrote: > Using OpenOffice 2.3.1 > > In calc, I have created a spreadsheet in which I have many graphical > elements (which I drew in calc) which exist inside cells and are > anchored to those cells. > > However, if I delete a row which has a some graphics in some of the > cells, some of the graphics spill over into the new cell in weird and > unexpected ways. > > In addition, if I try to sort my spreadsheet, using sort keys that NOT > cells with graphics, the graphics seem to rearrange in unpredictable > ways, and do not stay strictly with the row that I sorted them with.
I don't have experience, so can't give a definitive answer. However, absent any other response, I'll just say that I tried something similar - dummy spreadsheet with two columns, some numbers and a couple of cell-anchored pictures, & offer the following observations: * Pictures seem anchored to the cell on the page - as opposed to some notional cell that gets moved around when sorting. Thus I saw numbers rearranged, but the pictures fixed at the original grid position, when I sorted the columns - it implies to me that a sort moves data around between cells, rather than "moving the cells". If you see what I mean; not intuitive. * Pictures seemed to go away when their cell was deleted by deleting the column, and seem to move with the cell when rows or columns are inserted. Much as expected. I rather get the impression you want the pictures to be anchored to the /text/ not the /cell/, so they move with the data - correct? If so, you would seem out of luck :-( -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED] Mike Scott, Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
