« Return to Thread: Calc: Extension providing custom cell rendering - possible ?
Re: Calc: Extension providing custom cell rendering - possible ?
by Jan Holst Jensen
::
Rate this Message:
Niklas Nebel wrote:
> On 06/13/09 11:45, Jan Holst Jensen wrote:
>> I would like to be able to render cell content in an owner-draw fashion.
>>
>> An intuitive way to control this for the end-user (or at least for
>> me) would be to add a new format to "Format Cells". I was thinking
>> along the lines of adding an item to "Numbers"->"Category", say "SVG
>> image", and cells containing SVG instructions would display the SVG
>> graphics instead of the SVG text. Alternatively a "Format" could be
>> added to the "User-defined" category ?
>>
>> The actual rendering instructions that I would like to support are
>> not SVG but "protein rendering info" as shown at
>> http://www.biochemfusion.com/downloads/protein_renderer.html.
>> However, the two problems are equivalent and the rendering info could
>> easily be translated to SVG if necessary.
>>
>> Can this be done as an UNO extension or would this need to added
>> directly into Calc as native functionality ?
>>
>> PS: I've seen this implemented by a number of vendors in Excel but
>> trust me - you don't really want to know how they do it (seriously
>> fun hacking necessary) :-).
>
> There is no such API available. But an extension could register as a
> listener for value changes, and then insert shapes into the document
> for the desired output. Or would that already fall into the "don't
> really want to know" category?
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.
Cheers
-- Jan
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...
> On 06/13/09 11:45, Jan Holst Jensen wrote:
>> I would like to be able to render cell content in an owner-draw fashion.
>>
>> An intuitive way to control this for the end-user (or at least for
>> me) would be to add a new format to "Format Cells". I was thinking
>> along the lines of adding an item to "Numbers"->"Category", say "SVG
>> image", and cells containing SVG instructions would display the SVG
>> graphics instead of the SVG text. Alternatively a "Format" could be
>> added to the "User-defined" category ?
>>
>> The actual rendering instructions that I would like to support are
>> not SVG but "protein rendering info" as shown at
>> http://www.biochemfusion.com/downloads/protein_renderer.html.
>> However, the two problems are equivalent and the rendering info could
>> easily be translated to SVG if necessary.
>>
>> Can this be done as an UNO extension or would this need to added
>> directly into Calc as native functionality ?
>>
>> PS: I've seen this implemented by a number of vendors in Excel but
>> trust me - you don't really want to know how they do it (seriously
>> fun hacking necessary) :-).
>
> There is no such API available. But an extension could register as a
> listener for value changes, and then insert shapes into the document
> for the desired output. Or would that already fall into the "don't
> really want to know" category?
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.
Cheers
-- Jan
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...
« Return to Thread: Calc: Extension providing custom cell rendering - possible ?
| Free embeddable forum powered by Nabble | Forum Help |
