Skip to main content
S
surya @safran
Inspiring
July 15, 2020
Question

Is there an extendscript to find text overflow in a table cell

  • July 15, 2020
  • 1 reply
  • 804 views

My process includes (80+ pages of table content)

1. import the data from excel to FM with rich text format to get as a table format.

2. Apply proper para formating and table row sizing etc.

3. Run through all the pages to check any text overlow in any cell.

4. Copy the overflowed text and paste it as a new row below and remove the overflowed text from the current row.

 

If there's a script to find way for step 3&4 would be much appreciated..

    This topic has been closed for replies.

    1 reply

    R
    Russ Ward
    Legend
    July 16, 2020

    Hi,

     

    The way to know if a cell has overflowed is with cell.Overflowed. There is a discussion on that here:

     

    https://community.adobe.com/t5/framemaker/finding-cell-overflow-in-table-problem-with-script/m-p/7663483?page=1#M44050

     

    However, to know how much text has overflowed seems very difficult. It seems you would have to cut/delete in increments until Overflowed becomes false. If there is a better way, I don't know what it is.

     

    Hope this helps some.

    Russ

      S
      surya @safranAuthor
      Inspiring
      July 16, 2020

      Russ, would the confrm command be used in place of alert?

      confirm (message[,noAsDflt ,title ]);

      Can we define what to do for yes or no?

       

      S
      surya @safranAuthor
      Inspiring
      July 21, 2020

      Hi, your questions are difficult to understand. It seems you may need to spend more time with the basics of scripting before we can effectively help you here.

       

      The script in the other thread does what you asked... searches the entire document for overflow cells.

       

      Regarding confirm(), it is a boolean return. If you click Yes, it returns 1 (true). Otherwise 0 (false). It is then your decision what to do with the answer.

       

      Russ


      Could you please help me with, the script takes to the cell or page where the text overflow in the cell takes please?

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices