Example

The following example sets the contents of the specified cell.

C++

m_Spread.SetReDraw(False);
for(y = 0; y <= Dify; y++)
    for(x = 0; x <= Difx; x++)
        m_Spread.SetText(CX + x, CY + y, Array[y][x]);
    m_Spread.SetReDraw(True);

Visual Basic

CX = fpSpread1.SelBlockCol
CY = fpSpread1.SelBlockRow
Difx = fpSpread1.SelBlockCol2 - fpSpread1.SelBlockCol
Dify = fpSpread1.SelBlockRow2 - fpSpread1.SelBlockRow
fpSpread1.ReDraw = False
For y = 0 To Dify
    For x = 0 To Difx
        fpSpread1.SetText CX + x, CY + y, Array(y, x)
    Next x
Next y
fpSpread1.ReDraw = True