On 06/18/09 08:18, Jan Holst Jensen wrote:
Whether it falls into that category really depends on how it behaves
:-). Are you suggesting adding shapes on top of the cells that I want
custom rendered - and then move the shapes whenever cells change so the
shapes follow the underlying data around ? This is very much like the
"you don't want to know" solutions that I hint at. Not easy to get
working in a robust fashion - uh-oh.
But maybe that is not what you suggested - can I really embed
pictures/shapes in a cell so they are truly in-line in-the-cell ?
My experience with adding graphics to a sheet (in both Excel and Calc)
has always been that the graphics will not follow data in the cell.
Let's say you have an address book in a sheet - column A holds names and
column B holds the people's pictures (that is: pictures are put in the
document on top of column B). As soon as you e.g. change the sort order
of column A a name may then be matched with some random picture since
the pictures are not moved when cell data is shuffled around. This is
the number one problem with all solution attempts that just add standard
graphics to a sheet.
There are some issues with shapes and their positions. Issue 102061 will
improve that a bit, but basically the component would have to refresh
the shapes. A special API for cell rendering would certainly make things
easier, but we don't have that.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
