AppleScript and Numbers: Merging a Range

Merging a Range

The range class can be the target of the merge and unmerge commands.

merge v : Merge a specified range of cells.

merge range

unmerge v : Unmerge all merged the cells in a specified range.

unmerge range

The merging of cells is often done for organizational or esthetic reasons, as a way to separate or highlight data in a table. In the example table shown below, alternating rows have been merged to provide a buffer between the rows that will contain the data.

NOTE: You can merge cells wholly within a table header region or the body. You cannot merge cells that span those regions. e.g. If you set the number of header columns to 5 then merge range "A1:E1" will work but merge range "A1:F1" will not, because F1 is in the body and the others are in the header.

The following example script will create such a table on the current spread of the frontmost document:

Create Table with Alternating Merged Rows

property rowCount : 10

property columnCount : 10

property useRowHeaders : true

property useColumnHeaders : true

tell application "Numbers"

activate

if not (exists document 1) then make new document

tell document 1

tell active sheet

set thisTable to ¬

make new table with properties ¬

{row count:rowCount, column count:columnCount}

tell thisTable

set height of every row to 40

set width of every column to 60

if useRowHeaders is true then

set startRowCellIndex to 2

else

set startRowCellIndex to 1

end if

if useColumnHeaders is true then

set startColumnCellIndex to 3

else

set startColumnCellIndex to 2

end if

repeat with i from startColumnCellIndex to rowCount by 2

-- define the cell range to merge

set rangeStart to name of cell startRowCellIndex of row i

set rangeEnd to name of cell -1 of row i

set the rowRange to rangeStart & ":" & rangeEnd

-- merge the specified range

merge range rowRange

tell cell 2 of row i -- format the merged area

set background color to {59121, 59119, 59120}

set text color to {46137, 46137, 46137}

set alignment to center

set vertical alignment to center

set font size to 18.0

set value to "▼"

end tell

end repeat

set the selection range to cell range

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.