Re: Addressing a cell in "Numbers"
Re: Addressing a cell in "Numbers"
- Subject: Re: Addressing a cell in "Numbers"
- From: Michelle Steiner <email@hidden>
- Date: Sat, 10 Oct 2009 15:28:18 -0700
On Oct 10, 2009, at 2:50 PM, George Wright wrote: But I'm now stuck on these problems: • How do I address a cell using the row and column header labels?
I can address a row or column by its label:
tell application "Numbers" tell document "untitled" tell sheet 1 tell table 1 value of cells of column "foo" value of cells of row "bar"
end tell end tell end tell end tell
But I can't get a cell where they intersect; the following line returns the column, and ignores the row part completely. column "foo" of row "bar" And: • How do I address a cell range?
You don't have to say "cell rowNum of column colNum"; you can use the format I show in example below.
tell application "Numbers" tell document "untitled" tell sheet 1 tell table 1 set value of cells of range "b2:d5" to 13 set the value of cell "c3" to "text" end tell end tell end tell end tell
Hopes this helps somewhat.
-- Michelle
-- 26.2 Because I can
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden