Den 2010-12-01 20:50:20 skrev Rob Clement <[email protected]>:
On 01/12/2010 18:51, Andreas Säger wrote:
Am 01.12.2010 19:11, Johnny Rosenberg wrote:
Den 2010-12-01 18:45:14 skrev Andreas Säger <[email protected]>:
Am 01.12.2010 17:06, Johnny Rosenberg wrote:
No, only to a cell or a page. Remember this is OpenOffice.org Calc,
not
OpenOffice.org Writer.
And by far more important: it is not OpenOffice.org Base where you can
store things like catalog data (including pictures as "cell values")
and create catalogues by means of the Oracle Report Builder AddOn.
Yes, but I am not used to OpenOffice.org Base.
Still, no matter if there are better ways or not, I think this is a
bug.
Why anchor to a cell if the image won't follow sort? And, as far as I
heard, Excel can do this… (but I can't use Excel since Excel lacks the
most important feature: Multi operating system support).
Well, that was a problem even with cell annotations until 2.3(?) where
it has been fixed. This kind of problem seems to be very hard to fix for
other shapes.
Spreadsheets are not intended to do such things (hey, they name it
"Calc"). Pictures are meant to be decorative or explanatory in respect
to the sheet, not in respect to contained database data.
Excel is the one and only spreadsheet program which encourages its users
to misuse it as a database. Millions of users did even learn VBA to make
this dream come true with devastating consequences for the overall
busines IT.
In the forum topic you linked in the issue report, there is another
hyperlink to a hyperlink solution. Simply store a file name together
with some descriptive name and compose a hyperlink by means of a
formula.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Johnny
I assume from what you are saying that the text and the picture are in
the same cell. Am I correct?
what happens if you put the text in one cell and the picture in the next
cell in the same row and then sort on both columns? Does it move then?
That was what I did. There is no text in the cell where I put the Image.
Sorry if this is a dumb question
Not at all.
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
