AppleScript and Numbers: Styling Cells

Styling Cells

Cells inherit their styling properties, such as alignment and text style, from the range class. The following demonstrates the setting of all of the inherited cell properties, to create a patchwork-quilt-style table:

Create Random Cell Color Table

set rowCount to 10

set columnCount to 12

tell application "Numbers"

activate

if not (exists document 1) then make new document

tell the front document

tell active sheet

set thisTable to ¬

make new table with properties ¬

{row count:rowCount, column count:columnCount}

tell thisTable

-- style the cells of the table

set the width of every column to 60

set the height of every row to 40

set alignment of every cell to center

set vertical alignment of every cell to center

set font size of every cell to 16

repeat with i from 1 to the count of cells

-- show the address of the cell

set value of cell i to (name of cell i)

-- generate a random background color

set RcolorValue to random number from 0 to 65535

set GcolorValue to random number from 0 to 65535

set BcolorValue to random number from 0 to 65535

-- set the background color of the cell

set the background color of cell i to ¬

{RcolorValue, GcolorValue, BcolorValue}

-- ensure that text color will constrast with background color

if RcolorValue is greater than 32767 then

set RcolorValue to 0

else

set RcolorValue to 65535

end if

if GcolorValue is greater than 32767 then

set GcolorValue to 0

else

set GcolorValue to 65535

end if

if BcolorValue is greater than 32767 then

set BcolorValue to 0

else

set BcolorValue to 65535

end if

-- set the color of the text

set the text color of cell i to ¬

{RcolorValue, GcolorValue, BcolorValue}

end repeat

end tell

TOP | CONTINUE

DISCLAIMER

THIS WEBSITE IS NOT HOSTED BY APPLE INC.

Mention of third-party websites and products is for informational purposes only and constitutes neither an endorsement nor a recommendation. MACOSXAUTOMATION.COM assumes no responsibility with regard to the selection, performance or use of information or products found at third-party websites. MACOSXAUTOMATION.COM provides this only as a convenience to our users. MACOSXAUTOMATION.COM has not tested the information found on these sites and makes no representations regarding its accuracy or reliability. There are risks inherent in the use of any information or products found on the Internet, and MACOSXAUTOMATION.COM assumes no responsibility in this regard. Please understand that a third-party site is independent from MACOSXAUTOMATION.COM and that MACOSXAUTOMATION.COM has no control over the content on that website. Please contact the vendor for additional information.