How to operate only on selected cells in a table?

Question

How to operate only on selected cells in a table?Thanks to so many enthusiastic people for the pointers., I've learned that I can operate on the current table accurately.I would also like to know how to operate on the currently selected cell.For example, in the script below, the entire table is now filled with “-” for empty cells.How do I change it to only modify the selected cells.Thank you very much. var cell = app.activeDocument.selection[0].parent;
var myTable = cell.parent;
   for (var i=0; i<myTable.columns.length; i++){ 
   for (var j=0; j<myTable.columns.item(i).cells.length; j++){ 
      if (myTable.columns.item(i).cells.item(j).contents == ""){ 
         myTable.columns.item(i).cells.item(j).contents ="-";
         } 
      }

}

Robert at ID-Tasker · Accepted Answer

In case of selected Cells - the return result is a bit misleading - selection[0] returns not just a cell - but a collection of Cells. var mySelectedCells = app.activeDocument.selection[0].cells;

m1b · Answer

Hi @dublove, this is a weird case—when the selection is a range of cells, app.selection[0] gives you a [Cell] object, but it isn't a normal Cell, it contains all the cells in it's `cells` property, as Robert mentioned. It is actually a similar object that you get when you make an itemByRange collection, so that you can do something like this:

app.activeDocument.selection[0].contents = '-';

and it will put text in every selected Cell.

But for most purposes, getting the selection's cells like Robert said, is best.

- Mark

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded