Is it possible to only select the cells in a column that have applied "body" cellstyle

[dublove]

Sometimes the table is too long, even several pages, you need to exclude the header, continuation, and end of the table, dragging and selecting may be your best way, but it is still a bit cumbersome and troublesome.

What's the best way to do this?
Or a script that selects only the cells in the columns that have the body style applied to them.

After selecting a column, you can perform many operations, and then selecting a row is faster!

Thank you very much.

(Attachments available)

[Robert at ID-Tasker]

It all depends on the structure of your table. 

If you've it configured "properly" - defined number of header and footer rows - you can use this info to calculate range to select - in script. 

If you want to select rows that have specific ParaStyle / CellStyle applied - you need to check every cell in the range you want to select. 

[FRIdNGE · Accepted solution]

Basically, something like that:

/*
    _FRIdNGE-0799_ColumnCellsSelectionBasedOnActiveCell.jsx
    Script written by FRIdNGE, Michel Allio [15/02/25]

    See: https://community.adobe.com/t5/indesign-discussions/is-it-possible-to-only-select-the-cells-in-a-column-that-have-applied-quot-body-quot-cellstyle/td-p/15155765
*/

app.doScript("main()", ScriptLanguage.javascript, undefined, UndoModes.ENTIRE_SCRIPT, "To Layout! …");

function main() {

    // Place the Cursor in any Cell:
    var myCell = app.selection[0].parent;
    var myCellStyle = myCell.appliedCellStyle;
    var myColumnCells = myCell.parentColumn.cells;
    var C = myColumnCells.length,  c;
    var myCounter = 0;
    for ( c = 0; c < C; c++ ) if ( myColumnCells[c].appliedCellStyle === myCellStyle ) {
        // Treatment To Be Done:
        myColumnCells[c].fillColor = "red";
        myCounter++
    }

    alert( "On Column " + Number(myCell.parentColumn.index+1) + ": " + myCounter + " Cells")

}

This Script will apply a "red" color to all the right cells of a column.

(^/)  The Jedi

[Robert at ID-Tasker]

@FRIdNGE

But @dublove wants to SELECT them?

If CellStyle is already applied to the cells - what's the point of creating local override? 

[dublove]

HI FRIdNGE!

Thank you very much

This script of yours is running fine.

Learning.......

var cell = app.activeDocument.selection[0].parent;
function selectColumn() {
	cell.parentColumn.select();
}
selectColumn();

That's all I know
It can select current column.

myColumnCells[c].select();

How does this sentence transform to select all eligible Cells

[Robert at ID-Tasker · Accepted solution]

@dublove 

This should work:

app.doScript("main()", ScriptLanguage.javascript, undefined, UndoModes.ENTIRE_SCRIPT, "To Layout! …");

function main() {

    // Place the Cursor in any Cell:
    var myCell = app.selection[0].parent;
    var myCellStyle = myCell.appliedCellStyle;
    var myColumnCells = myCell.parentColumn.cells;
    var C = myColumnCells.length,  c;
    var myCounter = 0;
    var StartRow = 0;
    var EndRow = 0;
    for ( c = 0; c < C; c++ ) 
    {
//        alert(c);
        if ( myColumnCells[c].appliedCellStyle === myCellStyle ) 
        {
            if (StartRow)
            {
            }
            else
            {
                StartRow = c;
            };
        }
        else
        {
            if (StartRow)
            {
                EndRow = c;
                break;
            };
        };
    };
    if (StartRow > 0 && EndRow == 0)
    {
        EndRow = c;
    };
    if (StartRow>0 && EndRow > 0)
    {
     
   app.select(myCell);
   app.select(myCell.parent.cells.itemByRange(myColumnCells[StartRow], myColumnCells[EndRow]));
    };
};

Of course you can convert it to a function.

[dublove]

Hi Robert at ID-Tasker

Thanks.

It's no response.
I still don't know where to add "select();"
Multiple if else and I'm getting a little dizzy ......

[Robert at ID-Tasker]

Right, sorry. 

You've to add this before the last "};":

if (StartRow>0 && EndRow > 0)
{
app.select(myCell.parent.parent.itemByRange(myColumnCells[StartRow], myColumnCells[EndRow]));
};

