1 Reply Latest reply on Dec 30, 2008 9:18 AM by (Fra_Innocent)

    Cell formating via scripting

      I am trying to do two cell formating tasks via scripting.

      1) I have a two column table and I would like to be able to have a cellstyle applied to the top cell of each row based on the content of the bottom cell. That is, if row1cell2 has text "Hey" I would like to have row1cell1 to be given the cellStyle "Hey" for instance. I am a novice to scripting and have tried several methods, but each time I have failed.

      2) Second, I would like to be able to adjust the width and height of a row or column in response to the length of the text string. For instance, if the length of my text string "Hey" is 12 pts, could I have the width adjust to 12 pts? Or, in a slightly more complicated example, if I had the word H-e could I tell the script to make the width the length of just H- and ignore everything after the -dash?

      Any help would be appreciated. Please let me know if I can clarify this at all.