Cell.setData Method (Object, Int32, Int32, Boolean)

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,
    boolean isCultureInvariant
)

 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.

isCultureInvariant

true to interpret the specified data as a culture-invariant; false to interpret it in the context of the worksheet's locale.

 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.