[dublove]

nothing new show up

[Robert at ID-Tasker]

nothing new show up

By @dublove

Right, sorry, replying from my phone. 

It should be OK now - please copy the whole code again.

[Robert at ID-Tasker]

Multiple if else and I'm getting a little dizzy ......

By @dublove

In short:

• iterate though all cells and check if applied CellStyle is the same, 
• If StartRow is "0" - remember current value of "c" - start of the region - if not "0" - ignore, as the start of the region was already found, 
• If applied CellStyle isn't as the one we're looking for - check if StartRow was found - if it was - then remember "c" as EndRow - then exit anyway as we don't want to mix regions.

[Robert at ID-Tasker]

@dublove

I've just edited my code - moved "break;" outside of the if.

And added select() part. 

[dublove]

I updated your new code and it's still not responding.

[Robert at ID-Tasker]

I updated your new code and it's still not responding.

By @dublove

I forgot about using itemByRange() - please check again. 

[dublove]

Lost.
Don't know where to stop.

[Robert at ID-Tasker]

Lost.
Don't know where to stop.

By @dublove

Still doesn't work? Do you get any errors? 

[dublove]

No hints.
I used
alert( “Done! ...” )
Tests don't pop up in many places.

[Robert at ID-Tasker]

@dublove 

Can you post your code? 

I think I know what's "wrong" 😉 

[dublove]

Please look at FRIdNGE''s code.

Shouldn't the next sentence be before {?
if ( myColumnCells[c].appliedCellStyle === myCellStyle )

[Robert at ID-Tasker]

@dublove

That's what I thought... 

My code was a REPLACEMENT of @FRIdNGEs main() function - not a standalone piece of code - you haven't copied the "calling" part from the beginning:

app.doScript("main()", ScriptLanguage.javascript, undefined, UndoModes.ENTIRE_SCRIPT, "To Layout! …");

Without that - my piece of code is just bunch of characters. 

[dublove]

Look at the code I posted again, patched the top of the FRIdNGE

Shouldn't the next sentence be before {?
if ( myColumnCells[c].appliedCellStyle === myCellStyle )

app.doScript("main()", ScriptLanguage.javascript, undefined, UndoModes.ENTIRE_SCRIPT, "To Layout! …");

function main() {

    // Place the Cursor in any Cell:
    var myCell = app.selection[0].parent;
    var myCellStyle = myCell.appliedCellStyle;
    var myColumnCells = myCell.parentColumn.cells;
    var C = myColumnCells.length,  c;
    var myCounter = 0;
    var StartRow = 0;
    var EndRow = 0;
    for ( c = 0; c < C; c++ ) 
    {
        if ( myColumnCells[c].appliedCellStyle === myCellStyle ) 
        {
            if (StartRow)
            {
            }
            else
            {
                StartRow = c;
            };
        }
        else
        {
            if (StartRow)
            {
                EndRow = c;
            };
            break;
        };
    };
    if (StartRow > 0 && EndRow == 0)
    {
        EndRow = c;
    };
    if (StartRow>0 && EndRow > 0)
    {
     
   app.select(myCell.parent.parent.itemByRange(myColumnCells[StartRow], myColumnCells[EndRow]));
    };
};

[Robert at ID-Tasker]

@dublove 

OK, got to my laptop - now it's working - please copy the code again.

But because, you've all "body" rows set as body in thhe Table's applied TableStyle - the whole column - less the header and footer rows - will be selected anyway...

So, what I've suggested earlier - subtractig this info from the total number of rows would make more sense...

[Robert at ID-Tasker]

@dublove 

And this is the effect - if you actually apply "body" CellStyle to only some Cells:

[dublove]

How to avoid choosing footer?

myColumnCells[EndRow-1]　？

[Robert at ID-Tasker]

How to avoid choosing footer?

myColumnCells[EndRow-1]　？

By @dublove

But ONLY if you don't have CellsStyles applied directly in your Table.

Like I've said before - you don't have CellStyles applied in your Table - you only have them defined in the TableStyle applied - so they can't be "found" / recognised through checking what CellStyle is applied to the cell.

So this will nevver gonna work.