Cell.SetData Method (Object, Int32, Int32)

Sets the data of the cell, represented by this object.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public void SetData (
    Object value,
    int dcolumn,
    int drow
)

Visual Basic

Public Sub SetData( _
    value As Object, _
    dcolumn As Integer, _
    drow As Integer _
)

 Parameters

value

The new data of the cell.

dcolumn

If value represents a formula, this is the column offset of all relative cell references. Otherwise, this value is ignored.

drow

If value represents a formula, this is the row offset of all relative cell references. Otherwise, this value is ignored.

 Remarks

If value is a string, starting with an equal sign '=', it is interpreted as a formula. To specify a string, starting with an equal sign as cell data, prefix the string with a single apostrophe '''. The parameters dcolumn and drow can be used to offset all relative cell references in the formula. For example, the following call SetData("=A1", 1, 2) will actually set the formula "=B3" as data in the cell.