SSpread.ClipValue Property

Set the value in the cell block.

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

(This property does not require the BlockMode property to be set to $TRUE in advance when dealing with cell blocks.)

The value for each cell is set by separating the columns with the tab character (￥ t) and the rows with the newline character (￥ r ￥ n).

ClipValue behaves as if you were setting a value in the Value property for each cell. It is more efficient than setting it for individual cells with the Value property.

Get and set the value for each cell data type

Example of usage

Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
Clip = "あ￥tい￥tう￥r￥nア￥tイ￥tウ￥r￥nＡ￥tＢ￥tＣ";
 
Col = 4;
Row = 4;
Col2 = 5;
Row2 = 5;
print(ClipValue);