CreativePro Forum

Return to Member Forum

• Author
  Posts
• • January 15, 2019 at 3:17 am #113588
    Purple Monkey

    Member

    I found this script, which is very close to what I need. But instead of it merging the cells with the one above I need it to merge with the cell to left of any empty cell.

    I have tried to experiment with it and manged to get it to merge horizontally once but it merge three cells that weren’t empty into one.

    Would be greatful for any help

    Thanks

    var myDoc = app.activeDocument;

    myPage = myDoc.pages;

    for (var p=0; myPage.length>p; p++){

    try{

    var myTable = myPage[p].textFrames.everyItem().tables.everyItem();

    if (myTable.constructor.name == ‘Table’){

    for (var t = myTable.cells.length – 1; t >= 0; t–)
    {

    if (myTable.cells[t].contents==””){
    var w = myTable.columns.length;
    myTable.cells[t-w].merge(myTable.cells[t]);

    }

    }

    }

    }

    catch(e){}

    }

  • January 16, 2019 at 12:46 am #113667
    Peter Kahrel

    Participant

    It’s not so clear what’s going wrong. And that script is rather inefficient — here is another approach:

    var i, j, cells;
    // Get all the rows in the document
    var rows = app.documents[0].stories.everyItem().tables.everyItem().rows.everyItem().getElements();
    for (i = 0; i < rows.length; i++) {
    	// Get all the cells in a row
    	cells = rows[i].cells.everyItem().getElements();
    	for (j = cells.length-1; j >= 1; j--) {
    		if (cells[j-1].contents == '') {
    			cells[j-1].merge (cells[j]);
    		}
    	}
    }

    P.

    • January 16, 2019 at 3:00 am #113674
      Purple Monkey

      Member

      Hi Peter,

      Thanks for taking the time and looking at my question.

      What I need though is for the cells to merge to the left if the cell to it’s right is empty – such as…

      __________________________
      | “Some text”|”” |
      __________________________

      |”Some text” |”Some text”|
      __________________________

      would become…

      __________________________
      | “Some text” |
      __________________________

      |”Some text” |”Some text”|
      __________________________

      Thanks again

      Rob

  • January 16, 2019 at 3:37 am #113675
    Peter Kahrel

    Participant

    Missed that… Change this line:

    if (cells[j-1].contents == '')

    to this:

    if (cells[j].contents == '')

    P.

    • January 16, 2019 at 4:07 am #113679
      Purple Monkey

      Member

      Bravo – thank you!

      I must have changed every variable other than that one.

      Thanks again

      PM

• Author
  Posts