I'm new to this forum. This is my first question, its been stumping me for a while. Hopefully someone can help.
I've written a script in 123 which takes the following input:
LocationX LocationY Type
Using this input, I create a circle at the designated x and y location on sheet "draw". The following is a portion of the script that I use:
Type = [A:C1..AC65500].cell(offsetRow,0).contents
Left = [A:A1..A:A65500].cell(offsetRow,0).contents 'LocationX
Top = [A:B1..A:B65500].cell(offsetRow,0).contents 'LocationY
Right = Left + 100
Bottom = Top + 100
[draw].NewEllipse Left, Top, Right, Bot
I use a looping routine to step through a couple thousand entries and draw the ellipses. The problem I encounter is that I want to use the "Type" value for each ellipse to change the ellipse color. I have not figured out how to select a single ellipse and then change its background color.
Any suggestions?
BBord
I've written a script in 123 which takes the following input:
LocationX LocationY Type
Using this input, I create a circle at the designated x and y location on sheet "draw". The following is a portion of the script that I use:
Type = [A:C1..AC65500].cell(offsetRow,0).contents
Left = [A:A1..A:A65500].cell(offsetRow,0).contents 'LocationX
Top = [A:B1..A:B65500].cell(offsetRow,0).contents 'LocationY
Right = Left + 100
Bottom = Top + 100
[draw].NewEllipse Left, Top, Right, Bot
I use a looping routine to step through a couple thousand entries and draw the ellipses. The problem I encounter is that I want to use the "Type" value for each ellipse to change the ellipse color. I have not figured out how to select a single ellipse and then change its background color.
Any suggestions?
BBord