Replied 10 September 2017, 1:56 am EST
Hi,
Spread does not support setting the image as a value like that. It does support adding a drawing object like this:
<div style="font-family:arial, sans-serif;"><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">using System;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">using System.Windows;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">using System.Windows.Controls;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">using GrapeCity.Windows.SpreadSheet.UI;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">using GrapeCity.Windows.SpreadSheet.Data;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">
</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">namespace SilverlightApplication37</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">{</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public partial class MainPage : UserControl</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> {</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public MainPage()</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> {</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> InitializeComponent();</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> this.gcSpreadSheet1.Sheets.Clear();</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> this.gcSpreadSheet1.Sheets.Add(new MyWorksheet());</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> var sheet = this.gcSpreadSheet1.ActiveSheet;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">
</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public class ControlDrawingObject : CustomDrawingObject</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> {</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> private Control _rootElement;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public ControlDrawingObject(int row, int col, Control control) : base(row, col) { _rootElement = control; this.ShowDrawingObjectOnly = true; }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public override FrameworkElement RootElement</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> {</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> get { _rootElement.Margin = new Thickness(1); return _rootElement; }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">
</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public class MyWorksheet : Worksheet</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> {</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> public bool DrawingObjectVisible { get; set; }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"><div> public override <span class="il" style="background-position:initial initial;background-repeat:initial initial;">DrawingObject</span>[] GetDrawingObject(int row, int column, int rowCount, int columnCount)</div><div> {</div></div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> if (row != 1 || column != 1) return base.GetDrawingObject(row, column, rowCount, columnCount);</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">
</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> <span class="il" style="background-position:initial initial;background-repeat:initial initial;">DrawingObject</span> dobj;</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">
</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> dobj = new ControlDrawingObject(row, column, new HyperlinkButton() { Content="This is a link", NavigateUri=new Uri("
http://www.google.com") });</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">
</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> return new <span class="il" style="background-position:initial initial;background-repeat:initial initial;">DrawingObject</span>[] { dobj };</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;"> }</div><div style="font-family:Helvetica, 'Helvetica Nueue';font-size:16px;">}</div></div>
So you should be able to replace the code for creating the ControlDrawingObject to use your image instead of the HyperlinkButton.
The next release of Spread WPF-Silverlight will have a new feature that will make this possible without the inherited MyWorksheet class (i.e. a new API for setting the drawing object).