SSpread.GetFirstValidCell Method

Explanation Gets the column number and row number of the first valid cell.

You can look up the first valid cell, excluding hidden cells, such as when the row height or column width is 0.

If the EditModePermanent property is $TRUE, locked cells, label-type, and picture-type cells are not treated as valid cells.

Call format GetFirstValidCell()

Return value

Record object with the following child objects

Type	Name	Description
Number	Col	Column number of the first valid cell
Number	Row	Row number of the first valid cell

Arguments None

Exception EXT-28 An error occurred in the GetFirstValidCell method

Example of use

    var ret = GetFirstValidCell();
    MessageBox(strf("The first valid cell is(%1,%2)", ret.Col, ret.Row));

Related item CellType, ColWidth, EditModePermanent, Lock, RowHeight properties
GetLastValidCell method