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.