Link Search Menu Expand Document

SSpread.GetCellPos Method

Explanation Gets the left edge position, top edge position, column width, and row height of the specified cell.
Call format GetCellPos(col, row)
Return value Number object with the following child objects
Constant Value Description
Number X Distance from the left edge of the spreadsheet to the left edge of the cell
Number Y Distance from the top of the spreadsheet to the top of the cell
Number Width Cell column width
Number Height Cell row height
The Value property returns $TRUE if the cell is in the display area, $FALSE otherwise .
Arguments col Cell column number
row Cell row number
Exception None
Example of use
   var ret = GetCellPos(1, 1);
    if (ret == $TRUE) {
        MessageBox(strf("X coordinate:%1 Y coordinate:%2", ret.X, ret.Y));
    }
    
Related item GetCelFromScreenCoord method