How to select a row in a table from cursor position

[Jean-Claude Tremblay]

Hi,

This is probably simple, but I can’t find how.

I need a snippet that will select and entire row from the location of the insertion of the cursor. Similar to the InDesign «Select Row» command.

Sorry for the newbie question.

[Trevor: · Accepted solution]

Hi Jean-Claude

function selectRow(s) {
    s = s || app.selection[0];
    if (!s) {
        return 'no selection';
    }
    while (s.constructor !== Cell){
        s = s.parent;
        if (s.constructor === Application) {
            return 'no cell found';
        }
    }
    s.parentRow.select();
}
selectRow();

HTH

Trevor

[Jean-Claude Tremblay]

Thanks Trevor... That did it!

[M.Hasanin]

Please @Trevor: Can this script modified to avoid selecting the header cell (in the same column)?

Thanks in Advance

[brian_p_dts]

To be clear, you want to select a column, not a row, but exclude header cells? If so, try this: 

function selectColumn(s) {
    s = s || app.selection[0];
    if (!s) {
        return 'no selection';
    }
    while (s.constructor !== Cell){
        s = s.parent;
        if (s.constructor === Application) {
            return 'no cell found';
        }
    }
    var target = s.parentColumn;
    var pccells = target.cells;
    for (var i = 0; i < pccells.length; i++) {
        if (pccells[i].rowType !== RowTypes.HEADER_ROW) {
            pccells[i].select();
        }
    }
}

selectColumn();

[M.Hasanin]

Thanks  a lot @brian_p_dts

[M.Hasanin]

Please @brian_p_dts  What is the Opposite Command of (Select()), i searched the DOM many times but didnt find anything, just deselect for item pages, but i mean deselect cells opposite of select();

Thanks

[brian_p_dts]

app.selection = null will remove all selections. The select() method has optional arguments that you can pass to it to replace the existing selection (default is to add to selection). 

[M.Hasanin]

Thanks a lot @brian_p_dts