Link Search Menu Expand Document

SSpread.Value Property

Set values ​​such as strings, numbers, and dates in cells.

Before setting this property, use the Col , Row properties, and so on to specify what to do.

The initial value is a blank character string.

The rules for getting and setting this property differ depending on the cell data type ( CellType property).

For details , refer to Obtaining and setting values ​​for each cell data type .

You can get the unformatted string with the Value property and the formatted string with the Text property.

Example of use

Col = 2;
Row = 3;
Value = "sample1";
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
Value = "sample2";
BlockMode = $ FALSE;

Related item CellType , ClipValue , Text properties