SSpread.GetLastValidCell Method

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

The last valid cell except the hidden cells can be found out, 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 GetLastValidCell()

Return value

Record object with the following child objects

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

Arguments None

Exception EXT-28 An error occurred in the GetLastValidCell method

Example of use

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

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