Cell.setData Method (Object, Int32, Int32)

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

Namespace: com.mindfusion.spreadsheet
Package: com.mindfusion.spreadsheet

 Syntax

Java

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

 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.